Automatic width

Hello :

It is possible to define the width of the cells of table dynamically (not Statics)?

Thank's.

No (as of SSRS 2005).

auto resizing column

hi all

i am working on sql reorting 2005

how can i set the column width to autoresize depending on the maximum length of data for that column?

plz help me.

As far as I know, there is no way to autoresize column width. The only property to account for adjusting a cell's dimensions is "CanGrow." If this is set to True, the cell will increase vertically to fit all the data. However, this only adjusts the height and not the width.

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.

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.

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.