Crosstab Report Formatting

[ckpkhill]

I have Cross Tab report that requires rows to be formatted as Currency($), Integer(counts) and Percentage(%) based on column rows of the crosstab. 

How can I make that happen.

I don't have a xml or Java experience.

[cstallins]

In the JasperReports Server v5.6 Ad Hoc editor, to add a currency symbol to column values, right-click on the header of the column, mouse over Change Data Format, and select a format.

To calculate counts for a measure, at the right end of the Measures panel header, mouse over the small selector icon and select Create Calculated Measure. The New Calculated Measure window appears.

In the Functions pane near the center of the window, scroll to find the appropriate Count function (there are three) and double-click to add it to the Formula pane above. The Function Description pane near the lower right displays text that explains how to configure the function.

At the top of the window, provide an appropriate name in the Measure Name field. Click the Validate button near the bottom left to determine if your function is configured properly. Click the Create Measure button at the lower left to save your new calculated field to the Fields or Measures panel, from which you can double-click to add it to your Ad Hoc view.

Repeat to create a percentages column, this time using the PercentOf function.

See chapter 4.6 in the JasperReports Server User Guide for detailed info on all of the calculated field functions.
The guide is available free at http://community.jaspersoft.com/documentation?version=10870