gengon555

The workaround by cloning reports is not solution, because in other cases I need to add the same report with different params in one reportbook many times.

Hi! I have ReportBook which consists of two same reports with different input data. That is: <part uuid="f771936d-e47f-4ecb-abb9-b205bff40816"> <p:subreportPart xmlns:p="http://jasperreports.sourceforge.net/jasperreports/parts" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/parts http://jasperreports.sourceforge.net/xsd/parts.xsd"> <subreportParameter name="REPORT_CONNECTION"> <subreportParameterExpression><![CDATA[$P{REPORT_CONNECTION}]]></subreportParameterExpression> </subreportParameter> <subreportParameter name="OPER_GROUP"> <subreportParameterExpression><![CDATA[1]]></subreportParameterExpression> </subreportParameter> <subreportExpression><![CDATA["test1.jasper"]]></subreportExpression> </p:subreportPart> </part> <part uuid="af7aceb6-10ce-4732-a263-411a37c124ac"> <p:subreportPart xmlns:p="http://jasperreports.sourceforge.net/jasperreports/parts" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/parts http://jasperreports.sourceforge.net/xsd/parts.xsd"> <subreportParameter name="REPORT_CONNECTION"> <subreportParameterExpression><![CDATA[$P{REPORT_CONNECTION}]]></subreportParameterExpression> </subreportParameter> <subreportParameter name="OPER_GROUP"> <subreportParameterExpression><![CDATA[2]]></subreportParameterExpression> </subreportParameter> <subreportExpression><![CDATA["test1.jasper"]]></subreportExpression> </p:subreportPart> </part> </groupHeader> When I try to publish it to server, Studio throws exception: Should I clone the report to test2.jasper and change the name of the second report in the reportbook (test1.jasper -> test2.jasper), no error occurs.

I've tested - ReportBook and subReports are what I looked for. Thank you all for help!

I'll try to learn it by myself and write back. Thank you for giving me right direction :)

Well, I got it. I need SubReports :) Just the last question. If the first query returns room-id 1 to 20 instead of 1 to 10 on some a day, the reports for room-id 11-20 will be added to the Report book automatically, right? I just need to export Report Book to jasper server, schedule and that's all, right?

Thanks for your replies! C-Box, you are right. I've already begun reading about ReportBook, but didn't get how to make the set of report in a dynamic way. I mean, I have a table with set of rooms (result of first query - select roomID from rooms) and a typical report about room visitors (the second query - select ... from Visitors where roomID=PARAMETER). I'm able to make drop-down list to choose the parameter and generate every report manually, but I want to generate report for every value of the first query as parameter for the report automatically, schedule it.

Good day! I have a task to generate a set of typical reports based on sql query result. That is, I have a query "select col1 from tab1" returning, for example, N values and I have a report filled by sql query "select ... from tab2 where col1=<PARAMETER>". So I need to generate N reports with PARAMETER = each value from the first query. Number of returning values from the first query is varying. How can it be done?