Link to home
Start Free TrialLog in
Avatar of sarmad811pk
sarmad811pkFlag for Pakistan

asked on

SSRS report query DECLARE CURSOR error

Hi
I am a .Net developer working with MSCRM. I have to develop some reports for my client which requires a lot of calculations on data base like retrieving data from multiple tables, manipulating each record (i used cursor), placing in temp tables and etc. For required out i just created a stored procedure and gets the required ouot put from DB.

But problems is that MSCRM does not allowed to modify its DB (creating SP or views). And TSQL of the SP giving me error whin i place it in SSRS dataset query window.
"The Declare cursor SQL construct or statement is not supported."

Now i am struked how to proceed with reports.
I even tried to run query by placing it in a string and calling ECEX method to execute query in SSRS dataset query window, it still giving me error with biger queries but runs fine with small small query.

Please guide me its urgent.

Thanks in advanced.

ASKER CERTIFIED SOLUTION
Avatar of Chris McGuigan
Chris McGuigan
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial