Problem when running a report

[backhandx]

Hi all,

I have a problem in a simple report. Actually, when I excute the report in report studio it takes a long time ( more than 3 hours :o)  to be executed. But when I excute the generated sql in the database, it runs if few seconds.

I want to know why this is happening?

Thanks in advance

PS: the report contains one requery with filters.

[New_Guy]

Hi,
How many rows is the report output and which format are you running? Try to take of some columns and see if there is any improvement, if you haven't tried that yet. Are you getting the whole result set when you run the sql in the database?
Below is the link to a similar discussion

http://www.cognoise.com/index.php/topic,24363.0.html

Good luck
New Guy.