This is a migrated thread and some comments may be shown as answers.

How to use parameter coming from report to a report

1 Answer 260 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Mohamed
Top achievements
Rank 1
Mohamed asked on 21 Nov 2019, 10:48 AM

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

1 Answer, 1 is accepted

Sort by
0
Neli
Telerik team
answered on 26 Nov 2019, 10:42 AM

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
Tags
General Discussions
Asked by
Mohamed
Top achievements
Rank 1
Answers by
Neli
Telerik team
Share this question
or