Dynamic columns

I am setting visible property for column based on user input. This works
fine. However, I need to be able to change the width to 0 for the column as
well so the report will not print blank pages. A matrix is NOT an option.
Report is too complicated. Unfortunately there is no expression option for
the column width. Is there any way of setting this to 0 or autosize' Also
need to adjust the body width dynamically.On May 29, 3:32 pm, Sherminator
<Shermina...@.discussions.microsoft.com> wrote:
> I am setting visible property for column based on user input. This works
> fine. However, I need to be able to change the width to 0 for the column as
> well so the report will not print blank pages. A matrix is NOT an option.
> Report is too complicated. Unfortunately there is no expression option for
> the column width. Is there any way of setting this to 0 or autosize' Also
> need to adjust the body width dynamically.
Unfortunately, there are not very many options available if a matrix
control is not an option. You could try putting the table control(s)
in a rectangle. Also, you could try to rearrange the columns according
to the ones most likely to be invisible. Sorry that I could not be of
greater assistance.
Regards,
Enrique Martinez
Sr. Software Consultant|||It's not a matter of the columns not showing, so the order doesn't matter.
They do hide, however blank pages print because the body is over 18 inches
when all columns are populated. Unfortunately, the tablecolumn element is not
available thru the ReportItems collections. If it were I could reset the
width of the empty columns to 0 using a function and adjust the body width if
it too were available thru the ReportItems collection, however, those
elements are not available to my knowledge.
"EMartinez" wrote:
> On May 29, 3:32 pm, Sherminator
> <Shermina...@.discussions.microsoft.com> wrote:
> > I am setting visible property for column based on user input. This works
> > fine. However, I need to be able to change the width to 0 for the column as
> > well so the report will not print blank pages. A matrix is NOT an option.
> > Report is too complicated. Unfortunately there is no expression option for
> > the column width. Is there any way of setting this to 0 or autosize' Also
> > need to adjust the body width dynamically.
>
> Unfortunately, there are not very many options available if a matrix
> control is not an option. You could try putting the table control(s)
> in a rectangle. Also, you could try to rearrange the columns according
> to the ones most likely to be invisible. Sorry that I could not be of
> greater assistance.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>