Crosstab Sorting using script

Hi all, 
 
In my report I?m sorting crosstab depending on user parameter by using de api. In report designer I can do this easily by using sorting tab on crosstab. This is what I get when defining sorting this way: 
 
<property name="sort"> 
<sort-element> 
<expression name="key" type="javascript">data["situation_count_SituationGrp/situation_name_DateGrp/date"]</expression> 
<property name="direction">desc</property> 
<property name="strength">-1</property> 
<property name="member"> 
<member-value> 
<property name="value">26.08.2010</property> 
<property name="level">DateGrp/date</property> 
</member-value> 
</property> 
</sort-element> 
</property> 
 
I can get all the properties in script to do sorting using de-api except those which are member-value tag. Does anybody know how to set them programatically? 
 
Thanks in advance 
 
Regards Rainer

Find more posts tagged with

Comments

Rainer

ok, got it.

at the end it was very simple to find a solution which fits my report. For now this is quick and dirty but it shows how to do it.

newValue = "xxxxx";

reportContext.getDesignHandle().findElement("NewLevel View1")
.getProperty("sort")
.get(0) // a bit tricky, you get an ArrayList here
.getMember().setValue(newValue);

Regards Rainer

mwilliams

Thanks for the update! Glad you found a solution!