Hidden columns exporting in CSV

I am writing a report to export columns dynamically. The column's Hidden
property is controlled by an expression (=Cbool(parameters.hidecol.value))
which works ok in Excel and PDF export. However, whenever I export in CSV,
this property is ignored and the column is never exported.
Is this a bug in reporting service or is it by design?
I have SQL reporting service 2005 with SP1 and all the hotfixes.Imran,
I got a reply from a MS contact on msdn. Here is his reply for anyone
else with the same problem...
John,
You can't conditionally hide and show data in data renderers (CSV,
XML). This is by design. If you have an expression in the Hidden field
and 'Auto' in DataOutput tab for text boxes in the column, your data
will not be rendered into CSV or XML.
You can set DataElementOutput to Output for textboxes in the cells and
in the header, and the coulmn will always be in the output file.
Thanks!
----
- DenisL (SQL RS Team)
Imran wrote:
> I am writing a report to export columns dynamically. The column's Hidden
> property is controlled by an expression (=Cbool(parameters.hidecol.value))
> which works ok in Excel and PDF export. However, whenever I export in CSV,
> this property is ignored and the column is never exported.
> Is this a bug in reporting service or is it by design?
> I have SQL reporting service 2005 with SP1 and all the hotfixes.|||Actually I was expecting a solution rather than a refresher on "status quo"
from Microsoft. Ofcourse I am aware of this issue and there are several
codable workaround for this... Was curious if someone had already done this
or if another hotfix is on its way to resolve this.
Imran
"johnburns007@.gmail.com" wrote:
> Imran,
> I got a reply from a MS contact on msdn. Here is his reply for anyone
> else with the same problem...
> John,
> You can't conditionally hide and show data in data renderers (CSV,
> XML). This is by design. If you have an expression in the Hidden field
> and 'Auto' in DataOutput tab for text boxes in the column, your data
> will not be rendered into CSV or XML.
> You can set DataElementOutput to Output for textboxes in the cells and
> in the header, and the coulmn will always be in the output file.
> Thanks!
>
> ----
> - DenisL (SQL RS Team)
>
> Imran wrote:
> > I am writing a report to export columns dynamically. The column's Hidden
> > property is controlled by an expression (=Cbool(parameters.hidecol.value))
> > which works ok in Excel and PDF export. However, whenever I export in CSV,
> > this property is ignored and the column is never exported.
> >
> > Is this a bug in reporting service or is it by design?
> >
> > I have SQL reporting service 2005 with SP1 and all the hotfixes.
>