Categories
Parameter value pass
Summary
Pass a value to sql script read parameter value
Content
Team, I am new to DV. I need to pass a value from Report1 to Report2 and have Report2 use the passed value in a SQL Script Example: "Select * from Dataset/table where (vale1 - Val2) = parameterValue" Example help please?
Version
18
Answers
-
Hi Brian,
In DV, if you want to navigate from one canvas to another and pass contextual parameters, you can use the 'Data Navigations' option.
When the source and target reports use the same columns, the value is passed as a parameter from the source and applied as a filter in the target.
This video gives you an overview
https://www.youtube.com/watch?v=IkcqYMB8N8k Hope this helps.
Regards,
Lalitha
0 -
Thank You Very Much!
0 -
Passing the value is not the issue. The value is passed. How to I make use of the value in Rpt2 if the dataset in Rpt 2 is not joined to the dataset in Rept1?
0
