Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi All
I have a report with multiple sections and using Report Parameters I am conditionally show or hide tables.
When I export output in Excel or PDF, I get only intended table in outputs. However, when I use Export to csv format, it renders all tables (visible/ hidden) on same page. i.e. it's not applying hidden property's conditional logic.
I am not sure why it's not working with csv format?
Please let me know if have any inputs.
Thanks!
Solved! Go to Solution.
Hi, @abpgupta
Sometimes your reports look different or do not work the way you want after you export them to a different format. This occurs because certain rules and limitations might apply to the renderer.
Reporting Services provides many rendering extensions, supporting exports of reports to common file formats. The rendering extensions support file formats with soft breaks (for example, Word or Excel), hard-page breaks (for example, PDF or TIFF), or data only (for example, CSV or Atom compliant XML).
There are three types of Reporting Services rendering extensions:
Data renderer extensions Data rendering extensions strip all formatting and layout information from the report and display only the data. The resulting file can be used to import the raw report data into another file type, such as Excel, another database, an XML data message, or a custom application. Data renderers do not support page breaks.
The following data rendering extensions are supported: CSV, XML, and Atom.
Soft page-break renderer extensions Soft page-break rendering extensions maintain the report layout and formatting. The resulting file is optimized for screen-based viewing and delivery, such as on a Web page or in the ReportViewer controls.
The following soft page-break rendering extensions are supported: Microsoft Excel, Microsoft Word, and Web archive (MHTML).
Hard page-break rendering extensions Hard page-break renderer extensions maintain the report layout and formatting. The resulting file is optimized for a consistent printing experience, or to view the report online in a book format.
The following hard page-break rendering extensions are supported: TIFF and PDF.
The Comma-Separated Value (CSV) rendering extension renders paginated reports as a flattened representation of data from a report in a standardized, plain-text format that is easily readable and exchangeable with many applications.
Therefore, due to the different rules and restrictions of CSV, EXECL and PDF, it fails to apply your report parameters and directly output your expected results.
Please refer to the following documents for details.
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @abpgupta
Sometimes your reports look different or do not work the way you want after you export them to a different format. This occurs because certain rules and limitations might apply to the renderer.
Reporting Services provides many rendering extensions, supporting exports of reports to common file formats. The rendering extensions support file formats with soft breaks (for example, Word or Excel), hard-page breaks (for example, PDF or TIFF), or data only (for example, CSV or Atom compliant XML).
There are three types of Reporting Services rendering extensions:
Data renderer extensions Data rendering extensions strip all formatting and layout information from the report and display only the data. The resulting file can be used to import the raw report data into another file type, such as Excel, another database, an XML data message, or a custom application. Data renderers do not support page breaks.
The following data rendering extensions are supported: CSV, XML, and Atom.
Soft page-break renderer extensions Soft page-break rendering extensions maintain the report layout and formatting. The resulting file is optimized for screen-based viewing and delivery, such as on a Web page or in the ReportViewer controls.
The following soft page-break rendering extensions are supported: Microsoft Excel, Microsoft Word, and Web archive (MHTML).
Hard page-break rendering extensions Hard page-break renderer extensions maintain the report layout and formatting. The resulting file is optimized for a consistent printing experience, or to view the report online in a book format.
The following hard page-break rendering extensions are supported: TIFF and PDF.
The Comma-Separated Value (CSV) rendering extension renders paginated reports as a flattened representation of data from a report in a standardized, plain-text format that is easily readable and exchangeable with many applications.
Therefore, due to the different rules and restrictions of CSV, EXECL and PDF, it fails to apply your report parameters and directly output your expected results.
Please refer to the following documents for details.
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.