question

I have a simple, one-table report in SSRS 2005 (**EDIT this originally said SSRS 2205, hence the ribbing below**) with 2 basic requirements, and I can do both separately, but combining them I get into a whole heap of bother..... The report is listing all the payments made for the given dates, these are passed as params to a proc, and that returns payment date, payment type, amount, blah, blah, ... First up I have a filter on payment type (credit card, amex, debit card etc). This is implemented as a multi-value parameter and applied to the detail row of the table (although it forces me to create a grouping first - don't quite get that but hey-ho). So using this I can select all or some of the payment types, and the data is magically filtered! Second, the user asked for sorting capabilities (coincidentally on the payment type column), so I thought 'Aha! Interactive Sorting!'. Right-clicked the 'Payment Type' column header, choose the 'Interactive Sort', specify the expression as the data field. All happy. Run the report, and I get the up/down arrows on the column header, but alas they do nothing! If I remove the filter (and grouping), then the sort works fine, but together something is treading on something else's toes, and they're not playing happy..... Anybody had similar experiences? [I find a lot of this in SSRS, there seems to be easy ways to do things, but when they don't quite work, you've got no idea why.......] Also whilst I'm here, why do I have to put the filter on the detail row (and subsequently create a grouping) when there is a filter tab on the table properties, but that seemed to fail me too :(