ivana.cace

Thank you jgust! Especially using Spreadsheet Layout and selecting all fields at once saves me days! In addition I change Page Width to 2500 (Properties > Advanced > Report Page), this makes the report easier to read. I've omitted the step of moving the static text from the Column Header to the Title Band, for me the column headers work fine in the Column Header band.

Our workflow is: 1- Write and tune SQL query for report (using SQuirrel SQL) 2- Create report using query in TIBCO Jaspersoft Studio 3- Publish and check report on JasperReports server, fix if need be 4- Set schedule for exporting .csv on JasperReports server After step 1 my report is finished. But to be able to export the report in step 4, I need to waste a lot of time on steps 2 and 3. Steps 2 and 3 take about 80% of the development time but add absolutely nothing to the end product which is just a csv. Why does it take up so much time? Well: For each field I have to manually place 2 textfields in the report. Exporting a 30 column table means repeating this 60 times. It is very very easy to make a mistake: to make the column too narrow to fit the values, or to misplace the textfield by one pixel and break the report completely. Fixing errors is very time-consuming. Changing the width of column 4 means moving 26x2 textfields. Reports are difficult to debug and if a database field changes name it is very time consuming to change the report (name is repeated in 6 different places.) So, my question is, is there any way to bypass report-building and just go from query to export?

I would like to add documentation in my report. The documentation is intended for developers and does not need to show up in the report on the server and cannot be in the csv export we make of the report. I have added comment like this: <!-- comment -->[/code]But it gets erased during upload.