Insert/Update Queries with BIRT

Hi,
i have a problem and found nothing to solve it. I use Birt Report Designer 2.5.1. I have a report where i generate some values from the input data. This results i have to write in another database for history.

During the Report i write the results with scripting in some variables. Then i want to make queries to put them into the database. First of all is it possible and where and how can i make these queries.

Bye Arne

Find more posts tagged with

Comments

Hans_vd

Hi Arne,

BIRT is not the rigth tool for transporting data from one database to another.

But you might be able to do it using a stored procedure that selects the data, writes into the target database and returns the data to your report.

Hope this helps
Hans

Arne79

Hi Hans,
you are right but i have some constraints for the use of tools. The Background is that i have to report some values weekly always over the last 12 weeks. The data in the datasource will change from one week to another so that i have different values from the former weeks. So i need a way to write the data somewhere else automatic. Then i want to use birt to get the data of the former weeks and the new week from the database. Here is the problem, i look for a fast way, perhaps a local acces db or a txt file.

Bye Arne

Hans_vd

Hi Arne,

Can't you go with a stored procedure?
A local db or file doesn't seem to be too reliable.

In a stored procedure you can do whatever you like:
- create an extra table and write the data of the latest week into it, then select all data from the last 12 weeks from that table (that 'd be my preferred solution)
- write to a file
- ...

Regards
Hans

Arne79

Hi Hans,
The problem is that i only have permission to read from the main database but i think that would be the best way.

Bye Arne