How to use parameter coming from report to a report

2 posts, 0 answers
  1. Mohamed
    Mohamed avatar
    1 posts
    Member since:
    Jan 2016

    Posted 21 Nov 2019 Link to this post

    Hi all,

    I'm using Telerik Reporting Designer. I created 2 reports (ParentReport and ChildReport).i made a navigation from ParentReport to ChildReport using action property with some parameters. i need to know how to use these parameters in the ChildReport and also use this parameters to filter a datasource in the ChildReport.

    thanks,

    Mohamed

  2. Neli
    Admin
    Neli avatar
    212 posts

    Posted 26 Nov 2019 Link to this post

    Hello Mohamed,

    You may use the approach from the attached reports:

    Main report:

    1. Add a MultiValue report parameter (itemParameter) from type String.

    2. Its AvailableValues will come from a CSV DataSource which contains one column - Item;

    Child report:

    1. Add a table whose records will come from a CSV DataSource which contains two columns - Item and Value;

    2. Add a report parameter itemChildParam (MultiValue is set to True) which doesn't have any AvailableValues.

    3. Set the following Filter to the table:

    - Expression: =Fields.Item

    - Operator: IN (because of the multivalue parameter)

    - Value: = Parameters.itemChildParam.Value

    Go back to the Main report:

    - Add a textbox and set the following Action:

    Navigate to Report -> Select report source -> enter the child report location -> Edit Parameters:

    Parameter Name: itemChildParam

    Parameter Value: = Parameters.itemParameter.Value


    Regards,
    Neli
    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