Another Subreport Issue

[Frans Lubbe]

Hi there,

I have one subreport that I specify in the main jrxml file as

<subreport>
                            <reportElement x="0" y="0" width="55" height="24" uuid="655570ea-7932-4173-a7e8-464aac9ec3c4">
                                <printWhenExpression><![CDATA[$V{DUTY_ALLOC_ID} != null]]></printWhenExpression>
                            </reportElement>
                            <subreportParameter name="P_DUTY_ALLOC_ID">
                                <subreportParameterExpression><![CDATA[$V{DUTY_ALLOC_ID}]]></subreportParameterExpression>
                            </subreportParameter>
                            <connectionExpression><![CDATA[$V{REPORT_CONNECTION}]]></connectionExpression>
                            <subreportExpression><![CDATA["REPORT_DIR" + "DutyRoster_Detail.jasper"]]></subreportExpression>
                        </subreport>

REPORT_DIR is an Oracle database directory specified to the path where my files are located on my database server.
I have placed DutyRoster_Detail.jrxml, and DutyRoster_Detail.jasper in the path REPORT_DIR = /u01/dowload

As per instructions, I have added the subreport jrxml file to the table JRXML_REPORT_DEFINITIONS with the column JRD_NAME = 'DutyRoster_Detail'

Any help much appreciated please.

Thanks in advance.

[Frans Lubbe]

I have also tried with this

 <subreportExpression><!["DutyRoster_Detail.jasper"]]></subreportExpression>

[Andreas Weiden]

There is no need for any database-directory. PL-jrxml2pdf only looks into the table JRXML_REPORT_DEFINITIONS with the name specified in the subreportExpression. Any path is removed. There is an example report delivered with the zip showing the behavior. Remember that the report-name is case-sensitive.

Regards,
Andreas

[Frans Lubbe]