[Transpose columns to rows and pass to subreport]

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

[Small question about creating criteria page]

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

[How to find out final SQL query ?]

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.

[Multi-Select Input Control]

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

[Criteria page in JaspreIntelligence]

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

[jasper server report empty in viewer on server]

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

[Setting a chart's range??]

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.