[Complex Report Challenge]

The second portion could be done by creating another cross tab. You can create a subdataset and then use it for your second crosstab.

[Group Expression in iReport]

Yes, I normally do the concatenation in my query and then use that as my group expression.

[Dividing two variables in an expression]

Create a new textfield and set the Textfield Expression Class to java.lang.Double and paste the following in the textfield expression:

new Double($V{pm_disp_ct}.doubleValue() == 0 ? 0 :
($V{pm_fund_ct}.doubleValue()/$V{pm_disp_ct}.doubleValue()))

[Problems with iReport 3.0.0]

What do you mean by "and it doen't work"? I tried your jrxml by hard coding the query and it worked.

[Summary band information in the page header]

Yes, assuming that you created a variable to sum a field, you will just have to set the "Evaluation Time" property accordingly.

[Complex Report Challenge]

Here you go

[crosstab help]

You can go to the following post where I have provided step by step instructions to create a simple crosstab report.

http://jasperforge.org/plugins/espforum/view.php?group_id=83&forumid=101&topicid=52751&topid=52962

Hope this helps!

[Working with groups in a pie chart]

Unfortunately, I'm only familiar with the subdataset approach. Maybe someone else can help you.

[Data field in Static text]

Yes, you can reference multiple fields.

 

[Working with groups in a pie chart]

I would just create a subdataset and use that for the pie chart. Your subdataset will return only two columns for example

1. Age

2 Count_

Simply place the chart in the summary band and set the key exression to $F{Age} and value expression to ${Count_}

Hope this helps!

[Data field in Static text]

It's the other way around ... you need to use a text field and add static text to it. For example the textfield expression would be like:

"Dear"+$F{fieldname}

[Increase subreport height]

Your question is not really clear. Which band has your subreport? Have you tried changing the "position type" property to "float"?

[how to bold a few text in text feild]

Try something like this in your textfield expression.

"Final result is: <style isBold=\"true\" pdfFontName=\"Times-Bold\">"+$F{X}+"</style>"

Simply replace the X with your actual field name. Also check the "Is styled text" property on the "Font" tab.

Hope this helps!

["Detail" BAND HEIGHT -- AutoResize ?]

The reason why you see those spaces is due to the fact that you have literally increased the size of the fields. I would suggest decreasing the size of the field and using the Stretch with overflow and Float properties. I have modified your jrxml. Give this a try.

Hope this helps!

[SQL ORA-00933 SQL command not properly ended]

No, you shouldn't have to make any changes. Is it possible that you are not pointing to the correct database?

[how to display report elements in table format]

Right click on the fields that you want to include in the table then go to Properties > Border and select the desired format for the borders.

[Why does my report is being printed that way?]

It looks like your main report and subreport are overlapping. Try changing the position type of your subreport to float and see if that resolves your issue.

[simple chart]

Yes, I have seen it before. It started happening when I was messing with ireports settings. But this was only happening when I had my output format set to html. If I changed it to pdf the chart rendedred without any issues. The soultion was to uninstall ireports and do a clean install.

Hopefully, someone else has a better solution.

[Using more then one connections in one report]

A quick search releaved the following post.

http://jasperforge.org/plugins/espforum/view.php?group_id=83&forumid=101&topicid=33522

I haven't tried this myself but hopefully it will work.

[Subreports don't show the data]

Did you right click on the subreport object and create the parameters there?

Right click on the subreport > Properties > Subreport (Other) > Subreport parameters > Add

I normally set the default value of this parameter to be my main report's parameter.

Hope this helps!

[problem :pie chart (Key is null)]

The problem is that your query is returning a null for $F{OTA} and therefore you are getting this error message. You can modify your query to exclude nulls for this field and that will resolve the issue. The reason why you don't get any error message at compliation time is due to the fact that the issue is with the data and not the report.

Hope this helps!

[Group header when no detail]

I haven't tried this but its worth a try. On the group add/modify screen, you'll notice that there is a property called "Min height to start page". You can put the height of you group header and details section added together to see if that will make a difference.

Hope this helps

[how to set the vertical line height for a text box]

Right click on your textfield then go to

Properties > Font > Line Spacing and select your desire setting

Hope this helps

[Grand Totals in headers]

Yes, you can create a sum variable and when you place it in the header/title section just change the "evaluation time" to "auto".

Hope this helps

[Page identification question.]

1. Create a parameter;
<parameter name="LastPageFlag" isForPrompting="false" class="java.lang.Boolean">

<defaultValueExpression ><![CDATA[boolean.FALSE]]></defaultValueExpression>

</parameter>

2. Create a blank Text Field in the Summary band with expression;
($P{REPORT_PARAMETERS_MAP}.put("LastPageFlag",Boolean.TRUE)) and set Eval.Time to 'Report' and class to 'Boolean'.

Note: This MUST be in the Summary band, even if that band is not used (band height set to zero), it can be given a negative y offset but be aware that moving it subsequently via the iReport interface will change the band that it is associated with and this must then be reset to 'Summary'.

3. Add the continued message Text Field with Eval.Time set to 'Page' and class to 'String' and expression;
($P{REPORT_PARAMETERS_MAP}.get("LastPageFlag").equals(Boolean.TRUE))? null:"** Continued **"

4. If necessary (i.e. if the message differs or prints in different places on the fist and subsequent pages), make this instance print only on the first page and add another instance to print on all pages except the first.

Hope this helps!