Home
Analytics
Run birt report automatically
mh10
Hi,
I am looking to execute birt report automatically/ with scheduled task and save its PDF/excel format output
Any suggestions?
Find more posts tagged with
Comments
bhanley
iServer and iServer Express have a full set of tools built in for scheduling and automation.<br />
<br />
<a class='bbc_url' href='
http://www.birt-exchange.com/products/birt-report-server/#features'>Products
and Services - BIRT Report Server - Overview - BIRT Exchange</a><br />
<br />
Short of using the server tools, you would have to develop the scheduling process using the BIRT APIs.
mh10
right now i am not using birt iServer<br />
<br />
can you explain me more about the scheduling process using the BIRT APIs<br />
<br />
<br />
<br />
Thanks<br />
<br />
<br />
<blockquote class='ipsBlockquote' data-author="bhanley"><p>iServer and iServer Express have a full set of tools built in for scheduling and automation.<br />
<br />
<a class='bbc_url' href='
http://www.birt-exchange.com/products/birt-report-server/#features'>Products
and Services - BIRT Report Server - Overview - BIRT Exchange</a><br />
<br />
Short of using the server tools, you would have to develop the scheduling process using the BIRT APIs.</p></blockquote>
bhanley
There is not a way to schedule directly via the BIRT APIs. The APIs themselves do not have the persistent process that runs in the background to initiate the report generation. That is the portion that must be developed outside the BIRT APIs. Once you have built that master background process, the BIRT APIs will give you all you need to actually execute the report into whatever format you desire.
Since you are not using iServer, I would imagine you have already developed some capacity to generate and view reports. You will be able to re-use that via a this scheduling process should you decide to build it out.
mh10
Right now i am using BIRT report web viewer to see the reports, as it shows report in HTML format then i use it provided tab to convert into pdf/ excel.<br />
<br />
if i don't want to use this and just want to run report to give its pdf/excel output directly then what i have to do?<br />
<br />
<br />
Thanks<br />
<br />
<br />
<br />
<br />
<blockquote class='ipsBlockquote' data-author="bhanley"><p>There is not a way to schedule directly via the BIRT APIs. The APIs themselves do not have the persistent process that runs in the background to initiate the report generation. That is the portion that must be developed outside the BIRT APIs. Once you have built that master background process, the BIRT APIs will give you all you need to actually execute the report into whatever format you desire.<br />
<br />
Since you are not using iServer, I would imagine you have already developed some capacity to generate and view reports. You will be able to re-use that via a this scheduling process should you decide to build it out.</p></blockquote>
Virgil Dodson
You can use the __format URL parameter to go directly to PDF.<br />
<br />
<a class='bbc_url' href='
http://localhost:8180/birt23/run?__report=sales.rptdesign&__format=pdf'>http://localhost:8180/birt23/run?__report=sales.rptdesign&__format=pdf</a>
;
mh10
I am looking to write a windows batch program in which it will invoke BIRT report and save its PDF/Excel output to specifies location<br />
<br />
<br />
Any suggestions?<br />
<br />
<br />
<blockquote class='ipsBlockquote' data-author="vdodson"><p>You can use the __format URL parameter to go directly to PDF.<br />
<br />
<a class='bbc_url' href='
http://localhost:8180/birt23/run?__report=sales.rptdesign&__format=pdf'>http://localhost:8180/birt23/run?__report=sales.rptdesign&__format=pdf</a></p></blockquote>
;
bhanley
You could use some command line interface (like cURL) to execute the URL that Virgil showed above. You would still need to add the scheduling logic to make sure it executed on a regular basis.
mh10
ok. In this url format if i have to send input parameters to the report then how it has to be?<br />
<br />
<a class='bbc_url' href='
http://localhost:8180/birt23/run?__r...n&__format=pdf'>http://localhost:8180/birt23/run?__r...n&__format=pdf</a><br
/>
<br />
<br />
<br />
Thanks
bhanley
You can append as many parameters as you need to the report in the format <strong class='bbc'><em class='bbc'>param_name</em>=value</strong> separate each pair by an ampersand of course.
mh10
thanks bhanley,<br />
what is the syntax for __outputName in run command of birt viewer?<br />
Looking to save pdf/execl out put to given file location<br />
<br />
<br />
<br />
<br />
<blockquote class='ipsBlockquote' data-author="bhanley"><p>You can append as many parameters as you need to the report in the format <strong class='bbc'><em class='bbc'>param_name</em>=value</strong> separate each pair by an ampersand of course.</p></blockquote>
mh10
Any suggestions?<br />
<br />
<blockquote class='ipsBlockquote' data-author="mh10"><p>thanks bhanley,<br />
what is the syntax for __outputName in run command of birt viewer?<br />
Looking to save pdf/execl out put to given file location</p></blockquote>
rpolunsky
Your other option is to use the genReport.bat command file (and supporting libraries and files) that is part of the BIRT runtime library package. I've done this a couple of times; it's time-consuming (as all DOS batch coding is) but it works.
Then you can put something in your Windows scheduler to invoke the top-level batch file that runs the invoking command lines.
