Report going into loading in parameter rendering time

Hello all,

I have a report which is a click through matrix and have 10 paramters

--Here, User ID is passing internally using URL which is a ID of Login User (hidden for end user)

--Report type has two option Pending Summary Report And Completed ....

--here handling persons are calculated in a separate store procedure on the basis of Report Type And USer ID parameters (Handling Persons are mapped to USER ID into db)

-- Department is coming from the Handling persons selection 

Now, the parameters are not my problem because most of are loads on cascading on the base parameters (department )

-- parameters stage and scheme are depend on the department parameter

so , not issue on loading any parameters in designer the parameters selection works smooth in BIDS but when i deploy report on server 

and select department for the first time it stucked in loading for a minutes and after first full run the parameters loads smothly as in BIDS ..

I don't understand why is it taking so much time to load it first time ..

Any help ... must appreciated !!

July 25th, 2015 1:29am

Is Bids and report server connected to same data source ? If yes then please post your query and your the exectuion plan for it.If they are targeted to  different datasource may be it has more volume of  data than your dev environment and your query might be inefficient.

Also Is the database to which you are connecting is on the same server  where the report server reside.

Free Windows Admin Tool Kit Click here and download it now
July 25th, 2015 2:25am

Thanks Milan Das,

The data sources are same and 

the report server database and application database are on different servers ..

is it affects reports performance if both reports and application are not on same servers??

how to measure that?


July 25th, 2015 2:33am

Can your run sql profiler on the datasource database.And check the execution time 
Free Windows Admin Tool Kit Click here and download it now
July 25th, 2015 3:10am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics