ReportServer Forum

aditi.raiter

Member

Registered: 2018-05-01

Dashboard Interactivity

Is it possible to implement a dashboard where if a user selects a parameter range on a button click for a timeseries zoomable chart in one of the static html dadgets , the other report dadget parameters (in the same dashboard)  also change dynamically.

aditi.raiter

Member

Registered: 2018-05-01

Re: Dashboard Interactivity

Okay let me reword -  I have just 1 report on a dashboard. Is it possible to refresh this dashboard ( that is this 1 report) on a mouse click event that changes the report parameter?

I have got a BIRT report with charts that calls itself on a mouse click event. In report server I have implemented the chart drill down by passing an url like this :
"http://servername/reportserver/reportserver/httpauthexport?id=186254&user=admin&apikey=gpsk&download=false&&format=html&p_productLine=" + row["PRODUCTLINE"]
With this idea, the report opens in a separate url, which is not intended.

I would want the dashboard to be refreshed/reloaded on mouse click. Is this possible ?

Last edited by aditi.raiter (2019-02-04 20:28:11)

aditi.raiter

Member

Registered: 2018-05-01

Re: Dashboard Interactivity

Figured out that I could use "http://YOUR_IP:PORT/REPORTSERVER_BASE_FOLDER/ReportServer.html#reportexec/id:" instead in my BIRT report ( on click event ) and call it in a report dadget with html view.

Reference : https://forum.reportserver.net/viewtopic.php?id=493

I was able to call the same report in the same/similar page on a mouse click (on a chart) but the report that opens up is in pdf. Is there a configuration change to preview the BIRT report in html.

Bottom line : Looking for a solution to change the preview of a BIRT report to html instead of pdf now.

IF_Eduardo

Administrator

Registered: 2016-11-01

Website

Re: Dashboard Interactivity

Hi Aditi,

you can use the export shown here for this: https://reportserver.net/en/guides/admi … a-the-URL/, 6.11. Executing Reports via the URL

format    Defines the output format. Possible values are: html,pdf,csv,excel,png as well as TABLE_TEMPLATE.

Just select html as a format.

Regards,
Eduardo

aditi.raiter

Member

Registered: 2018-05-01

Re: Dashboard Interactivity

Thanks. I got it working within a frame. This solution needed a compound report though.

Is there a way to pass parameters between static html dadgets in dashboards? I know report parameter is an option but the idea is

1) Allow an user to view a dashboard with parameters using "Edit Report Parameters"
2) If a user wishes to analyse the data further and clicks a bar chart additionally, the remaining dadgets on the dashboad reload automatically with this additional new parameter (on the bar-chart)

aditi.raiter

Member

Registered: 2018-05-01

Re: Dashboard Interactivity

Any update on this please ? Can dadgets on a dashboard communicate with each other?

IF_Eduardo

Administrator

Registered: 2016-11-01

Website

Re: Dashboard Interactivity

Hi Aditi,

please check parameter dadgets. But if you need HTML dadgets to access parameters take a look here: https://forum.reportserver.net/viewtopic.php?id=627
Maybe you can use a script report rather than a static HTML dadget.

Regards,
Eduardo