Parameter value pass

Brian666H

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

Lalitha Venkataraman-Oracle

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

Brian666H

Thank You Very Much!

Brian666H

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?