Cascading Parameters Default Value

[Andrew]

Good Morning,

 

Apologies if this has been asked before but I had difficulty finding a solution.

I have a report parameter who's datasource (I'm using object data source) is dependent on three parameters above it (Location, Date & Line Number). Once these have been selected, it generates the available values for my job parameter but I would like the first index of the available values to be automatically selected.

 

Currently it states 'Please input a valid value' but the display shows the first displayMember from the available values (Picture attached). On a side note, I also can't select the first value from the list straight away, I need to get to the second value and go back to the first to get it to register.

Any help would be appreciated.

Many thanks,

Andrew

[Stef]

Hi Andrew,

The attached demo report illustrates cascading parameters, where data is obtained from AdventureWorks database. the report can be previewed in the Standalone Report Designer of R3 2016 or later. Parameters work correctly.


It looks like the controlling parameters have default values. Please debug the data-retrieval method of the last parameter and if it gets suitable data based on the values passed by the controlling parameters.

In order to provide you more accurate suggestions, please post the report definition, allowing us to create a demo report locally, or open a support ticket and send us the report, including the data-retrieval method and test data.

Regards,
Stef
Telerik by Progress

[Andrew]

Thanks Stef,

After looking at the example report you provided, I got the answer..

For anyone else who has this problem:

Set the value of your cascaded report parameter to :- =First(Fields.XYZ) with XYZ being the name of the valueMember of your datasource.

 

Many thanks,

Andrew