It renders blank pages to PDF, which are essentially the report body with
the columns that reside there, but the columns are "hidden". The fact that
the report body is wider than the page (even though the number of visible
columns will fit on the page) cause blank pages to be rendered. It would be
nice if the body width "rolled-up" in response to hidden content residing
there. Can't seem to come up with another approach that works.
By the way, sorry about the "from Microsoft" thing. Apparently I share an
office with comedians.
Ron
[quoted text, click to view] "Tim Dot NoSpam" <Tim@MindYourSpammy.spam> wrote in message
news:ua34cnIpGHA.2400@TK2MSFTNGP03.phx.gbl...
> Hi Microsoft Ron.
>
> When you say it prints blank rows, does this mean that a user can hide ALL
> the columns? What if they hide all but one column? Wouldn't that one
> column still be valid as a row?
>
> "Microsoft" <ron.lytal@oneilsoft.com> wrote in message
> news:eiHDYUHpGHA.2444@TK2MSFTNGP03.phx.gbl...
>>I have been trying in vain for some time to create a columnar report where
>>certain column(s) can be hidden as requested by the user via report
>>parameter(s). I have tried placing all the columns in the report and then
>>hiding some as needed, but this prints blank pages when rendered to PDF
>>since the report body does not shrink as column(s) are hidden. I have
>>tried a table, list, and matrix to no avail...
>> Does anyone know of a workaround, a trick, or perhaps a different
>> approach that I have not thought of?
>> Thanks.
>>
>
>