How To Control Report Width

C

Chlaris

Dear all,

I have a dynamic columns report which can be printed using A3 or A4 paper
size.
The columns are defined by user, from 1 column to 15 columns.
Is there any way to control the report width programmatically ?
Thanks.

Chlaris
 
D

Danny J. Lesandrini

I see no one has answered yet. I hesitated because I don't actually know the
answer, but I suspect it's not possible.

At best, you'd have to open the report programmatically in design view, change
things, save it and then run it. It may be possible, but I don't think practical.

I guess if it were me, I'd have 2 report templates, one wide and one narrow. Then,
depending on the number of columns requested by the user, you'd know to use the
wide or narrow one. Could be you're trying to do too much with one template.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to make the report previewed in the right paper size ? 2
How to programmatically generate Excel report 4
Table Preferred width is changed when pasting 1
Cross Tab Report Vs Dynamic coulmns 0
How to change index programmatically 1
A03- Set report to print in 2 columns, but solution just repeats the left column's data in the right 1
VBA - (re-) Set a Table Style 2
How to remove a bracket that is itallicised for an entire document 1

Top