The problem is in Crystal Report login info. before showing the report you have to set login info to all tables which are included in main report and their sub reports. You are using Disconnected Datasource Report Show method. so you don’t need to provide login info to report document. your problem is here. report.SetDataSource(ds); … Read more
Follow the steps below to pass parameters into subreports: Create main report parameter, such as DATE_PARAM. Open sub report and Create a parameter with the same name and the same type. Go back to main report Right-click on sub report, select properties Choose parameter Add parameter from main report to sub report with parameter name … Read more
Finally after 3 day of headache I solved my trouble. I’m using maven like tool of project managment and I’m working on a modular project with this structure |– parent |– model –pom.xml |– services –pom.xml |– web-app –pom.xml The porblem was that the file that I try to load like Input stream was in … Read more
The structure will be Main report with query produkList.items that display’s Product Name Subreport in detail band with <dataSourceExpression><![CDATA[((net.sf.jasperreports.engine.data.JsonDataSource)$P{REPORT_DATA_SOURCE}).subDataSource(“itemList”)]]></dataSourceExpression> to display the item table Subreport in summary band with query produkList.summary.summaryReportDetailList to display the summary table This is the result Below you will find the 3 jrxml producing this result, you need to adjust the … Read more
You can pass datasource via the built-in REPORT_DATA_SOURCE parameter. The example: <subreport> <reportElement x=”261″ y=”25″ width=”200″ height=”100″/> <dataSourceExpression><![CDATA[$P{REPORT_DATA_SOURCE}]]></dataSourceExpression> <subreportExpression><![CDATA[$P{SUBREPORT_DIR} + “subreport.jasper”]]></subreportExpression> </subreport> You can create new instance of datasource based on variable, parameter or field. The sample: <variable name=”HeadingsCollection” class=”java.util.Collection” calculation=”System”> <initialValueExpression><![CDATA[new java.util.ArrayList()]]></initialValueExpression> </variable> … <subreport> <reportElement x=”0″ y=”0″ width=”515″ height=”20″/> <subreportParameter name=”ReportTitle”> <subreportParameterExpression><![CDATA[$P{ReportTitle}]]></subreportParameterExpression> </subreportParameter> … Read more