Crystal 2013 wont accept sp parameter

Support for Crystal Reports within Jiwa.

Crystal 2013 wont accept sp parameter

Postby Atronics » Thu Mar 23, 2017 3:24 pm

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.
Attachments
Plugin HAB - Custom Fields combined.xml
(99.15 KiB) Downloaded 412 times
HAB Purchase Order V7b.rpt
(26.5 KiB) Downloaded 413 times
usp_HAB_PurchaseOrders.sql
(61.44 KiB) Downloaded 410 times
Atronics
Frequent Contributor
Frequent Contributor
 
Posts: 119
Joined: Fri Feb 29, 2008 4:40 pm
Topics Solved: 10

Re: Crystal 2013 wont accept sp parameter

Postby Scott.Pearce » Thu Mar 23, 2017 3:42 pm

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?
Scott Pearce
Senior Analyst/Programmer
Jiwa Financials
User avatar
Scott.Pearce
Senpai
Senpai
 
Posts: 742
Joined: Tue Feb 12, 2008 11:27 am
Location: New South Wales, Australia
Topics Solved: 221

Re: Crystal 2013 wont accept sp parameter

Postby Atronics » Thu Mar 23, 2017 4:49 pm

I tried that, Scott. The problem is that the query does not run. See the attached error message.
Attachments
Capture.JPG
Capture.JPG (26.15 KiB) Viewed 8781 times
Atronics
Frequent Contributor
Frequent Contributor
 
Posts: 119
Joined: Fri Feb 29, 2008 4:40 pm
Topics Solved: 10

Re: Crystal 2013 wont accept sp parameter

Postby Scott.Pearce » Thu Mar 23, 2017 4:59 pm

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.
Scott Pearce
Senior Analyst/Programmer
Jiwa Financials
User avatar
Scott.Pearce
Senpai
Senpai
 
Posts: 742
Joined: Tue Feb 12, 2008 11:27 am
Location: New South Wales, Australia
Topics Solved: 221

Re: Crystal 2013 wont accept sp parameter

Postby Atronics » Sat Mar 25, 2017 1:10 pm

Thanks Scott. That gets me on my way.
Atronics
Frequent Contributor
Frequent Contributor
 
Posts: 119
Joined: Fri Feb 29, 2008 4:40 pm
Topics Solved: 10

Re: Crystal 2013 wont accept sp parameter

Postby Atronics » Thu Sep 28, 2017 11:26 am

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.
Atronics
Frequent Contributor
Frequent Contributor
 
Posts: 119
Joined: Fri Feb 29, 2008 4:40 pm
Topics Solved: 10


Return to Crystal Reports

Who is online

Users browsing this forum: No registered users and 2 guests

cron