April 21, 2016 at 7:39 am
I have a straight table with lots of columns.
I've created a report and it has the following in the data set
WHERE (Year = @Year)
AND (ID = ID)
AND (Area = 'Most Recent') --The Area is always most recent
AND (Cohort = 'All') --The cohort is always all. As in all the data
And I've deployed it to the Reports server. There is 4343 records. Its basically so slow its not running at all.
I've had a look at the parameter sniffing documentation but its all about dealing with Stored Procedures. Not a table.
It takes a second to run in SQL so I'm guessing its rendering issues. It runs fine with just 4 data items but I need a lot more data items in the data set.
Has anyone got any ideas on what to do about this problem?
BTW I'm running R008R2 and running it on Internet Explorer 11
Debbie
April 21, 2016 at 9:50 am
I have set all the reports to an interactive size of 0 which means that as you are looking at them in the browser they are as big as they need to be
With the big question with lots of columns it just can’t handle rendering that much data,
So I have set the interactive size back to 21cm, 29.7cm
Which means that instead of it being on 1 page it spans multiple pages. I've then sent to a csv format and it all goes into one csv file.
So fingers crossed that’s going to help a lot for anything that could end up sizeable
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply