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 !!