Passing parameter from one report to another based on select data from the first report

[tabalajir]

Hi Team, 

I have created two seperate reports [main and sub], main will have a chart that has reagion wise sales data, and sub will have detailed sales person and sales details information,

i have created the REGIONCODE parameter in the sub report and in main report i have created hyperlink as "ReportExecution", with 2 parameters, 

1. _report="http://localhost:2071/MyReports/servlets/viewer?jr_report_uri=Sub.jrxml&jss_context=301dfa68-4f27-4c0e-af64-a6e75338e710&jr_async=true

2. REGIONCODE=$F(REGIONCODE)

after run in interactive mode, on click on the main report, i could not see the sub report, i got the followin header in fiddler [request]

"GET /MyReports/servlets/viewer?jr_report_uri=null&_report=http://localhost:2071/MyReports/servlets/viewer?jr_report_uri=Sub.jrxml&jss_context=301dfa68-4f27-4c0e-af64-a6e75338e710&jr_async=true&REGIONCODE=05 HTTP/1.1"

jr_report_uri=null, 

please help me to resolve the issue.

[m.yasir21]

try following steps. May be this could help you.

1) I am not sure about making equal parameter in main and sub report spelling Parameters from both report should be same.

2) try to execute  both query in query builder with same parameter. this will make you sure that there is no problem in your query.

3) if database is null then Jasper render false everything, its a builtin function.

 

[tabalajir]

Hi myasir21,

There is no issue while running both the queries in query builder.  for any parameter [from the parent query] there are some data in the child query [secondary query], so the database will not return null for the any given parameter.

 

 

[wilson3838]

I'm trying something very similar, if not exactly what you're trying tabalajir. I've tried everything under the sun. A very elementary function apparently cannot be done in Jasper Reports.