How to dynamically change width?

Folks,

We have some reports that have optional columns. We have them working very nicely, with the column showing or hiding based on values in the report -- works great.

Except -- when the columns are present, the report spans onto two pages, when exported to PDF, in width. That's understandable, as there's a lot of extra data, and exactly what we want. However, when the columns are not present, we get empty pages instead, because the report doesn't automatically contract back onto the size that fits on one page.

Changing the report to a Matrix won't work, as the hidden columns on some of these come as sets of three, where each column in the three has different formatting (different widths, format codes, etc).

Thanks!

--randy

We have the same problem, columns thats hidden or not based och which parameters user used when the report is rendered. Everything is fine exept for when printing it... then the report is as wide as in design mode even if the columns is not visible, ending up with lots of blank pages. Is there anyway I can set width during runtime? It would be nice to be able to set the width to the sum of all shown column widths.

This is|||I'm also experiencing the same problem. The width of the column does not automatically adjust depending on the content of the report. Anyone who know's how to fix this? thanks.|||i have the same problem,somebody helps,and i also have a question how to dynamically set item'position.re|||

I too spend half a day trying to come up with a solution and found that no matter what is hidden, if the size of the table, list, matrix was outside the page width boudaries in design/layout mode the printed report would cross over.

I eventually came up with having two or more replica tables in the report that showed the different width columns in each table. For example, table one had financial information and based on a toggle the visbility would switch to table two that had the contact information, or the same information bar on eor two columns were different. The effect to the user is that a toggle can switch the between columns or column size without the boudaries being exceeded.

Rgds

Darrenh

|||I am having the same problem. Looks like MS should address this one.|||

Hi,

i have not faced such prob so far. but wat i feel is to make the width of all the columns to "0" and set the "Can Grow" property of the columns to "True" so that the columns expands horizontally based on the content it holds.

plz let me know if works fine.

Thanks.

|||I have experienced same problem also. Hope Microsoft addresses this.|||

But the CanGrow property does'nt seenm to have any effect.

I have dynamically changed the column widths in code according to a particular scenario.

|||

hi vaidyak,

"can grow" property should be set to true for all the textboxes of the row.

|||"CanGrow" doesn't seem to have any visible effect in this instance, even with all other textboxes in the row set to "CanGrow".