BusinessObjects Board

Parameter value list according to another parameter

building reports crystal reports
#1

Hi,

I have a report with two parameters.
Parameter 1 = Order Date
Parameter 2 = Order number

When i execute the report, i select one date in parameter 1.
Depending on the date entered in parameter 1, i would have only in parameter 2 the list of order number with this order date.

How can I do this?

Thanks for help.

maz29 :fr: (BOB member since 2007-02-02)

#2

Sounds more like a cascading prompt issue. I have not done very many of them. But the ones I have done have been easy to set up.

kevlray :us: (BOB member since 2010-06-23)

#3

I have used below method long time back. you can give a try.

  1. Create a parameter,
  2. Enter Name,
  3. Select “Dynamic” under List of Values,
  4. Chose a Data Source: New,
  5. Under Value, click on the first empty row, it will give you list of fields to select, select the first level which is Order Date in your example
  6. Then click on the 2nd empty row, select the 2nd level which is Order Number
  7. Apply filters in Filter Expert using these parameters and then run.

anil.ganga1 :us: (BOB member since 2007-07-04)