rakeshc

Hi Friends, I am developing a report with iReport. The aplication asks to provide a list of items as ids that we have to pass strings as '7754','8231','6632'.... I had created a subreport which has the items according to the IDs. And I had added a page/column breker so that I can see each ID and items in the same page. next page will be next ID and its items. I had created a bar graph which shows IDs and Details, as a subreport and added in the main report. My problem is while running the report, each ID and its items are coming in individual pages, but the bar graph shows all the IDs and Values in each Graph. I want to seperate the graph like for each ID, only its values should be displayed. How can I do that?. I tried subdatasets, report groups etc to seperate graph for each ID. but no luck. My code looks like.... <bar3DChart> <chart hyperlinkTarget="Self" > <reportElement x="13" y="132" width="512" height="208" key="element-1"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <chartLegend textColor="#000000" backgroundColor="#FFFFFF" > </chartLegend> </chart> <categoryDataset> <dataset > <datasetRun subDataset="my_SubDataset"> <datasetParameter name="PARAM1"> <datasetParameterExpression><![CDATA[$F{VAL1}]]></datasetParameterExpression> </datasetParameter> <datasetParameter name="PARAM2"> <datasetParameterExpression><![CDATA[$F{VAL2}]]></datasetParameterExpression> </datasetParameter> . . . . . </datasetRun> </dataset> <categorySeries> <seriesExpression><![CDATA[$V{Var1}]]></seriesExpression> <categoryExpression><![CDATA[$F{val1}]]></categoryExpression> <valueExpression><![CDATA[$F{val1}]]></valueExpression> <itemHyperlink > </itemHyperlink> </categorySeries> <categorySeries> <seriesExpression><![CDATA[$V{Var2}]]></seriesExpression> <categoryExpression><![CDATA[$F{val2}]]></categoryExpression> <valueExpression><![CDATA[$F{val2}]]></valueExpression> <itemHyperlink > </itemHyperlink> Please help me to resolve this, Thanks in advance. Warm Regards, Rakesh

My code looks like.... <bar3DChart> <chart hyperlinkTarget="Self" > <reportElement x="13" y="132" width="512" height="208" key="element-1"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <chartLegend textColor="#000000" backgroundColor="#FFFFFF" > </chartLegend> </chart> <categoryDataset> <dataset > </dataset> <categorySeries> <seriesExpression><![CDATA[$V{Var1}]]></seriesExpression> <categoryExpression><![CDATA[$F{val1}]]></categoryExpression> <valueExpression><![CDATA[$F{val1}]]></valueExpression> <itemHyperlink > </itemHyperlink> </categorySeries> <categorySeries> <seriesExpression><![CDATA[$V{Var2}]]></seriesExpression> <categoryExpression><![CDATA[$F{val2}]]></categoryExpression> <valueExpression><![CDATA[$F{val2}]]></valueExpression> <itemHyperlink > </itemHyperlink> . . . . . . . Can you suggest by what way I can seperate the chart?

Hi Friends, I am developing a report with iReport. The aplication asks to provide a list of items as ids that we have to pass strings as '7754','8231','6632'.... I had created a subreport which has the items according to the IDs. And I had added a page/column breker so that I can see each ID and items in the same page. next page will be next ID and its items. I had created a bar graph which shows IDs and Details, as a subreport and added in the main report. My problem is while running the report, each ID and its items are coming in individual pages, bu the bar graph shows all the IDs and Values in each Graph. I wnt to seperate the graph like for each ID, only its values should be displayed. How can I do that? I had tried many methods, spent time for searching for a clue... I am not getting anything. Plese help me, Thanks in advance. Warm Regards, Rakesh

Hi friends, I am developing a jasper report with a bar chart. For that I had used some tutorials. It is not explained anything clearly. Can you please explain me "seriesExpression", "categoryExpression", "valueExpression" for bar charts. Thanks in advance Warm Regards, Rakesh

Hi, Please note my code for export to excel below. File jprintFile = new File("C:/iReport-2.0.1/classic.jrprint"); String Report_name = "Physiandetails"; try { String Physiandetails = Report_name + ".xls"; JasperPrint jasperPrint = (JasperPrint)JRLoader.loadObject(jprintFile); JExcelApiExporter xlsExporter = new JExcelApiExporter(); xlsExporter.setParameter(JExcelApiExporterParameter.IS_ONE_PAGE_PER_SHEET, Boolean.TRUE); xlsExporter.setParameter(JExcelApiExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS, Boolean.TRUE); xlsExporter.setParameter(JExcelApiExporterParameter.IS_DETECT_CELL_TYPE, Boolean.TRUE); xlsExporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint); xlsExporter.setParameter(JRExporterParameter.OUTPUT_FILE_NAME, Physiandetails); System.out.println("Exporting Report as Excel.."); xlsExporter.exportReport(); System.out.println("Export Complete."); After running the code, it will generate an excel report file with field names, but no data. I had tried so many trials to export excel with data. Please help me to solve the issue. Thanks&Regards, Rakesh

Hi svenn, Thanks for the advice, seems to be working now. Warm Regards, Rakesh

Hi, I want to create a bar chart for my project. I am using JFreechart for that. Can you people send me the link for the correct jar file for JFreeChart?(I am trying to create graph through a java class)I had tried lib folder in the jfreechart-1.0.8a, but I am getting error message for packages org.jfree.data.general.AbstractDataset, org.jfree.chart.JFreeChart, org.jfree.chart.ChartFactory are invalid. Please help me, Thanks in Advance. Warm Regards, Rakesh

Hi vk01, Kindly send me the code for jasper viewReport in Excel and PDF formats, I am searching a lot for the code. Thanks&Regards, Rakesh

Thanks svenn, for the response. I'll have a look at it. Rakesh

Hi Friends, I could create a report with subreport through iReport. Also, I could create a sample bar graph through JFree chart. Now I want to integrate both the iReport and JFree chart. Means, I want to show a report which is included report data with a bar graph corresponding to the report values. I searched in gogle a lot but, didn't got any helpful information. Please help me, Thanks in Advance. Thanks&Regards, Rakesh

I could resolve the problem, Thanks Rakesh

Thanks Kai, for the quick response. I had tried the way you suggested already and not working. I'll explain my problem. I have a main report and a sub report which is working fine together. Today I had added another sub report which requires two different parameters. I am working on iReport 2.0.1. I had created a report with two different parameters. then in the main report, i had selected subreport tool and created a sub report with the report mentioned above. Double clicked there, and added first parameter as PARAM and Expression as $F{PARAM}(please note that this parameter is using in the other subreport also). Then I had added Subreportparameter PARAM1 I had not given Expression for that(Error appars if i give expression). Then in the parameters field in the main report I had added PARAM1 and checked use as a prompt to show dialogue box for PARAM1. Didn't given any value for Default value expression.In subreport page, I had added the parameter name as PARAM1 and Default value expression is $F{PARAM1}. the query goes like this....where PARAM1 in ($P{PARAM1}) and PARAM in ($P{PARAM}). while running the report through main page, I am not getting any values for PARAM and PARAM1(The subreport is not appearing). But If i hardcode the values PARAM and PARAM1, It is appearing in the report. So I think subreport query is not getting the values for ($P{PARAM1}) and ($P{PARAM}). Once again, Thanks for looking into it. Regards, Rakesh

HI All, I had created a report and subreport with iReport successfully which is having one parameter input. Now I nave to pass two different parameters and create a subreport and attach with the main report. My query goes like this ......from phys_credentialing_gtt where REPORT_ID in ($P{REPORT_ID}) and PHYS_ID in ($P{PHYS_ID}).I set the REPORT_ID and PHYS_ID as parameters in the subreport and main report too so that the prompt will ask for REPORT_ID and PHYS_ID. But after runnung the report, No data for this is displayed in the report, if I hardcode the values in the query, it is displaying in the report. Please guide me how can I pass two different parameters in iReport. Thanks in advance. Warm Regards, Rakesh