I've checked the Execution log, there most of the time it is taking for data retrieval only.
Report is fast in BIDS and its very slow in reportserver.
I'm checking in both the places one after the other, always BIDS is faster and reportserver is slower.
I tried changing to a stored procedure, its even more worse(taking almost double the time).
If it is resource issues, why it is taking long time in reportserver not in BIDS.
And i've almost 30,000,000 rows in the table.
Is there anything wrong with IIS?
No Dream Is Too Big....!