aschinch
-
Posts
20 -
Joined
-
Last visited
Content Type
Profiles
Forum
Events
Featured Visualizations
Knowledge Base
Documentation (PDF Downloads)
Blog
Documentation (Test Area)
Documentation
Dr. Jaspersoft Webinar Series
Security Advisories
Downloads
Posts posted by aschinch
-
-
I want to excel export to an existing file which has some other things like charts, pivot tables, macros etc.
Is it possible to do this? I have seen JRExporterParameter INPUTFILE parameter, but this is not working.
-
I am also in need of embedding excel macro with Jasper reports.
Similarly I need to use existing excel pivot tables with Jasper reports.
Can someone update on these questions?
1. Can jasper support adding an excel macro
2. Can jasper overwrite / append to an existing excel file (which contains a macro or pivot table)
Thanks,
Avinash
-
I am also in need of embedding excel macro with Jasper reports.
Similarly I need to use existing excel pivot tables with Jasper reports.
Can someone update on these questions?
1. Can jasper support adding an excel macro
2. Can jasper overwrite / append to an existing excel file (which contains a macro or pivot table)
Thanks,
Avinash
-
We have a requirement of drawing line chart with drop lines.
Can anyone suggest how to achieve this?
-
I want to update this with the answers I found out -
1) Surprisingly there is no simple way to add lables to line charts. You need to use customizer class which will have code similar to this.
LineAndShapeRenderer renderer =renderer.setBaseItemLabelGenerator(new CustomLabelGenerator());true);
renderer.setBaseItemLabelsVisible( );
LineAndShapeRenderer)chart.getCategoryPlot().getRenderer();
CustomLabelGenerator is already available in the forum.
2) We need to apply some theme which will place the titles properly.
Post Edited by aschinch at 11/05/2009 08:27
Post Edited by aschinch at 11/05/2009 08:27 -
I have found a tool for achieving this which works alongwith jasper reports.
Aspose.Cells for JasperReports (http://www.aspose.com/categories/jasperreports-exporters/aspose.cells-for-jasperreports/default.aspx)
Though I am not able to comment about the quality, atleast to be aware that such an option exists.
-
We are currently using CSVExport from iReport. It is observed that the fields are not double quoted.
Can you inform how to resolve this issue?
-
My requirement is when I export the report in excel, it should be linked to the datatable on the same page.
And the chart should be updated when the data is changed.
Is it possible in Jasper reports? Immediate help is needed.
-
I am trying to export the file as CSV file. The file is generated correctly except that the columns are not surrounded by double quotes. I am using iReport to export. Has anyone faced and resolved this issue? Thanks.
-
I am trying to export the file as CSV file. The file is generated correctly except that the columns are not surrounded by double quotes. I am using iReport to export. Has anyone faced and resolved this issue? Thanks.
-
1) Is it possible to displayes values on Line chart and how?
2) My X-axis labels are too big and hence not displayed completely. is there any way to wrap this text and show
in orderly manner on the x-axis.
Any immediate reply will be highly appreciated.
-
This problem is solved or not. Currently you can specify the separator for CSV file. But the fields are not quoted.
I have a requirement for quoted fields. Is it possible? Thanks
-
I am not sure whether this question is answered before. The maximum number of rows in excel are 65000.
But we are facing some issues when the number of rows are more than even 5000.
Is there any known issue for maximum number of rows to be exported to excel?
Or do we need to change some settings? or some report design parameters like width of sheet etc. in order to get the maximum number of rows exported?
Post Edited by aschinch at 08/26/2009 11:21 -
Hi Teodor,
Thanks for your quick reply. I am sorry if I have not framed the question correctly.
But we need a report which is same as (http://www.jaspersoft.com/data-analysis-pivot-table) Data analysis pivot table. Can you guide how this report can be generated?
Thanks,
Avinash
-
I am working on one requirement, where we need a drill down report.
As soon as you click on some field in a report, it should take that field as parameter and open another detailed report.
This should happen even after you export the report in Excel.
Anybody has any suggestion about this?
Thanks in advance.
-
Thanks for your suggestions. I could overcome this issue by switching over to "iReport-nb-3.5.1".
This newer version of iReport has option called "Sheet Names" within export options for excel.
The names will be assigned to the sheets.
-
I am working on one requirement, where we need a drill down report.
As soon as you click on some field in a report, it should take that field as parameter and open another detailed report.
This should happen even after you export the report in Excel.
Anybody has any suggestion about this?
Thanks in advance.
Post Edited by aschinch at 08/12/2009 11:10
Post Edited by aschinch at 08/12/2009 11:11 -
I am working on Excel report displaying month name for each sheet. I know we can add jrxlsexporterparameter.sheet_names parameter from java code to change the names of the excel sheets. But I want to change the name of sheet dynamically based on the month. Also can this be done while previewing from iReport? I have checked export options under the options menu, but could not find it.
Excel Sheets dynamic renaming
in Products
Posted
Frankly, I have not used propertyExpression tag.
1) I have used following code to rename the sheets.
String[] sheetNames ={"Sheet1","Sheet2","Sheet3"};
JExcelApiExporter exporter = new JExcelApiExporter();
exporter.setParameter(JRXlsExporterParameter.
sheetNames);
SHEET_NAMES2) Another option is to use iReport for ranaming sheets. There is a property called "Sheet Names" in export options.