robinbowes

Peter, Thanks for the reply, but removing "Parameters Map Expression: $P{REPORT_PARAMETERS_MAP}" doesn't make any difference. I tried a few different combinations of things but I can't get the damn thing to work. The strange thing is that I have another report that I pulled from Zuckerreports (for SugarCRM) which is a master report containing 3 sub reports, and those seem to work fine. But, I can't for the life of me work out what's different between that set of reports and mine. BREAKING NEWS: I've got it!! It seems that the difference was that the other set of reports had a query; my sub-report didn't have a query defined. I simply added "select 1" as the Query Text for the master report and it works!! Excellent - it works! What a bizarre bug/feature... R.

Peter, Thanks, that did the trick. As you may have guessed, I'mve not worked with Java very much! :) R.

Ah, OK. That makes more sense. Outside the iReport environment, i.e. when I try and run the reports from SugarCRM, the parameters will be provided programmatically. That is, if I can resolve the many other problems I'm having (see my other recent posts!). Thanks, R.

I've created a report (let's call it "detail1") which takes a couple of parameters: "Start Date" and "End Date" This is one of three reports that I want to combine in a single master report. So, I've created a master report, also with two parameters: "Start Date" and "End Date". I've created a subreport object on the master report using the "detail1" report. I've joined up all the things I think need joining up: Parameters Map Expression: $P{REPORT_PARAMETERS_MAP} Connection/DataSource: $P{REPORT_CONNECTION} Subreport Expression: $P{SUBREPORT_DIR} + "detail1.jasper" Subreport Parameters: SUBREPORT_DIR = $P{SUBREPORT_DIR} Start Date = $P{Start Date} End Date = $P{End Date} When I run the master report, I get prompted for the two parameters but the detail report doesn't return any records? Any idea what's going wrong? Thanks, R.

OK, I grabbed iReports 3.0.0 rather than iReports-nb-3.1.0 and can see it is a much more fully-featured interface! However, the "Total" function doesn't seem to do what I need. I want a "count" of records in the report, i.e. the number of records in the associated query. I tried changing the "Sum" function to a "Count" function, but the result is still null. I'm trying to count the id field, which is a string type. If I try to change the count_id_1 field to java.lang.Integer I get an error: Cannot cast object 'foobar' with class 'java.lang.String' to class 'java.lang.Integer Any idea how I can make this work? R.

Oh, I see. How do I test them then?

Hmm, I don't have that. I'm using ireport-nb-3.1.0 for JasperReports 3.0.1. R.

Hmmm, I don't see a total function. Where should that be? R. (Thanks for the reply, BTW, sounds just like what I'm looking for)

Hi, I'd like to concatenate a couple of date parameter fields into a text field, e.g.: $P{Start Date}.toString() + ' - ' + $P{End Date}.asString() This works, but I'd like specify the format of the date. By default, I get something like this: Tue Sep 23 00:00:00 PDT 2008 - Tue Sep 30 00:00:00 PDT 2008 I'd like that to be: Tuesday Sep 23, 2008 - Tuesday Sep 30 2008 How can I format those dates before converting to a string? Thanks, R.

Hi, I have a couple of report parameters - start_date and end_date - which pop up as prompts. I'd like to set the default value that appears in the prompts so start_date is today - 7 days, and end_date is today. I tried setting the Default Value Expression of the parameter to "date() - 7" but this doesn't appear to have any effect. Is it possible to do what I want? Thanks, R.

Hi, I'm new to iReports. I'm using it to build some reports against a SugarCRM DB. I'm building a report that returns a list of activity in a define date range. It's simple enough, just a query with a couple of parameters. However, I can't work out how to add a count of all records above the detail band, e.g.: Initial Prospects Total Number: 123 Name: foo bar Name: john Doe Name: Hettie Cetera etc. Can anyone point me in the right direction? R.

I too don't mind buying documentation, but I was rather disappointed to find out that the self-styled "Definitive Guide to iReports" is anything but "definitive". It is poor. Also, it only covers iReports v2.0 - I'm currently using v3.0.1 I'm debating whether or not to ask for my money back. R.