June 26, 2015 at 8:22 am
hi
say i have a report with 3 pages, each page has a different dataset and takes some processing time.
is it possible to give the user the option to just run the first page say if thats all they need?
reduce the processing time of the report to only that that is neccessary?
Thanks
June 26, 2015 at 8:40 am
erics44 (6/26/2015)
hisay i have a report with 3 pages, each page has a different dataset and takes some processing time.
is it possible to give the user the option to just run the first page say if thats all they need?
reduce the processing time of the report to only that that is neccessary?
Thanks
Unless something has changed, there's no way that I know of to stop the processing time. While you could make those pages Visibility setting conditional on the value of a parameter, that isn't going to stop them from being processed. However, if you then combine that with having the parameter be handled within each dataset's stored procedure or query, such that it quickly returns zero records, that could possibly speed things up.
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
June 26, 2015 at 8:49 am
Not sure it will work with reporting services,
However you could try using the hint OPTION FAST(n) n being the number of rows.
It will return the first n number of rows to the screen/application whilst the rest of the query is processing.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply