rx7haze

I have a main report with a single row of data consisting of many columns such as: column a, column a desc, column b, column b desc,... I would like to create a new dataset that transposes columns to rows such as: column a, column a desc column b, column b desc . . . Then pass the dataset to a subreport. I'm not even sure where to start with this. Thanks, Bill

Can you give a brief explanation on how to do this? I'm assuming that on the JasperServer it is handled on the report wizard screen titled..."Report Wizard - Custom Input Control and Report Screens". I'm not sure how to get started with this. Where do I need to place the jsp page? In the same folder as the report unit? Then, from my custom page, how do I call up the report that lives on the server? Thank you, Bill

I too would like to know how to capture the sql statement that will be passed to the database. I'd like to use the System.out.println command but I don't know how to reference the query. Thanks.

Is it possible to read the values of the multi-select input control into iReport using only the GUI interfaces? Post edited by: rx7haze, at: 2006/11/06 13:35

When you add the input control specify the type as single select query.

I have a report that was created in iReport 1.2.7 and displays correctly in the jasper viewer from within iReport. I posted the report on my jasper server (v1.1.0). When I view the report on the server it shows up empty. However, if I click the pdf buton from the blank report, a pdf file will open for the report and is filled in with data from my database. Is there a setting somewhere that I need to tell the server to fill the report in the viewer? Thanks, Bill edit: if i send to pdf or word the report gets filled with data. the viewer and excel display empty. Post edited by: rx7haze, at: 2006/11/01 15:15

I finally figured out my problem. Mostly has to do with lack of experience with java. When using the sample report and the sample BarChartCustomizer, I did not realize you needed to compile the BarChartCustomizer.java file. So the file I need to point to is BarChartCustomizer.class. Along with the classpath pointing to directory housing this file. It works wonderful.