Integration with Eclipse & Ad hoc report generation
Posted 14 June 2011 - 03:01 AM
I am facing following problems:
1. Can BIRT be used to handle ad hoc & drag-n-drop queries?
2. In my project, I have jsp with 3 icons(XML, PDF & Excel Sheet) on it. On click, corresponding format file
should be generated with the records that are checked-in by the user.
So the Query will be generated at run-time.
Can BIRT handle such query?
Can u provide me with a dummy web application project which shows the integration of BIRT with Eclipse Helios 3.6 & resolves the above queries?
Please help me out!
Its very urgent..plzzzz
Posted 14 June 2011 - 01:44 PM
I am not sure I understand first part of your question. By adhoc query if you mean dynamically changing the associated SQL query, BIRT gives you many ways to do that. You can specify filers/use parameters or even modify the underlying query using some scripting in your BIRT report. If you qualify your question I can point you to a specific example.
BIRT comes with open source sample viewer web application that you can deploy in a java based app server (like Tomcat) and link your icons using URL to generate output in the required format. You can find more about this viewer here:
You could also your BIRT run time API (java based) and generate those outputs in your application:
Posted 15 June 2011 - 09:27 AM
Once application is deployed use the following url to link your icon to generate pdf document like so:
Posted 24 June 2011 - 10:01 PM
I have downloaded the zip you mentioned in above link.
After running 'birt.war' on Tomcat, i got the desired page.
Please see the attached screen-shot "executed_Image.jpg".
But when I import the WAR in eclipse, as there is no .classpath, .project and .settings folder.
Hence, there was no run on server option available of the application.
So I created a new web-application & changed the required parameters in those files i.e. project name as 'birt' & pasted it in the application.
After doing this, run on server option was available.
But I found errors on jsp's. I think it is because of the 'web-template.xml' where 'xsi:schemaLocation' is declared.
Please refer the attached screen-shot 'TemplateError' of the same.
I don't know why this error has occurred.
Am I on the right path?
If yes, kindly help me to resolve it?
n if no, please help me out with right way to do it.
Kindly reply as soon as possible!!
Awaiting for your earliest reply.
Posted 27 June 2011 - 09:29 AM
Posted 27 June 2011 - 10:21 PM
Posted 27 June 2011 - 10:50 PM
Thanks for the reply.
I want my web application to generate report in diff formats (which will be done using BIRT)
So I need to understand how to integrate BIRT with my web-app.
Hence I imported WAR file to study it. But unfortunately got stuck with errors.
For my web-app, Eclipse Helios 3.6 with Maven is in use.
It would be best...if you help me with the website that explains me initial step to be taken to generate report using BIRT in sample web-app. Or else, it would be great if you can help me out for the same.
Because, else I will land up in mess!!!!
Please help me!
Posted 28 June 2011 - 10:23 AM
1. Use URLs to BIRT Viewer running as a separate application on your app server. (less effort)
To generate a different format you can append the format specification inside the URL (see my earlier reply)
2. Use APIs to generate the report in your web application (more effort)
Hope this helps