Crystal 2013 wont accept sp parameter

[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.

[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?

[Atronics]

I tried that, Scott. The problem is that the query does not run. See the attached error message.

[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.

[Atronics]

Thanks Scott. That gets me on my way.

[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.