Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Crystal crashes when add new parameters to a stored proc in a subreport

This one has been driving me nuts so any help much appreciated...

I have a stored procedure (Oracle 9i) that is used as the datasource for a subreport (needs to be in the subreport as I need to pass multi-value parameters to the proc - something I've done in numerous other procs/reports). All of the parameters from the proc are linked to data/parameters on the main report.

The report works fine at the moment.

I need to add three new parameters to the proc with an If statement on each one to run various bits of code depending on what is passed in. This is where the trouble starts.

The proc works.

If I create a main report based on the new proc, it works.

If I create a subreport based on the proc and DON'T link it to the main report, it works.

If I create a subreport based on the proc and DO link it to the main report, Crystal crashes with no explanation (just that painful error that apologies for the inconvenience). It is not all the parameters that cause this problem - it's not even restricted to just the new parameters or even just to ones that are used in the IF statements.

This is not the first proc to do this to me - just the first one where the new functionality was too critical to strip out for now.

I have been trawling the net and trying all sorts of things for days so I am hoping someone out there has a suggestion!

Versions: Oracle 9i, Crystal Reports

Former Member
Not what you were looking for? View more on this topic or Ask a question