Crosstab with 3 row groups

[f_lombardo]

Hi all.

 

I've been created lots of crostab reports with 2 row groups.

Now I'm trying to create a new one with 3 row groups, but I'm failing.

I'm using iReport 1.2.3. The the crosstab wizard of this program you can only create crosstabs with 2 row groups. So I used the "Row and column groups" tab in the "Crosstab properties" page to add a new group. Unfortunately the textfield I put in the 3rd row header shows a null value.

Now I'm wondering: is it it possible to create a 3 row groups crosstab?

 

Thanks a lot.

 

Bye

 

Franco

[harishsundaram]

Yes, indeed.

I have created reports with 3 rowGroups using Crosstab.

I don't know about iReport as I have been manipulating the .jrxml files directly.

 

~Harish.

[f_lombardo]

So, as I supposed, there is something wrong in my report.

Now, where could I find an example of a 3 row groups crosstab report in order to understanding my errors?

 

Thanks a lot.

 

Bye

 

Franco

[bhaugland]

I have also created the 3 row/column crosstabs. I have found that I need to drag the extra fields into the crosstab designer after I have added the rows or columns.

[bhaugland]

I have also created the 3 row/column crosstabs. I have found that I need to drag the extra fields into the crosstab designer after I have added the rows or columns.

[f_lombardo]

I don't understand what you mean when you say:

"I have found that I need to drag the extra fields into the crosstab designer after I have added the rows or columns."

 

Please, could you explain that?

 

Thank you very much.

 

Bye

 

Franco

[f_lombardo]

I found the problem: I didn't compile the bucket expression with the right field.

 

Thank you all for your help.

 

Bye

 

Franco

[bhaugland]

In iReports if you are in the cross tab designer you will see blank cells where your new data cells need to be. somewhere on your screen there is a tab called Crosstab objects. Take a look at the objects listed. Some of them will be from the new row groups you have added. You can drag the Crosstab objects into the empty cels on the cross tab designer. This gets around the fact that the wizard only asks for 2 groups.

 

Hope this helps. I struggled with this for quite a while too.