creating a dynamic agenda in a report

[danaraincloud]

I have a database of event attendees. They are registered for 1-6 events over the course of a day. I would like to create a report that will generate their personalized schedule so it looks something like this:



Time 1 - Session 1
Time 2 - Session 2
Time 3 - Session 3A
Time 4 - Session 4B
Time 5 - Session 5
Time 6 - Session 6

Easy enough.

My problem lies in generating the report for those people who are not attending all sessions. I want to collapse the white space left behind by empty fields and I am drawing a complete blank. If the person is only attending Sessions 2 and 5, I want those to appear in the 1 & 2 position with the white space below.

I feel like there's one way I could do it by layering fields and an awful lot of conditional formatting... if there's an easier way to do it, I'd very much appreciate someone letting me know.

THANKS!

[ranman256]

I would build a 'report' macro that posts the sessions to a reporting table. say tRptSched
It would
clear the table
append all persons and their sessions.
then open the report.

the report would show that persons sessions, since Bob only has session 5, it would only show that.

(if you have the skills , you dont need the report table, you can just use queries, w/o extra tables.)

[June7]

You have a field for each session? This is part of the issue - non-normalized data structure.

Try setting the textboxes Height property to 0 then positioning them against each other. Set the CanGrow and CanShrink properties to Yes. On second thought, doubt that will help because even though you have the textboxes arranged vertically, they are all still one record. The longest value in any textbox controls the height of the record/row.