Problem with Cascading prompts

building reports crystal reports
1

Hi Gurus,
I’m trying to create cascading list of values for my report. Below is the scenario I have State & Sales Manager to show in report. A sales manager could be involved in multiple states. for ex

State Sales Manager
CA ABC
MA DEF
OR ABC
MN XYZ
NJ DEF
CA DEF

When I create my Business view I created cascading lov’s for State & Sales Manager which are properly showing in criteria field. But when I run the report if I select state as CA and sales manager DEF I’m getting data for both states CA & MA which is wrong. I only want to display data for CA based on my criteria. Can anyone help me how to achieve this?

Regards,
Vijay

dvijaysaradhi :us: (BOB member since 2005-09-12)

2

You need to include both prompts as criteria; you can do this in Crystal, unlike Deski or Webi. :slight_smile:

Dave Rathbun :us: (BOB member since 2002-06-06)

3

Thanks Dave,
But there is only one prompt with two levels (State & Sales Manager) and I can only compare the 2nd level which is Sales Manager. When I compare the same parameter to State it returns 0 rows.

Regards,
Vijay

dvijaysaradhi :us: (BOB member since 2005-09-12)

4

If you have a true cascading prompt, you’ll have a prompt for state and then a second for manager. If you only have one prompt, then how are you picking CA first?

Dave Rathbun :us: (BOB member since 2002-06-06)

5

Dave,

Can you have a cascading Prompt in Crystal XI R2 or 3.1 with different level fopr example:

Level 1:
Product
Level 2:
Style
Colour

Cheers

gogo (BOB member since 2005-06-03)