harishsundaram

Thanks. I find these work arounds to be quite amazing :-) ~Harish

Hi, My report contains several sub-reports within the main report and I am using dummy groups to fit them all into the same pdf. Each subreport contains a crosstab table, which extends to two or three pages. In the subreport, I've used <pageHeader> sections. However, the <pageHeader> gets displayed only on the page where the table starts and not on the subsequent pages :( I want the <pageHeader> to be displayed on each and every page of each and every subreport, even if the tables extend to multiple pages. Is this possible? Or is there any workaround? Thanks in advance. ~Harish Post edited by: harishsundaram, at: 2006/09/14 13:44

Yes, indeed. I have created reports with 3 rowGroups using Crosstab. I don't know about iReport as I have been manipulating the .jrxml files directly. ~Harish.

I am using crosstabs in my report and I want the different row headers in the order that I want and not in the alphabetical order. e.g. in my table I have the following fields: ------------------------------ Date Product Type Value ------------------------------ 1-Sep FNCL 7 87968 1-Sep FNCL 8 9689 1-Sep FGCL 7 1235 1-Sep FGCL 8 1968 1-Sep YGAB 7 1235 1-Sep YGAB 8 1968 Now, in my report, the Date field above is the dynamic column header and my report looks something like: ------------------------------ 1-Sep 1-Aug ------------------------------ FGCL 7 1235 ... 8 1968 ... ------------------------------ FNCL 7 87968 ... 8 9689 ... ------------------------------ YGAB 7 1235 ... 8 1968 ... ------------------------------ However, I want the order to be:- FNCL first, then YGAB and then FGCL as my row headers. i.e. this is what is needed: ------------------------------ 1-Sep 1-Aug ------------------------------ FNCL 7 87968 ... 8 9689 ... ------------------------------ YGAB 7 1235 ... 8 1968 ... ------------------------------ FGCL 7 1235 ... 8 1968 ... ------------------------------ How do I achieve this? In my select query, I tried to put an "order by" clause taking help of another table, but still, I guess Jasper again sorts alphabetically. I dont want Jasper to sort it again. Please Help. Thanks in advance. ~Harish.

Hi, Im using jasper reports (1.2.4) on Linux and generating the reports over there. My crosstab column headers are not on a straight line! One is a little up and the other a little down. The same thing, though, looks gr8 when I generate the report on Windows. Any clues why this happens? Regards, ~Harish.

Hi, I am using Crosstabs in my jasper reports. Now, when I am filling up my report, some fields do not exist in the table for a few crosstab column names. e.g. there exists a row in the table for Jan 2006, but not for Feb 2006. In this case, in the Feb 2006 crosstab cell, "null" is displayed in the report. Is there a way to change this to 0 or a '-'? Thanks in advance. Regards, ~Harish.

Hi, I am using crosstabs in my report and am doing the calcuations using <measureExpression> Here, I call a Helper class method called "isDateEqual(java.util.Date date, java.util.Date maxDate) Here's my measure expression: Code:<measure name="LatestMonthSum" class="java.lang.Float" calculation="Sum"> <measureExpression> <![CDATA[com.test.Reports.ReportHelper.isDateEqual($F{IssueDate},$P{MaxIssueDate}) == 0 ? new Float(0.0) : new Float($F{IssueAmt}.floatValue())] </measureExpression> </measure> Note: $F{IssueDate} = <field> in the crosstab sub-data set $P{MaxIssueDate} = Crosstab parameter, passed to the crosstab sub-data set. Now, What's happenning is that the method isDateEqual() is never called. Then, to kill my curiousity, I created a method isDateEqual(java.util.Date date) If I call this method using: Code:[code]com.test.Reports.ReportHelper.isDateEqual($F{IssueDate})The method is called. But if I call the same method using: Code:[code]com.test.Reports.ReportHelper.isDateEqual($P{MaxIssueDate})The method is not called. Is there any other way to pass a crosstab parameter to a java method in a <measureExpression>? Thanks in advance, ~Harish. Post edited by: harishsundaram, at: 2006/08/22 10:18

Hi, How do I make sure that in my <crosstabCell>, 0 is displayed instead of "null" in the report when no data exists in the database table? I tried using a helper method: <textFieldExpression class="java.lang.String"> <![CDATA [((ReportHelper.isValid(new Float($V{DataValue} .floatValue())) == 0)) ? "-" : (new Integer(java.lang.Math.round($V{DataValue}.floatValue()))).toString()]]> </textFieldExpression> This doesn't work :-( Thanks in advance, ~Harish.

Hi, Thanks for the quick reply. It does solve my problem :-) It's interesting how a dummy group can solve this although there's nothing to group. Thanks again, ~Harish.

Hi I am new to jasper reports and am currently struggling with sub-reports. I'm using jasper reports 1.2.4 I have a master report with more than 20 sub-reports. However, I'm not able to make each sub-report start on a new page. How do I make sure that each sub-report starts on a new page? Thanks in advance, ~Harish