September 28, 2010 at 3:58 pm
Hi,
I have created a report in Report builder and ran it. It takes more than 30 min to run.
From the SQL profiler I got the query that is generated by the Report builder for the same report that I created. It ran in 6 minutes.
Could anyone please suggest what might be the reason?
Thanks and Regards,
Praveena
September 29, 2010 at 2:27 pm
Are you using a stored procedure?
September 29, 2010 at 2:38 pm
My reports are based on a model which is autogenerated based on the dsv. I haven't used any sps for the report.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy