Hiya

The report is calling a stored procedure so speed wise it should be ok, I'm wondering whether it's just the amount of data it's trying to retreive as it's...

I've managed to fix it by using the following sort fx within the row group:

=Sum(IIf(MonthName = ParametersMonth, Views, 0))

Hi Scott

Thank you for your reply, unfortunately it won't sort by month as within the dataset itself month 4 and 5 are under one column (so it doesn't sort...

Forgive me if this is a simple problem to solve, I am having the same issue, please can you tell me how to change so the data into an integer?...

It appears I may have found a solution by using option(recompile) at the end of my procedure 🙂 I'm not entirely sure why this works but it does so I...