Page 1 of 1
Crystal 2013 wont accept sp parameter
Posted:
Thu Mar 23, 2017 3:24 pmby Atronics
We have a Purchase Order form that uses some custom fields and PO note types and uses a stored procedure to collect the data. the sp delivers the information correctly when run in SQL. However, the report crashes in Jiwa 7.175. with an error message saying Crystal is unable to find a field.
Re: Crystal 2013 wont accept sp parameter
Posted:
Thu Mar 23, 2017 3:42 pmby Scott.Pearce
Have you run a SQL Server Profiler trace to capture the SQL fired by the report when it errors - and then run this exact SQL in Management Studio without error?
Re: Crystal 2013 wont accept sp parameter
Posted:
Thu Mar 23, 2017 4:49 pmby Atronics
I tried that, Scott. The problem is that the query does not run. See the attached error message.
Re: Crystal 2013 wont accept sp parameter
Posted:
Thu Mar 23, 2017 4:59 pmby Scott.Pearce
OK. Try linking PO_Main into the report. I realise that you are using a stored procedure, but you should still be able to add PO_Main to the report, and link it in Crystal to the stored procedure via OrderID.
Re: Crystal 2013 wont accept sp parameter
Posted:
Sat Mar 25, 2017 1:10 pmby Atronics
Thanks Scott. That gets me on my way.
Re: Crystal 2013 wont accept sp parameter
Posted:
Thu Sep 28, 2017 11:26 amby Atronics
Hi Scott,
I have resurrected this report again. Including PO_Main in the report fixes one issue. However, when running the report in Jiwa, no parameter is sent with the sp. Running a trace confirms this. I have checked the names of the sp parameters in both the sp and crystal, but am at a standstill in solving this.