I have two reports that I would like to pass two column values as parameters from report 1 to report 2. The reports read from different subject areas (Oracle and Essbase). I would like to pass values via the Custom Text Format, however I have only been able to get one parameter to pass, is there a way to pass two parameters:
Report 1 Name: Dept Master
Table Name.Column Name:
Project Resource.Department ID
Account Rollup.Expense
Report 2 Name: Dept Detail
Table Name.Column Name:
Project Resource. Department ID
Account Rollup.Expense
Below works to pass one column (Department ID) value as a parameter In the Data Format, Custom Text Format dialog box. I would like to add the Expense Column:
@[html]"[a href=""http://localhost:9704/analytics/saw.dll?GO&path=/shared/Engine/Engine%20Engineering/Program%20Costing/Dashboard%20Reports/07%20-%20DPT%20MTH/Dept%20Detail&Action=Navigate&Options=fdr&Col1=%22Project%20Resource%22.%22Department%20ID%22&val1="@"&op1=eq&nquser=Administrator""> "@"</a>"
Replace [a href with <a href
Thanks