Joined: 10 Oct 2011
Online Status: Offline
Posts: 47
Topic: How to figure what Stored Procedures are used Posted: 20 Apr 2012 at 6:02am
I am using Crystal 10, through an ERP system called MAS500.
Crystal is integrated and runs through the ERP system. A financial report that runs fine through the ERP system, is desired to run outside of the ERP system in standalone Crystal.
I have looked at the Database Expert and there are over 4800 Stored Procedures to choose from in Crystal, outside the ERP system.
I have not figured out how to determine which procedures are being called by the ERP interface. I have been asking for the answer to that question from my client for a few days. I am not sure if the vendor has been contacted or not. I go through my client.
How can I determine which of the 4800 procedures are being used?
Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Posted: 23 Apr 2012 at 4:46am
if you are not using windows 7, you can try .rpt Inspector, it will tell you which stored procs are currently being used in a report.
I've heard that it doesn't work with Windows 7. I used the trial version a couple of years ago and it was great...just my company was going away from CR.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
