Grouping in SUBDATASET

[chetan_33]

for jasper1.2.5 and iReport1.2.5

While defining Sub datasets through iREPORT

we get to see Group & Properties button besides the field, parameter and variable buttons

Does anyone know what this group is for and hwo it is to be used.

I was not able to figure it the cross tab samples of jasper

[lucianc]

Subdatasets are able to group the rows coming from their data source into groups and compute totals per group.

 

Subdatasets can be used both for crosstabs and for charts. Defining a group in a subdataset makes more sense for charts, as crosstabs can perform bucketing/summing on its own.

 

Also note that in some cases (e.g. SQL query result data sources) you can perform the grouping and summing in the data source of the subdataset, while in other cases (e.g. CSV or bean data sources), you can't (you need to write custom data sources to group and sum the data).

 

You can see a chart using a subdataset in demo/samples/charts/SubDatasetChartReport.jrxml

 

HTH,

Lucian

[chetan_33]

Can you please point me to a sample of groups within SUBDATASET for a crosstab

I am trying to build up a cross tab report in which context it can be of help.

[lucianc]

Unfortunately, there is no such sample. But it is the same principle as for charts, so by looking at the chart sample you can easily adapt it for a crosstab.

 

And again, using subdatasets with groups for crosstabs is not very common since you can do all the grouping and summing inside the crosstab itself. Why do you think you need subdataset groups for your crosstab?

[chetan_33]

My reason for looking at it is because of following requirements

 

http://www.jasperforge.org/index.php?option=com_joomlaboard&Itemid=215&func=view&id=311&catid=8

 

If you can answer that please

thanks for your interest