Dynamic Reports

H

Hannah B.

I need help developing a dynamic report in which the fields in the report
change. Not the field values, but the actual fields themselves. If the value
of the field is null, then I do not want the field to appear on the report.
Here is my situation. I am developing an event planning system. Each event
gets a unique id. However each event may occur at several different locations
or times. A conference (event) may have multiple sessions. Here is my
problem. Some sessions require tables, for example, others don't. How do I
create a report which will show the tables field only when a table is needed?
 
K

Klatuu

In the Format event of the section the text box is in, you can set it's
visible property:

Me.txtTables.Visible = Not IsNull([MyBoundFieldName])
 
D

Duane Hookom

You normalize your "Access tables". I assume you have fields in your table
that identify various event needs. I would place these in a related table.
This would be similar to the Orders (events) and OrderDetails (event needs).
If an order doesn't include tables in the order details, it won't show in
the order or invoice report.

I could be wrong. Prove it.
 
Top