Dear experts, I got an issue with preview, i made a view that pulls more than 10 000 rows, depends on date intervals that coming parameters and item_name that comes from multiple value parameter. When i put date interval examle 1/1/2008 and today it's pretty ok (Page number are nearby 16). But when i put 1/1/2006 and today, VS through an error and tries to restart. In query builder it's pretty faster and works good. Any idea? Help is really appreciated batkaval

do you get the data when you run query for that data range (between today and 1/1/2006)? if yes then try to increase the execution time on Server?SSRSRpt

In query builder i got data (between today and 1/1/2006), while previewing in gives an error. how to increase execution time on server? Thanks batkaval