Passing parameters to another report by hyperlinking (URI)

msnoeckx

<div><span>Hi,<br><br>
I'm developing Spago reports (.rptdesign) in BIRT and have a problem with passing parameters when hyperlinking to another report.<br>
Could anyone tell me what I am doing wrong here ?<br><br>
I have a master report and a slave report.<br>
On the master there is a hyperlink (URI) with following code:<br><br>
"javascript:parent.execCrossNavigation(this.name, 'Job_followup','AD_JobFU_jobname="+row["job_name"]+"&AD_JobFU_version="+row["version"]+"','','','self');"<br><br>
In the subreport I have a query with 2 values in the where condition that equal "?":<br><br>
select<br>
test.job_name,<br>
test.version::character varying(10)<br>
from test<br>
where test.job_name = ?<br>
and test.version = ?<br><br><br>
For this query 2 report parameters AD_JobFU_jobname & AD_JobFU_version are created, which are both strings and both have a default value.<br>
In the dataset I've linked the parameters to this report parameters.<br><br>
What is going wrong:<br><br>
When I open the master report in SpagoBI I can click the link and it goes to the slave report, but it always takes the default value.<br>
So in some way the parameters aren't passed to the slave report's dataset.<br><br>
Does anyone have an idea ??<br><br>
Thanks,<br><br>
Mike</span></div>
<p></p>

rgleason

<p>Are you able to use a "Drill Through" hyperlink type? Doing this will present to you a relative pathed report as well as any parameters contained within the target report. From here the hyperlink will be defined with mapped parameter values from the calling or master report. </p>
<p> </p>
<p>Otherwise a call will need to be made to the target report using a link using JSAPI and relevant parameter variables defined. </p>
<p> </p>
<p>Which method are you using? </p>