Dynamic Reports

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Hannah B. - 01 Mar 2006 16:11 GMT

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?

Reply to this Message

Klatuu - 01 Mar 2006 17:00 GMT

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])

> 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
[quoted text clipped - 4 lines]
> 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?

Reply to this Message

Duane Hookom - 02 Mar 2006 03:31 GMT

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.

Signature

Duane Hookom
MS Access MVP
--

>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
[quoted text clipped - 8 lines]
> create a report which will show the tables field only when a table is
> needed?

Reply to this Message