Suggestions on Report

rbuser

Hi,
I have a report that basically produces a students attendance.

The data is stored as follows

Student NO - Date of attendance - Attendance Type
1 1/2/2004 X
1 2/2/2004 O
1 3/2/2004 X
1 4/2/2004 O
2 1/2/2004 X
2 2/2/2004 X
2 3/2/2004 X
2 4/2/2004 X etc

As all students have the same attendances I order by student no and then
date. I then create a set number of columns (e.g 4 above) - 1 for each
date attended. This then gives me a report that looks like a register

1 X 0 X 0
2 X X X X

The only problem is when the number of columns is larger than the A4
width.

Is there anyway to allow columns to flow to another page to the right?

Thanks for any help.

nicocizik

Hi,

You can try using the CrossTab component to accomlish this. Please see the
CrossTab demos located in the \RBuilder\Demos\2. CrossTabs\... directory for
some examples.

You can also create a spreadsheet style report by toggling the pages from a
subreport so you get the illusion that you are printing the pages side by
side. An example of this type of report can be downloaded at the following
link.

http://www.digital-metaphors.com/tips/spreadsheetstyle.zip

--