Filtering and sorting in SSRS report not working together
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 :(
Damn you are picky! ;) Is there a scope for the column sort? If so then that might need expanding to cover the whole report dataset. I dont use interactive sort much so cant talk from experience I'm afraid. PS, is this an early access version of SSRS? - 2205 ?? - you must know the right people!
Re: [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.......] Yep - I'm finding much the same. It seems they'd rather you sat there scratching your head for hours instead of admitting: "Sorry guys, we haven't got that bit working properly yet." Or maybe they haven't noticed. The good news is it seems most of the problems are in BIDS rather than the Report Server. Mind you - I can't get a group sort to work interactively and can't tell what's at fault in that case.