topic Re: Create a button to refresh data - SAS VA Report in SAS Visual Analytics

Create a button to refresh data - SAS VA Report

cesarssantos — Mon, 22 Oct 2018 13:15:37 GMT

Hello Experts,

I want to create a button to refresh my report. Yes, I can use the More Options > Refresh Report, actually this is exactly what I need, but in a new button, one inside my report, not in the SAS page head.

Is there a way to do that?

I already looked in this two others questions:

https://communities.sas.com/t5/SAS-Visual-Analytics/Visual-Analytics-Refresh-Report/m-p/192590#M1443

https://communities.sas.com/t5/SAS-Visual-Analytics/How-to-Auto-Refresh-SAS-VA-Reports-to-show-latest-data/td-p/260324?nobounce

But they don't have a clear solution.

Thank you guys!

Re: Create a button to refresh data - SAS VA Report

ewv — Mon, 22 Oct 2018 16:28:44 GMT

Why not just put a note in the report telling users to hit F5? I know it's not as sophisticated as a button, but from my experience any buttons, etc that you can add to a report are only used for simple data manipulation/filtering of report objects

Re: Create a button to refresh data - SAS VA Report

cesarssantos — Mon, 22 Oct 2018 17:56:04 GMT

When you hit F5 the report is "closed", then Report Viewer displays the last reports.
At the least, this happened to me when i tried.

Thank you.

Re: Create a button to refresh data - SAS VA Report

ewv — Mon, 22 Oct 2018 18:32:48 GMT

You know what the exact same thing happens to me too. I figured it would've refreshed the report. Sorry about that, I should've tested my solution first!

Re: Create a button to refresh data - SAS VA Report

cesarssantos — Mon, 22 Oct 2018 18:39:38 GMT

It's ok!
It was worth to try.
Thanks!

Re: Create a button to refresh data - SAS VA Report

Meera_SAS — Mon, 22 Oct 2018 18:55:13 GMT

I am unable to tell if this question is for VA 7.4 or VA 8.x on Viya. If this is Viya you could use the report level refresh or object level refresh (available in 8.3 onwards) functionality in VA Viewer to refresh a report or objects in the report. Report refresh functionality is also available in VA 7.4.

Re: Create a button to refresh data - SAS VA Report

cesarssantos — Mon, 22 Oct 2018 19:25:35 GMT

I'm talking about VA 7.4 in a Windows plataform.
Thanks!

Re: Create a button to refresh data - SAS VA Report

c_clay — Thu, 01 Nov 2018 14:54:24 GMT

Depending on your report you could try something like this:

Create calculated item

choose result type Character

Type the text you want shown on button e.g. "Refresh report"

Put a Button Bar in your report and assign the calculated item

Now make interaction to the objects in your report that you want to refresh.

As the user hit the button bar the objects interacting with button bar should refresh.