tso2085 Posted July 31, 2008 Share Posted July 31, 2008 I have a report against an MySQL table with a subreport against the same table. I am printing out a pre-filled registration form. I have both the Main report fields and the subreport in the Page Header band. (I had the subreport in the Detail band, but it printed many more records than it should have.)When I run the same query in MySQL, I get a total of 600 records selected. When running it through iReports with the output to PDF, I get 27 pages (one record per page, so 27 records.) Counting the records between each one printed, it comes up to 21 - 23 records skipped each and every time. Any ideas why it would not print all 600? I have included my queryies below.Main Report Query: SELECT * from people WHERE IndividualNumber = 1 ORDER BY FamilyNumberSubReport Query: SELECT IndividualLabelName, GoesByName, Gender, DateOfBirth, Age FROM people WHERE FamilyNumber = $P{FAMILYNUMBER}Thanks for your assistance! Link to comment Share on other sites More sharing options...
man_mbt Posted August 6, 2008 Share Posted August 6, 2008 I think, you are getting all records. Your band-height is not enough to show your datas. Try to increase the height of band(like detail), in which you have pasted subreport and field name. 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