All I know is that we are using the BIRT viewer to render the results. It resides on a server of which I'm not involved. I would love to programatically set the results to always return in Excel, but could not find any option like that in the Report Design in BIRT. I was hoping I just missed the option and someone could tell me where to set that option.
The query actually finishes very quickly - within seconds due to indexes, but returns a massive amount of data (General ledger data for a whole year -- 100,000 rows or more) that times out the browser during rendering. Due to the end user wanting to see that amount of data I cannot reduce the result set.
|