Cascading Parameters Default Value

3 posts, 1 answers
  1. Andrew
    Andrew avatar
    3 posts
    Member since:
    Feb 2016

    Posted 14 Oct Link to this post

    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

  2. Answer
    Stef
    Admin
    Stef avatar
    3050 posts

    Posted 18 Oct Link to this post

    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
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
  3. DevCraft banner
  4. Andrew
    Andrew avatar
    3 posts
    Member since:
    Feb 2016

    Posted 18 Oct Link to this post

    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

Back to Top