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

Answer this question

How to dynamically change width?

dchau28
"CanGrow" doesn't seem to have any visible effect in this instance, even with all other textboxes in the row set to "CanGrow".
Mark Kortink
Has this issue never been resolved, as from the comments in this forum, there is no solution offered
tobbjo
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.
Dag Calafell III
I am having the same problem. Looks like MS should address this one.
Lluis Serra
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
GCParris

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.
MikaelJ
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.
Dox
i have the same problem,somebody helps,and i also have a question how to dynamically set item'position.re
talbers

hi vaidyak,

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

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
akaa
I have experienced same problem also. Hope Microsoft addresses this.
Jay1973
Hi,

CanGrow and CanShrink only affect the ability of a control to expand or shrink VERTICALLY. View the link provided for details.

http://technet.microsoft.com/en-us/library/ms154030.aspx

Hope this helps,

Bill
How to dynamically change width?

Answer this question