Crystal Reports and Stored Procedures- Exception or the RULE?
Posted on 2006-03-23
Just had an interesting discussion regarding Crystal Reports and the use of MS SQL Server 2000 - "STORED PROCEDURES."
This particular business that I was talking to has Crystal Reports v10, but almost EXCLUSIVELY uses Stored Procedures to produce/process ALL of their reporting. I don't know anything about their DATABASE structure. All I know is that they are on CR v10 and SQL Svr 2000 DB's.
Question: Is the use of STORED PROCEDURES the exception or the rule? What are Pros and Cons?
I use STORED PROCEDURES on a very limited basis, because in my opinion, CR XI (currect version I develope on) can handle 99% of my reporting requests. I think we have a very complex set of DB's and do not yet see the need to get heavy into creating or maintaining Stored Procedures in order to process or manipulate my data for reports? Can you give me some insight on the purpose behind Stored Procedures and why a business would opt to be heavily into them while using Crystal Reports as their sole reporting enterprise package?
Thank you for your insight?