Refresh report using HTML button

Hi all,
 
I have a report with no parameters. Now I want to refresh that report without having to close and open it again so that, for instance, it's shows the current time. So I put a HTML button on the report and now need to add some code to the OnClick event of that button. What code do I put there?
 
Thanks in advance,
buel2.

Find more posts tagged with

Comments

kclark

I think it should be something like this:
<pre class="_prettyXprint _lang-">
function refreshReport() {
window.reload();
}
</pre>

drbud

Thanks for your replay. It's been a while and I've tried several options found on the internet but still no luck

This is what I have. A report with:
a HTML text item containing: <VALUE-OF format="HH:mm:ss">new Date()</VALUE-OF>
a Data item containing: Formatter.format(new Date(),"hh:mm:ss")
a HTML button containing the script: this.onclick = function(event) { window.location.reload(true); }
 
When I run the report the current time is shown. So far so good.
Now when I click the refresh button the window is refreshed but the time stays the same.
So what am I doing wrong? Just can't figure it out...

pricher

Hi,
 
window.reload() does not re-run the report: it simply reloads the window. Because you get your date at report generation with a new Date() statement, it will always show the original date.
 
Since you are using an HTML button in your report, I am assuming you are using the commercial version of BIRT. In that case, you can use the following script on your button:
 
this.getViewer().submit();
 
This will submit a JSAPI call to re-run the report.
 
Hope this helps,
 
P.

drbud

Hi pricher,
 
Thank you for your explanation and possible solution.
 
I've changed the script to this.onclick = function(event) { this.getViewer().submit(); }
Now when I run the report en click the button this error message pops up: java.lang.NullPointerException
What is causing this error?
 
BTW I'm creating this report in Actuate BIRT Designer Professional

pricher

Which version of BIRT Designer are you using? Are you running the report in a Web Viewer? If you can, please send us your report design.
 
Regards,
 
P.

drbud

<div>Hi,</div>
<div> </div>
<div>* The "About Actuate BIRT Designer Professional" says I'm using: 
Actuate BIRT Designer Professional 
Version: 11.0.4 
Build id: 20121023 
* Yes, I'm running the report in Web Viewer 
</div>
<div>* See attachemt for my report design</div>
<div>[sharedmedia=core:attachments:10723]</div>

pricher

Hi,
 
I am unable to download your rptdesign. Can you upload again? Thank!
 
P.

drbud

Hope this one works...

pricher

Hi,
 
Yep, my example did not work in 11SP4.... It appears the functionality of the submit() function behaves differently.
 
After many tries, I came up with a solution that works well in 11SP4. On the text item (now with a yellow background), I added a bookmark named "text". On the button event, I changed the code to this:
 
this.onclick = function(event) { 
 var vid = this.getViewer().getCurrentPageContent().getViewerId(); 
 var t = document.getElementById(vid + "_text"); 
 t.innerHTML = new Date().toLocaleTimeString(); 
}
 
The part about getting the viewerid (vid) is important. When Actuate renders the report in HTML, it prefixes any bookmarks with a unique viewerId to ensure that there would not be any confusion if load the same report twice on the same page.
 
Hope this helps,
 
P.

drbud

Hello pricher,
 
Thanks a lot for all the effort you put in solving my issue. Your solution works! However, I don't really (really don't) understand how things work. Also I am wondering now what to do when I need to refresh more than 1 text or data item and / or one or more datasets...
 
The reason I got to this issue:
When I have a report that has a parameter, refreshing it is quite simple. But when there is no parameter this does not work. See attached screenshots. So I could add a dummy parameter to my report but I think that's an awful solution...

pricher

If you need to refresh a report with new data, then the best way is to re-run the report from the click of a button. To do this, you can use the following code on your Refresh button:
 
this.onclick = function(event) { 
window.open('./executereport.do?__executableName=/Report Designs/RefreshReport.rptdesign', '_self'); 
}
 
executereport.do is the command to execute a report from a URL. The above syntax will run it from your actual iportal context.
 
__executableName points to the rptdesign on your iServer volume. Change accordingly.
 
Nota bene: The report needs to be executed from iServer. If you run it from BD Pro, the rptdesign will not be found.
 
Hope this helps,
 
P.