By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,477 Members | 1,627 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,477 IT Pros & Developers. It's quick & easy.

Too many headers in a report

P: 2
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
Feb 12 '08 #1
Share this Question
Share on Google+
4 Replies


Minion
Expert 100+
P: 108
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 -
Feb 12 '08 #2

mshmyob
Expert 100+
P: 903
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
Feb 12 '08 #3

P: 2
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!
Feb 19 '08 #4

mshmyob
Expert 100+
P: 903
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 rptParticipatedHorizontal.

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!
Attached Files
File Type: zip pass2report.zip (45.6 KB, 62 views)
Feb 20 '08 #5

Post your reply

Sign in to post your reply or Sign up for a free account.