[Nileshwari]

Hi,

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

[averma]

Hi Nileshwari,
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:
http://www.eclipse.o...viewerUsage.php
You could also your BIRT run time API (java based) and generate those outputs in your application:
http://www.eclipse.o...rtEngineAPI.php

Ashwini

[Nileshwari]

Thanks for quick reply )

It would be great if u provide me with a simple web application where on clicking the button the report is generated in a particular format.

[averma]

You can download the runtime application here:
http://download.ecli...birt/downloads/

Once application is deployed use the following url to link your icon to generate pdf document like so:

http://localhost:8080/birt/frameset?__report=test.rptdesign&sample=my+parameter&__format=pdf

[Nileshwari]

Thanks a lot!!!!

i will try this n will do get back to you to let about this demo n for further help

[Nileshwari]

Hi,

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.

Attached File(s)

•  TemplateError.JPG (137.17K)
  Number of downloads: 0
•  executed_Image.JPG (70.71K)
  Number of downloads: 1

[Nileshwari]

Hi,

I am able to deploy in tomcat where i can view Index.jsp.
But after clicking "View Example", error pops up i.e.

"org.eclipse.birt.core.exception.BirtException: Cant startup the OSGI framework"



Please help out as soon as possible!!

[Nileshwari]

here is the attached file...

[averma]

Why are you importing birt.war in your eclipse environment? The easiest integration would be to let BIRT app run separately, unless you want to merge the context of your webapp with BIRT and run as a single web application. If you are trying to debug your app, an easier approach would be to use remote debugging. Here's an article I found on google search (there are several others):
http://ihategeek.wor...pse-and-tomcat/

[Nileshwari]

averma, on 27 June 2011 - 09:29 AM, said:

Why are you importing birt.war in your eclipse environment? The easiest integration would be to let BIRT app run separately, unless you want to merge the context of your webapp with BIRT and run as a single web application. If you are trying to debug your app, an easier approach would be to use remote debugging. Here's an article I found on google search (there are several others):
http://ihategeek.wor...pse-and-tomcat/

[Nileshwari]

Hi,

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!

[averma]

There are couple of ways you can do this:
1. Use URLs to BIRT Viewer running as a separate application on your app server. (less effort)
http://www.birt-exch...ebViewerExample
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)
http://www.birt-exch...th_BIRT_Engine)


Hope this helps

Ashwini