Jump to content
We've recently updated our Privacy Statement, available here ×

Output of iReport PDF only showing every 21 pg


tso2085

Recommended Posts

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 FamilyNumber

SubReport Query:  SELECT IndividualLabelName, GoesByName, Gender, DateOfBirth, Age FROM people WHERE FamilyNumber = $P{FAMILYNUMBER}

Thanks for your assistance!

Link to comment
Share on other sites

  • Replies 1
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

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 account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...