Hints on creating this report?

rbuser

Hi,
I am looking for any tips/advice on creating the following report.
I am planning to create a report which is a register of students
attendance.

My data is returned in the format

Student_no | attendance Date |

1 | 15/06/2003
1 | 16/06/2003
1 | 17/06/2003
2 | 15/06/2003
2 | 16/06/2003
2 | 17/06/2003

I would like the report to output the data like this:-

Student_no | attendance Dates

1 X X X
2 X X X

With the dates above the crosses.

I can see how to easily group the students and have each students
attendance be listed underneath an another, but is there an easy way to
have this flow to the right?

At the moment, i am thinking of omitting the student name and making the
report with multi columns. The number of columns will be the maximum
number of attendances.

Not sure if i have described this well enough, but any tips would be
appreciated.

Alan

nicocizik

Hi Alan,

If you want to display the attendance dates horizontally, you will need to
create a new column for each date as you described below. Then be sure to
set the DetailBand.ColumnTraversal property to ctLeftToRight. Try creating
a group around the columns displaying the student name to separate the
students if you like.

--

rbuser

rbuser

nicocizik

Hi Alan,

Try using the Report.ColumnPositions property. This defines the left
position of each column in order. For instance if you wanted a new column
every two inches, your ColumnPositions would look like:

2
4
8
10.... and so on.

--