SSRS Dashboard Render HTML/PDF

Question

Hi,

I'm in a bit of difficulty, a dept has taken the static excel report and replicated via Qlikview variance reporting
Now i have powerbi but i have a pro license and not premium and also not power automate and cant automate a new dashboard satically to users

Im trying to export to html that has drop downs ect, alsmost like powerbi slicer so that user can interact and export to pdf
can i in a cell have multiple content, like a graph transparent with an expression on top of it.
My static excel file had so many rows & collumns and it was deemed not great for exec to read, so im trying to do variances with graph in background of cell to give more detail > sorry thinking out loud, A SSRS Dashboard

Or is there other options free software or anything, i need to do something great and quiclky please ?

Please & Thanks

Answer 1

Hi @IC IC ,

Please follow the steps to enable HTML rendered for export.

1.On the SSRS server, find the RSResportServer.config file.

2.Find the tag "Extension Name="HTML4.0" Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.Html40RenderingExtension,Microsoft.ReportingServices.HtmlRendering" Visible="false""

3.Change the "false" to "true".

4.Restart the SSRS

And then you could export the report to HTML.

PS: Please make a copy of the config file before making any change.

can i in a cell have multiple content, like a graph transparent with an expression on top of it

Couldn't fully understand your requirement, could you give some sample? (screenshot is also welcome)

Regards，
Zoe

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

What can I do if my transaction log is full?--- Hot issues November

How to convert Profiler trace into a SQL Server table -- Hot issues November

Answer 2

Thank You, i see the setting is false. i need to get admin to change property to true
i see there is "HTML5", what is that?

i have so many cells & rows, so im thinking of creating like a dashboard as PowerBI cant automate sending of report without premuim and power automate
Much Smaller becuase i want to send the static output to users, i want to have the grandtotal/measure displayed with a graph of the breakdown as a background to see content

Answer 3

Hi,
If renderd in HTML is the report til interative, i would like to add drop downs like slicer?
Can i add tabs, like excel for another report?
Can i add print/export to pdf button?

Kindly advise, how i would go about this?

regards

Answer 4

Hi,

I have powerbi pro and we moving to qliksense (corporate), im trying to replace the static excel files with more dashboard reporting
do i need to setup a powerbi report server?
my issue is, i cant automate the reports with pro and not have power automate?

please advise?

regards

Answer 5

Hi,

Thank You, correct Powerbi is a better option. i unfortunately have to export to pdf manually as we moving away from pbi to qlik in 2022 and wont be purchasing powerbi robots nor pbi premium license :(

Regards