Skip to Content
author's profile photo Former Member
Former Member

cascade one parameter to two 2nd-level parameters

I am working in Crystal Reports 2008, with which I have limited experience thus far. I have searched the forum exhaustively and have not found an answer for the following problem: <br><br>

I have a report that is designed to compare two - and only two - groups, referred to as "pods". The pods are subgroups of markets. <br><br>

Part of the comparison is a simple side-by-side display running off a single stored procedure; I am using two subreports to produce this part of the report. The stored procedure cannot be modified, as it is in use in other reports and processing, and it is designed to take in only one "pod" value, so a multi-select pick list is not an option.<br><br>

Another part of the report takes in two "pod" values and runs analysis on them.<br><br>

I need to be able to restrict BOTH of the pod pick lists by the one market parameter.<br><br>

To wit, we have the following (sample) table, called "Levels":<br><br>

[Level1] [Level2] <br>

Mkt1 Pod1<br>

Mkt1 Pod2<br>

Mkt1 Pod3<br>

Mkt2 Pod4<br>

Mkt2 Pod5<br>

Mkt2 Pod6<br>

Mkt2 Pod7<br>

<br>

I need three pick lists total, <i>Market</i>, <i>First_Pod</i> and <i>Second_Pod</i>; both of the "pod" lists need to be restricted by the selection in the <i>Market</i> pick list. So:<br>

<br>

If Mkt1 is selected in <i>Market</i>, then <i>First_Pod</i> will show Pod1, Pod2, Pod3 <b>and</b> <i>Second_Pod</i> will also show Pod1, Pod2, Pod3. Likewise, if Mkt2 is selected, then both pod lists will contain Pod4, Pod5, Pod6, Pod7.<br>

<br>

I first set up two cascades of two levels each, <i>Market</i> & <i>First_Pod</i> and <i>Market</i> & <i>Second_Pod</i>, to make sure that the report would work on that basis. It works, but having two <i>Market</i> pick lists is not what I need.<br>

<br>

I then created a three-level cascade. (I hoped that it might have the additional functionality of the value selected in <i>First_Pod</i> being excluded from <i>Second_Pod</i>. This is an option I can pursue after I get the required functions in place.)<br>

<br>

My first attempt at the 3-level was to add [Level2] from the "Levels" table as both the second and third cascades, which resulted in an error that "a parameter by that name has already been created". It will not allow me to re-name the parameter after I create it and before I exit the window.<br>

<br>

My second attempt was to add in the "Levels" table a second time (automatically named Levels_1) and add [Level2] from Levels_1. Since the field is still named [Level2], it generated the same error as above, and it apparently doesn't have any way of distinguishing Levels.[Level2] from Levels_1.[Level2].<br>

<br>

I considered the possibility of creating a separate pick list based on a SQL statement generated from the <i>Market</i> selection, but I expect that would pop up a second parameter selection window, if it's even possible to do such a thing. Kludgy, and doesn't fit my needs.<br>

<br>

I am hoping that there is a solution that can be built within Crystal Reports, perhaps even outside the "cascading parameter" area.<br>

<br>

Many thanks for your thoughtful assistance!<br>

<br>

<br>

<br>

FWIW, I did find a similar, and still-unanswered, question from June 11 at parameter-dependancies

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Oct 29, 2010 at 03:03 PM

    Please re-post if this is still an issue or purchase a case and have a dedicated support engineer work with you directly:

    http://store.businessobjects.com/store/bobjamer/DisplayProductByTypePage∥entCategoryID=&categoryID=38156200

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.