Auto Resize a report width?

Hi,

I have a very big report with 60 columns and some columns are invisible.

The problem is now if I have 30 columns that are invisible (hidden=TRUE), the report width still stays at 60 columns width, and the Horizontal scroll bar become very long and it just scroll to blanks.

I would like to know how to resize the report after it is generated?

Thanks.

Jon

Anyone here can help pls?|||Is it possible you can do it as a matrix, this will at least allow dynamic size based on columns.

?|||

Hello Jon,

the first thing you will have to do is to set the width of the columns to 0 - invisble does not shrink the column automatically but will bring up a blank space with the standard width of the column instead.

the second thing should be to rethink about your report design - I personnaly would consider that 30 columns is way to much information for the user...

third thing:

Why do you want to 30 columns marked as visible?

just delete them instead...

Or is the visibility triggered via a report parameter?

Than you should think about using a matrix instead of a table and also should the database do the work and the decision which element should be placed in the database. reducing the data set will lead to a improved performance.

cheers

Markus

|||

If this report is to be run interactively through the reportviewer what you could do is run the report as a local report. You then could load the report layout into memory and modify the report width dynamically (xpathnavigator class would be one way) and then supply the modified RDL as a memory stream to the report viewer.

|||

thanks for all the reply.

i will try all the solution you have suggested.