Loop?
? Hi,
I am new at report builder, rap and delphi!
I am writing a report which has a subreport.
I am trying to pull data for a registration report, which will give me
presents or absences for each person that attended a training session.
The report should show a list of names on the left and their weekly
corresponding registratin marks.
The end user should be able to select which date wants the date from and
that date should be carry over on the report. eg, the user selects
10/09/2012, the reports should show registration marks for each attendee
for Monday, Tuesday, Wednesday and Friday.
I've got to the point to catch the data from the user and show the dates
and name of day, also show the registration marks.
The problem is that it is showing all registration marks for each attendee
instead of only the one matching the date entered by the user. I know
there should be a loop to go through all the dates and show only the one
needed but for some reason it is not working. I believe I am not doing
well the While do clause or probably I need an end of file? sorry for the
long message, any help will be much appreciated.
This is an example:
Name Monday Tuesday Wednesday Thursday Friday
10/09/12 11/09/12 12/09/12 13/09/12 14/09/12
Name1 Present Present Present Absent Present
Name2 Absent Present Present Absent Present
etc
Laura
--- posted by geoForum on http://www.newswhat.com
I am new at report builder, rap and delphi!
I am writing a report which has a subreport.
I am trying to pull data for a registration report, which will give me
presents or absences for each person that attended a training session.
The report should show a list of names on the left and their weekly
corresponding registratin marks.
The end user should be able to select which date wants the date from and
that date should be carry over on the report. eg, the user selects
10/09/2012, the reports should show registration marks for each attendee
for Monday, Tuesday, Wednesday and Friday.
I've got to the point to catch the data from the user and show the dates
and name of day, also show the registration marks.
The problem is that it is showing all registration marks for each attendee
instead of only the one matching the date entered by the user. I know
there should be a loop to go through all the dates and show only the one
needed but for some reason it is not working. I believe I am not doing
well the While do clause or probably I need an end of file? sorry for the
long message, any help will be much appreciated.
This is an example:
Name Monday Tuesday Wednesday Thursday Friday
10/09/12 11/09/12 12/09/12 13/09/12 14/09/12
Name1 Present Present Present Absent Present
Name2 Absent Present Present Absent Present
etc
Laura
--- posted by geoForum on http://www.newswhat.com
This discussion has been closed.