I have a report which I am trying to run in my development environment which fails with a "401 unathorized" error message. the report is a tablix report, and fails after 31 records (irrespective of data set). I cannot understand why this is happening,, I have tried recreating the report, restarting the report server, confirming that the data source is correct.
I came up with the 31 records after placing a TOP clause in my stored proc to restrict records after i found a dataset with 7 records was fine, but 100 records was not.
the tablix is pivoting the information the stored proc returns.
What is more strange is that the report runs fine in production for any dataset.
Any help or suggestions are very much appreciated