Hi, I have an application in which every row will be filled with the result of a single query, every row an other query. To start with, about 50 rows -> 50 queries.
What is the recommended way to do this? Should I follow http://theformspider.com/learningcenter/tutorial-28-how-to-export-data-to-excel-from-formspider-datasources-and-grids/ or is there a smarter way using Jasper Reports with output to excel? (if so, how to set that up, all I get is pdf)
asked 04 Mar '13, 02:15
Currently, it's not possible to use Jasper Reports with output to excel. But if these 50 rows held in a single datasource you can use api_datasource.printToExcel API as explained in the tutorial you mentioned. If these 50 rows held in multiple datasources you can create a new datasource with the same query to be used in Jasper Reports and generate excel output from this datasource.
Hope this helps,
answered 04 Mar '13, 03:15
Ibrahim Sand... ♦♦
Are you looking for the best way to fill a single datasource with the result of 50 queries (one query for each row?), or is the major question how to export data to Excel?
answered 04 Mar '13, 04:22