f_lombardo Posted September 13, 2006 Share Posted September 13, 2006 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 Link to comment Share on other sites More sharing options...
harishsundaram Posted September 13, 2006 Share Posted September 13, 2006 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. Link to comment Share on other sites More sharing options...
f_lombardo Posted September 13, 2006 Author Share Posted September 13, 2006 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 Link to comment Share on other sites More sharing options...
bhaugland Posted September 13, 2006 Share Posted September 13, 2006 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. Link to comment Share on other sites More sharing options...
bhaugland Posted September 13, 2006 Share Posted September 13, 2006 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. Link to comment Share on other sites More sharing options...
f_lombardo Posted September 13, 2006 Author Share Posted September 13, 2006 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 Link to comment Share on other sites More sharing options...
f_lombardo Posted September 13, 2006 Author Share Posted September 13, 2006 I found the problem: I didn't compile the bucket expression with the right field. Thank you all for your help. Bye Franco Link to comment Share on other sites More sharing options...
bhaugland Posted September 14, 2006 Share Posted September 14, 2006 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. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now