Tough Report Questions!!

[raymond3090]

ok everybody, a couple of tough ones (at least I think they're tough!!)

Hi, I have a form where a user can select from combo boxes and multi-select list boxes the data types and parameters they want to appear on a report.

When my code finishes, the report is shown in print preview. I know I will always want the report to be landscape oriented, but I have to go in and manually change that everytime now. How can I automate this?

In addition, I often have many columns of data going across the page, and even if in lanscape, I can't fit them all on one page when printed. As a result, some controls get cut between two pages. Is there any way to avoid this? For example, can I somehow say if the whole control can't fit on this page, then place it at the start of the next?

Regards,

-Ray

 

[Matt Brown]

I think i can answer your first question:

In the reports design view go to page setup and select either landscape or portrait.
Ok that and click save.

This will set the page orientation to whatever you selected as a default to the report.

Works for me.

Your second question i would imagine there is some code that would do what you are after but i dont have it right now.

 

[raymond3090]

thanks matt! That works just fine!!

Still stumped on the second one though. Any takers?

-ray