Dear all,

I wonder whether anyone may be able to give some advice here.

I have set up a report as follows:

The months in the 'Key month' drop-down object is a timerange driven from the year box and the months in the column header are the values of the 'Key Month' drop down. I then want to sort the table based on the Key Month selection - e.g. if Jul is selected the table values should be sorted based on the values in the Jul Column.

I then add a 'sort' link as follows:

But the result is then as follows:

As you can see, it actually restricts the values to Jul (hides other months) and certainly does not perform a sort.

I then had a look at the SQL statement:

SELECT SUM(T00.`Amount`), T00.`DETAIL` FROM `RawData` T00 WHERE T00.`PAYMENT DATE` BETWEEN {d '2010-07-01'} AND {d '2010-07-31'} AND T00.`DETAIL` IN ('Advertising Recharge', 'Barstocks (Spirits Etc)', 'Bin Collection', 'Book Of Remembrance Costs', 'Clinical & Medical Waste', 'Communications', 'Computer Hardware Maintenance', 'Computer Software Maintenance', 'Contracted Services', 'Country Grounds', 'Credit Card Recharge', 'Dayworks/Miscellaneous', 'Decoration', 'Derv.', 'Disposal Cost Architect', 'Donations', 'Electricity Direct Invoices', 'Entertainment Percentage Shows', 'Equipment') AND T00.`PAYMENT DATE` BETWEEN {d '2010-01-01'} AND {d '2010-01-31'} GROUP BY T00.`DETAIL` ORDER BY 2 ASC

and it is clear that it is adding a 'Jul' filter for each month.

What am I doing wrong here....?

Regards