How to set a row count manually?

[manshack_one]

I'm building a report that's a sign in sheet.  I need to force the number of rows in the report to be equal to the capacity of the class (I have the class capacity as a field so I can reference it).  How do I force the detail band to print blank rows equal to this number?  For example:  A class  has a capacity of 20 students but only 10 have signed up.  When the sign in sheet is generated it should include 10 rows with student data and 10 rows without to leave room for handwritten entries on the printed copy.

I considered the print when expression but I'm not sure how to say "print rows until 'i' is equal to capacity like you would in a loop.

[kkriplani]

Hi,
Using a "Page break" would help. In the default expression, use a field like;

$V{REPORT_COUNT} == 10

Regards,
KKriplani

[hozawa]

JasperReports does not have a feature to do that. I had a similar request and had to add an attribute to JasperReports library to do it.

http://community.jaspersoft.com/questions/977306/how-can-i-fill-table-and-list-end-page-will-empty-rows

[manshack_one]

KKriplani,

If you set a page break like that, what happens if report count is less than 10?  Would it repeat the detail band (which is what I'm trying to force the report to do)?  

[manshack_one]

hozawa

[manshack_one]

Maybe I could force my query results to contain empty rows........

Consider that I'm trying to build a sign in sheet for a class.  If a class has a capacity of 20 seats (the max I expect) then I need 20 rows for people to sign in on.  However, if people have already signed up then I want to pre-populate their names.  So how would I force empty rows in the query?

tblClassSchedule.classCap is the number of rows I need to generate.

select *, (select  tblUsers1.userName  from tblUsers1 where tblClassSchedule.classInstructor = tblUsers1.ID )  as instructorName

from tblClassSchedule, tblClassRoster, tblClassInfo, tblUsers1, tblBranch

where tblClassRoster.classID = tblClassSchedule.ID

and tblClassInfo.ID = tblClassSchedule.classInfo

and tblClassRoster.attendeeID = tblUsers1.ID

and tblBranch.ID = tblUsers1.userBranch

and tblClassSchedule.ID = $P{classScheduleId}