Too many headers in a report

[LorenS]

I am trying to generate a report that will provide information on whether a unit participated in an event or not utilizing the Yes/No check box. The problem is that I have over 40 units to identify in this report, and can not fit the unit identifier (headers) across the top of a single page.
Since I will never have more than 20 units participating in a single event, and that amount of headers would fit on a single page. Is their a way to filter the headers so that only the headers for units that have a "Yes" associated with them as participating in the event would show up? Thank you in advance.

Loren

[Minion]

I am trying to generate a report that will provide information on whether a unit participated in an event or not utilizing the Yes/No check box. The problem is that I have over 40 units to identify in this report, and can not fit the unit identifier (headers) across the top of a single page.
Since I will never have more than 20 units participating in a single event, and that amount of headers would fit on a single page. Is their a way to filter the headers so that only the headers for units that have a "Yes" associated with them as participating in the event would show up? Thank you in advance.

Loren

Loren it is in fact possible to filter the records to include only those that have participated. To get you started check out this article Creating Dynamic Reports with VBA as I think it will get you moving in the right direction.

Hope this helps.

- Minion -

[mshmyob]

Yes. I can think of two ways off the top of my head.

First is from the form that calls the report you could do the filtering and pass the results to the report variables.

or in the report directly you could go into the 'ON FORMAT' event in the DETAIL section and setup if statements or case statements there.

I am trying to generate a report that will provide information on whether a unit participated in an event or not utilizing the Yes/No check box. The problem is that I have over 40 units to identify in this report, and can not fit the unit identifier (headers) across the top of a single page.
Since I will never have more than 20 units participating in a single event, and that amount of headers would fit on a single page. Is their a way to filter the headers so that only the headers for units that have a "Yes" associated with them as participating in the event would show up? Thank you in advance.

Loren

[LorenS]

Thanks for the responses. I am quickly becoming more and more educated with access, but have only slightly dived in to VBA code so I dont have the knowledge to know what code to write yet for my issue.
Any further guidance would be greatly appreciated.

Thank you!

[mshmyob]

Here is an example of a vertical report and a Dynamic Horizontal report. Check out the code under the Horizontal Report button ON Click event and the Code in the Open Form event of the report rptParticipated Horizontal.

Vertical Report uses the Select Query and the Dynamic Horizontal report uses a Cross Tab query.

Thanks for the responses. I am quickly becoming more and more educated with access, but have only slightly dived in to VBA code so I dont have the knowledge to know what code to write yet for my issue.
Any further guidance would be greatly appreciated.

Thank you!