Not Sorting Calculated Measure

[TechAbhiVaray]

I have a peculiar issue where the report has a date prompt.
Ex: 09/30/2011 and i have specified a filter to display dates from the 1st day of the month to the date prompt.
Filter:
[Report Date] >= _first_of_month (?Report_Date?) and
[Report Date] <= (?Report_Date?)
The next step was to sort the data in the cross tab node member to display in ascending order.
The problem came in the calculated measure. I am using running-total in one of the measures and displaying it as column. It calculates the measure in a descending order, i.e Calculates it backwards from the date prompt.
Ex:
Measure: running-total(Amount)
Date prompt: 09/30/2011
The report will have the amount column calculated in the reverse order.

Can anyone suggest any solution to this?

 

[blom0344]

Running aggregates are computed by the Cognos server AFTER fetching the data from the database. This makes it imperative to ensure sorting is done within the query in the proper order. Check whether the query has an explicit order by and make sure to add the sorting in the query itself..

Ties Blom