Dynamically creating report width

Has anyone found out how to dynamically create report width.

If I have 20 columns on a report all of 2cm, then report will be 40cm width.

If I display the columns based on specific criteria using the iif function and then setting the an expression for the Visibility Hidden property, the report could potentially reduce in width.

I cannot see how to build an expression for the report width or table width, to accommodate the potential change in the width of the report when columns are not shown, thus it pages incorrectly, leaving huge white space on the right of the report when columns are hidden... has anyone come across this requirement, and hopefully a solution for it?

Many Thanks people

Here is a link for dynamic columns.

http://www.codeproject.com/sqlrs/DynamicReport.asp