Report - hide table based on value of another table

2 posts, 0 answers
  1. Kristin
    Kristin  avatar
    1 posts
    Member since:
    Jan 2013

    Posted 28 Jun 2018 Link to this post

    Hi,

    I am not sure that I have designed my report the most efficient way but that is another issue, I currently have a report that displays multiple different parameters from a database each displayed in their own table with their own sqldatasource.  This all works fine but like I say, I don't think this is the most efficient way.

     

    My issue is, there is a requirement for one of the parameters to only be displayed depending on the value of another parameter in another table.  How would I go about doing this?

     

    Any help/pointers in the right direction would be greatly appreciated.

     

    Thanks

     

    Kristin

  2. Todor
    Admin
    Todor avatar
    384 posts

    Posted 03 Jul 2018 Link to this post

    Hello Kristin,

    You can use a Report Parameter, which AvailableValues are the possible values of the field you need to filter on, and then filter the DataSource of the corresponding Table based on this parameter.

    Depending on the exact scenario, you can use also Cascading Parameters with applied filtering on Report level, or Cascading Parameters with applied filtering on data source level.

    Regards,
    Todor
    Progress Telerik
    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
Back to Top