Adding Cascading Prompt makes Graph disappear in Report

building reports crystal reports
1

I have a report with a Graph. We are adding a cascading prompt at the report level . This cascading prompt has 2 levels of prompts . We added the condition in the Select Expert as such :

Column 1 = ? Prompt 1
Column 2 = ? Prompt 2

Once we had the condition in Select Expert and run the report the Graph disappears . We want the Graph to still show but with no data .
How can we achieve that ?

Cheers

gogo (BOB member since 2005-06-03)

2

Hi,

Please provide the following information:

  1. Which fields are used in the chart?(On change and Show Values)
  2. Which fields are you using for cascading parameters?
  3. Which version of Crystal Reports are you using?

Cheers!!!
Manish

cr_manish :india: (BOB member since 2009-07-30)

3

Fields used in the chart are different to the cascading prompt fields.

The 2 fiels used in the cascading prompt are Product Family, Order Type
The version of Crystal Report used is 12.1.8.1186 (Patch 1.8).

gogo (BOB member since 2005-06-03)

4

Hi,

If possible send me the report with saved data. Before saving it with data remove the parameters,remove the selection criteria, place Product family and order type fields in the detail section.

Regards
Manish

cr_manish :india: (BOB member since 2009-07-30)

5

Hi gogo,

Try to create two static parameter fields. Then create a formula field then enter the formula below
try this one:

for the first parameter


WhileReadingRecords; 
SWITCH( 
{?Parameter1}=‘Country’, {Customer.Country}, 
{?Parameter1}=‘Region’, {Customer.Region}, 
True, ‘ ‘ 
)

for the second parameter


WhileReadingRecords; 
SWITCH( 
{?Parameter2}=‘Country’, {Customer.Country}, 
{?Parameter2}=‘Region’, {Customer.Region}, 
True, ‘ ‘ 
)

Apply the formula field into your graph then try to run the report.

nahtanoj :philippines: (BOB member since 2009-07-08)