Currently, our report are retrieving data from a database view, then make calculation in crystal report. However, it is difficult to maintain as we have some logic in view and also in report.
We want to modify the report. Use store procedure to do calculation and return the result set. Crystal report only get the result set from store procedure and do the formatting and grouping.
If the store procedure only contain SQL statement and return result set. It is easy to add into crystal report.
However, when the store procedure include a insert statment. When add to crystal report, it will have error. Something like the cursor is readonly.
So i'm not sure is it the limitation for using store procedure in crystal report.
Any experts can clarify this issue?