Report hangs

[Motlatjo]

Hi

I have got a query that take 0:01:28 to execute in SSMS when i select data for a month, but in the SSRS report takes forever for a month.
Please help

Thanks

 

[SQLScholar]

Usually this is to do with formatting\grouping\charting\paging etc in reporting services. You need to give more information about what your doing in reporting services with the data.

----------------------------------------

http://www.fountain.me.uk

Be who you are and say what you feel, because those who mind don't matter and those who matter don't mind - Bernard Baruch

Computer Science is no more about computers than astronomy is about telescopes - EW Dijkstra
----------------------------------------