Tables/Populate database ireport

[d.kanhar]

Hi,

 

I want to populate datas in my database or add table in my database. How do i do that. Then i select sql query editor beside "preview" tab, i get to see that it accepts only commants like "SELECT" "ORDER BY" etc.

 

Thanks.

[ajinkya_c]

Hi,

What i understand from your requirement is you want to create table and insert data into it through jaspersoft.

But as the jaspersoft is purely reporting tool which is used for BI analysis so i think this may not cater your requirement.

You can check with procedure, function & trigger in query builder may be some alternate way you can calculate and add data to your database.

Thanks

Ajinkya

[d.kanhar]

U mean function n trigger commands? ?

or default options? where to find them? and is it possible to create db in oracle and ise in ireport??

[d.kanhar]

Hi

 

If i install Oracle SQL developer separately and create databases in it, can i use the same DB in ireport?

 

Thanks.

[sjoerd.jump]

Hi d.kanhar

Yes you can. You have to add the new database as an datasource in iReport to be able to work with it.

This is how I work with my data.

I have created a database in Postgresql, created the tables and such, loaded it with some test-data.
Made the connection in iReport to the database and correct table.
Created my report based on the test-data
Set up jaspersoft ETL to load data to my database
Set up jaspersoft Server to  send me a report on a daily basis based on the data loaded by Jaspersoft ETL.

easy does it ;)