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

0

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&...

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&... HTTP/1.1"

jr_report_uri=null, 

please help me to resolve the issue.

tabalajir's picture
Joined: Feb 21 2017 - 3:19am
Last seen: 1 year 8 months ago

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.

 

m.yasir21 - 1 year 11 months ago

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.

 

 

tabalajir - 1 year 11 months ago

0 Answers:

No answers yet
Feedback