Crosstab in iReport
iReport is an reporting tool used for designing jasper report in OpenERP. In OpenERP it is difficult to create a report that has a dynamic column. For instance consider an example of a project report that has details regarding the project task completion date. The task name will be the name of the column. In such cases, the cross tab in report comes handy.
Crosstab can be found in Palette in iReport. It can be dragged and dropped in to the report as needed. Initially create a report. Drag the crosstab from pelette and drop it in the report. A wizard for the crosstab creation pops out. First we have ro select the datasource for the crosstab. I am using my main report data source for my crosstab.
Select your datasource and click next.
Next we have to select the row group. Row group defines the rows for grouping. In this case since the report deals with task for each project. Hence i am defining the row group as project which is the name of the project.
Next we have to select the column group. Column group corresponds to the name of the column. In this case the task name is the name of the dynamically varying column. So i am defining the column group as task which is the task name.
Next we have to select what detail of the task that correspond to each project has to be displayed. In my report i am giving the start date of the project.
Next we have to select the layout of the crosstab. We can add row group, column group or guidelines based on the requirement. Now the crosstab appears in the main report. If we want to add some row group or column group, go to report inspector in iReport, Expand the crosstab right click on row group or column group and click Add row group or Add column group as we need.
Cross tab is a useful tool in iReport and can be modified as our requirement. The project report will be generated as:
HI, I am Working With
HI,
I am Working With iReport(jasper reports) and OpenERP 6.1.
I downloaded the integration addon of jasper_reports from community.
I am facing some problems while integrating it.
Can U Upload a blog for this?
Regards,
Murali
Hi, Can you please
Hi,
Can you please provide the details regarding iReport version you are using?
Sir, I am facing an issue
Sir,
I am facing an issue while using Cross tab.
I am getting a empty row while converting rows values into columns.
I have production of products and daily that products production will be entered. I want report as columns will be shown with month-year(jan-12) like that and rows will be with product name
Sir, I have seen many places
Sir,
I have seen many places people are writing java code to do some things like Dynamic Images and all.
Can you please post a blog on how to add java code to iReport?
Regards,
Murali
We have a requirement wherin
We have a requirement wherin we need to create a multi tab excel report. But, i dont have any idea on how to create it as i have worked only on single PDF/XLS creation.
Any help from your side would be highly appreciated.
Thanks
Regards
Sameer
Hai, Printing a XLS
Hai,
Printing a XLS report in multi sheet if you know how to create it in a single sheet is easy. Try to fetch the data in such a way that we will be able to group the data to be displayed in page one and two in to two groups. Create a new group in iReport to group the data fetched. Now select the group created and go to properties and check "Start on new page" option. Ensure that in page properties, "Ignore Pagination is not selected". Create a new property for the page as "net.sf.jasperreports.export.xls.one.page.per.sheet" and set it as "true". Now compile the iReport and print the report. The data in group 1 will be displayed in sheet 1 and data in group 2 will be in sheet 2.
Hello, I'm trying to print
Hello,
I'm trying to print data in different excel sheets. I did that you said until "Create a new property for the page as "net.sf.jasperreports.export.xls.one.page.per.sheet" and set it as "true"".
Could you please explain how and where I can create a new property?
Thank you
Hi, In report
Hi,
In report inspector, right click and select the properties. Properties window opens up as shown below:
You could see a entry called Properties. By default there will be 3 properties set. To add, click on the small button in right side of the property. A new window opens up as shown below:
Press on "Add". You could add the property name and value here.
Hello Prajul, Thank you for
Hello Prajul,
Thank you for answering.
I still can't print my report on different pages.
Let me explain from the beginning. I use iReport 3.5.1 version.
I created three new groups and I have a subreport in each group. I try to print each group/subreport on different page. I checked "Start on new page" option for each group. I verified that Ignore Pagination is not selected for each page. I created new property for each page "net.sf.jasperreports.export.xls.one.page.per.sheet" and set it for "true".
Did I miss something?
When I was adding new property I had "0 property set" by default but you told me that it's supposed to be three properties by default. Can it be the problem?
There is a Group Expression set by default as "$V{PAGE_NUMBER}" in the group properties. Should I change it?
Thank you in advance for your help
OY
Hi, Please verify the
Hi,
Please verify the property "net.sf.jasperreports.export.xls.one.page.per.sheet" is set for main report ie; the main report file that contain the groups and the subreports. Also please verify the Ignore Pagination is not set for the main report. If these properties are set, i don't see any problem in your report. Can you try it with the latest iReport available. There are many new features and bug fixes available for new report.