sorting on summary field by clicking on the column of cross tab

nppk

I am using a crosstab for displaying the number of products ordered per customers, per product.

My rows are showing the customers, columns the products and as summary i am displaying the quantity.
On clicking the product1(header), I need to sort the table based on the quantity of product1.

For eg :

cust | prd1 | prd2| prd3

---

cust1 | 2 | 0 | 1
cust2 | 1 | 4 | 3
cust3 | 3 | 2 | 1
cust4 | 1 | 2 | 4

so on clicking prd1 the result should be :

cust | prd1 | prd2| prd3

cust2 1 4 3
cust4 1 2 4
cust1 2 0 1
cust3 3 2 1

clicking again on prd1 should result in :

cust | prd1 | prd2| prd3

cust3 3 2 1
cust1 2 0 1
cust2 1 4 3
cust4 1 2 4

clicking on prd2 should result in

cust | prd1 | prd2| prd3

cust1 2 0 1
cust3 3 2 1
cust4 1 2 4
cust2 1 4 3

Could you please suggest how to implement this.
Please find the attached sample report with the post.

Thanks in advance for the help

kclark

nppk, take a look at the report I've attached. You'll need to use hidden parameters and a little bit of scripting to do this. When the link is clicked it opens the report again passing the value of what the crosstab needs to be sorted by. It also checks if the current sort direction is ascending or descending, then passes the opposite to the report parameter using the following<br />
<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>if(params["SortDirection"].value=="Ascending") {
"Descending"
} else {
"Ascending"
}</pre>
<br />
The actual sorting is done in the beforeFactory()<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>
importPackage(Packages.org.eclipse.birt.report.item.crosstab.core.de);
importPackage( Packages.org.eclipse.birt.report.model.api );
importPackage( Packages.org.eclipse.birt.report.item.crosstab.core.util);
importPackage( Packages.org.eclipse.birt.report.item.crosstab.core);
importPackage( Packages.org.eclipse.birt.report.model.api.elements);

var eF = reportContext.getDesignHandle().getElementFactory();
var srt = eF.newSortElement();

if( params["SortOn"].value == "Amount" ){
srt.setKey("data[\"QUANTITYORDERED_Group/PRODUCTCODE\"]");
}else{
srt.setKey("data[\"PRICEEACH_Group/PRODUCTCODE\"]");
}
if( params["SortDirection"].value == "Ascending" ){
srt.setDirection(DesignChoiceConstants.SORT_DIRECTION_ASC);
}else{
srt.setDirection(DesignChoiceConstants.SORT_DIRECTION_DESC);
}
var xtab = reportContext.getDesignHandle().findElement("mycrosstab");
var xtabhandle = xtab.getReportItem();

var rws = xtabhandle.getCrosstabView(ICrosstabConstants.ROW_AXIS_TYPE);
var lvh = rws.getDimension("Group").getLevel(0);

lvh.getModelHandle( ).add( ILevelViewConstants.SORT_PROP, srt );</pre>
<br />
Let me know if you have any questions