Saving reports as HTML pages that retain all functionality

Question

I 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.

Answer 1

Hi Tjschilling,

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.

Reference:
Comparing Interactive Functionality for Different Report Rendering Extensions

If you have any questions, please feel free to let me know.

Regards,
Mike Yin

Answer 2

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.

---

Schilling TJ

Answer 3

Hi Schilling,

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.

1. Open the <Drive>:\Program Files\Microsoft SQL Server\MSSQL.XXX\Reporting Services\ReportServer folder. 
2. Save a copy of the file in case you need to roll back your changes.
3. 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.

Regards,
Mike Yin

Answer 4

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!

---

Schilling TJ