bpamarti

My dataset that is being passed to the report template is as under: Id Name Appt TIme Appt Location 11 SampleName 8:00AM Location A 11 SampleName 10:00AM Location B 12 SomeName 7:00AM Location A 12 SomeName 11:00AM Location B For each "Id" there can be any number of rows with different appointment times. I just want to print "One" row for each Id with earliest appointment time. So the detail band in the jasperreports should print -- Id Name Appt TIme Appt Location 11 SampleName 8:00AM Location A 12 SomeName 7:00AM Location A Is there any functionality to do this in jaserreports. Any help greatly appreciated!! Post Edited by bpamarti at 09/29/2009 20:19

Hi Group: In my report whenever the detail section overflows to the next page there's an extra white space left at the bottom (where a couple of rows of data easily fits) Does any of you guys know how to eliminate this space. Thanks, Pamarti

Thanks Srikanth, It works as desired...

Hi Group: I have created a report where I want one of the columns (say col3) to be printed in a blue bold font when certain condition is satisfied else I want them to be printed in normal black font. I have included the following expression in the <printWhenExpression> tag in the <reportElement> tag.... new Boolean(!($F{col1}.equalsIgnoreCase("N/A")) && !($F{col2}.equalsIgnoreCase("N/A"))) When I run the report only those values which qualify for the above expression are printed and the rest are not printed in the report and left blank.... Am I missing something here....? Regards, BalaKishore

Hello: I created a jasperreport with a subreport embedded beneath every row in the main report. Everything works fine but there is an extra white space beneath every row in the main report when there is no data in the subreport. And also in other reports I noticed that there is extra space left unfilled in the detail section eventhough there is space to fit in couple of rows of data. I am sure there has to be some setting to eliminate this whitespace ... can anyone shed some light on this... I have set the isRemoveLineWhenBlank to "true" in the reportElement....below is the code snippet for the subreport in the jrxml file Thanks a lot! Code:<subreport isUsingCache="true"> <reportElement x="0" y="28" width="760" height="42" key="subreport-3" positionType="Float" isRemoveLineWhenBlank="true"/> <subreportParameter name="pat_mrn"> <subreportParameterExpression><![CDATA[$F{pat_mrn}]]></subreportParameterExpression> </subreportParameter> <subreportParameter name="sch_event_id"> <subreportParameterExpression><![CDATA[new Integer($F{sch_event_id})]]></subreportParameterExpression> </subreportParameter> <dataSourceExpression><![CDATA[new JRBeanCollectionDataSource($F{comments})]]></dataSourceExpression> <subreportExpression class="java.lang.String"><![CDATA[$P{SUBREPORT_DIR} + "waiting_comments_rpt.jasper"]]></subreportExpression> </subreport>