davidbhybrid Posted August 15, 2012 Share Posted August 15, 2012 I have a Main report as well as a Subreport that are working correctly with one exception. The Main report keeps all of my data together based on a Job Number, however, the subreport displays ALL the data for every Job Number each time. I would like the subreport to ONLY display the data with the Job Number in the Main report.I have attaced my Main JRXML (Job Account Detail) as well as the Subreport JRXML (Job Production Notes).Any help would be GREATLY appreciated.Thanks in advance.Post Edited by djbolduc at 09/07/2012 01:20 Link to comment Share on other sites More sharing options...
cmatthews Posted August 15, 2012 Share Posted August 15, 2012 Hard to tell exectly because I don't have your data sources but when I look into the subreport query I see a couple things that are likely to be the problem.Like this,and CASE WHEN $P{job_number} = 0 THEN j.id > 0 ELSE j.id = $P{job_number} ENDAll the parameters you want used in the query need to be $P!{job_number} ... having the ! (bang) ... I notice you have some with the bang and some without. The ones without are not being replaced with an actual value.Hope this helps,Clark Link to comment Share on other sites More sharing options...
davidbhybrid Posted August 15, 2012 Author Share Posted August 15, 2012 Thanks for your response, unfortunately, that was not the Probelm. Each Job has Notes that should display in the SubReport. The problem here is that the SubReport is displaying the Notes for all Jobs regardless of the Job Number.If I have 2 jobs in the report, the Notes for both Jobs display for each of the jobs instead of Job A notes displaying for Job A and Job B notes displaying for Job B.Any other ideas? Link to comment Share on other sites More sharing options...
davidbhybrid Posted August 15, 2012 Author Share Posted August 15, 2012 I was able to solve this. Thanks for everyones help. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now