Friday, April 06, 2012 3:30 PMI have a report that has expandable tabs that show detail for each summary line. When I save the report as MHTML, the tab functionality is removed and only the summary lines are displayed. I need to save the report as an HTML file that I can either email or put in a content area for access via HTML link.
- Edited by tjschilling Monday, April 09, 2012 4:13 PM Fixed typo's
Tuesday, April 10, 2012 7:38 AMModerator
Reporting Services provides multiple interactive reporting features. Currently, not all of the report rendering formats support the full range of interactive features. When we export a report to MHTML format, the toggle items within a report are not rendered.
To work around the issue, I suggest that you expand all the toggle items before exporting the report to MHTML, and then all the visible data will be rendered.
If you have any questions, please feel free to let me know.
Tuesday, April 10, 2012 2:32 PM
Thank you for the response. Unfortunately, expanding the tabs would defeat the purpose of the report due to the number of detail rows for each subtotal. I personally could live with it but the executive level users would find this unacceptable.
I will look for an alternative reporting tool that can accommodate this functionality more readily.
Thanks again for the response, you confirmed my suspicions.
Friday, April 13, 2012 1:23 PMModerator
Thanks for your post.
If there are no images embedded in the report, there is a workaround for your reference. You can enable HTML 4.0 and then select the HTML 4.0 as the render format when configuring the subscription. Please note the HTML 4.0 formats will not include images in reports.
To enable the HTML 4.0 rendering format, you can refer to the steps below to modify the RSreportserver.config file. Please make copies before you modify any .config files.
- Open the <Drive>:\Program Files\Microsoft SQL Server\MSSQL.XXX\Reporting Services\ReportServer folder.
- Save a copy of the file in case you need to roll back your changes.
- Search for “HTML4.0” which locates within the <Render> attribute, and then set the “Visible” value to “true”.
Then the HTML4.0 will be available in the drop-down list of the “Render Format:” option in the “Subscription” configuration page.
Hopefully this helps.
Friday, April 13, 2012 4:41 PM
We are going to give this a try. If it works, you rule! If not, I really appreaciate that you at least looked at a possible solution for me. I will let you know.
Take care and thanks again!