I'm trying to write a report from pulling data from several sources and have managed to write a query that gets me towards what I need.
However, when I tried to convert this into a stored procedure
the execution time rocketed from 0-2 secs to 3-4 mins!
I've narrowed this down to the effect of...
I've been having an intermittent problem where backups scheduled in SQL Server Agent are failing with no apparent errors - they appear in in SQL Server Agent as executing until I cancel them manually - the job history shows that they have been running for the whole time (hours and hours!)
Any ideas?
The report designer reports are on :- R3V6AT.J and R3v6A1.G (I've copied between these to two fine. They both have the report designer option.)
The CMS i'm attempting to copy them on to is:- R3v9??.? (Can't get the full version at the moment)
I've got some reports created in Report Designer which I need to use on another CMS. The other CMS does not have the report Designer option, but does have Custom Reports. Is ther any way I can transfer the reports?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.