Hi,
I´m having a problem because I´m developing a report for my company and using Birt to accomplish it.
The report contains several datasets and i´m not having any problem (I´ve tested it and works) till I enter a new dataset that involves several big oracle tables (120.000.000 registers).
The Sql I´m entering in the dataset is correct (because I´ve tested it before in toad an sqldeveloper to ensure it has no mistakes), but when I enter the sql in the new dataset and press "OK" the screen becomes white (like it would be processing the query or something similar) but leaving it even 8 hours I can´t recover the control of Birt (so i must kill it to try again). I´ve tried lot of times with different datasets involving those big tables and none of them have finished.
Are there any solution to do it. I suppose Birt is checking or prefetching rows when I click the ok button and because the tables are so huge I think it can´t finish or hang itself.
Can I tell birt not to pre-execute the query but only giving me the name of the columns returned by the SQL in order to use it in the report?
Can anybody help me?
Lot of thanks.
Rubén.