I need to store my report designs in a database table rather than storing them in a folder on the server, is there a way to store these in the database and read the design from that table and send the design to the run and render task when a report request is made? I could store these in a column either as xml or as a file. Has anybody done this? I'm having problems implementing this.

Haven't done this specificallly, but I know of quite a few people that have.
The .rptdesign is just a text file, so if you store as text and then pull
it out and feed that into your ReportEngine it should work.

What specific problems are you running into?

Scott Rosenbaum
Innovent Solutions, BIRT PMC

> I need to store my report designs in a database table rather than
> storing them in a folder on the server, is there a way to store these
> in the database and read the design from that table and send the
> design to the run and render task when a report request is made? I
> could store these in a column either as xml or as a file. Has anybody
> done this? I'm having problems implementing this.
>
> Thank you,
>

I have tried pulling the information from the database into a String and then just passing the string to the openReportDesign method. I have also tried passing it in using a ByteArrayInputStream getBytes method. Both result in an invalid xml parsing error. I have validated the xml and it is well formed.

I fixed the above problem, but now I am getting
j
avax.servlet.ServletException: org.eclipse.birt.report.engine.api.EngineException: The design file can not be found.

I'm pretty new to java, so it takes me quite a while to whittle away at these issues.