JiwaRanges Lookup - Stored procedure

Support for Crystal Reports within Jiwa.

JiwaRanges Lookup - Stored procedure

Postby Riyaz » Mon Sep 11, 2023 4:50 pm

Hi There

We need to have a parameter values passed to a report, where the parameter range values are obtained using a custom stored procedure. Using the below at the moment which shows the parameter in the report and also fills the default value correctly, but when we try to do a lookup , it comes up with the attached error, can you pls advise

//TYPE = STRING
//CAPTION = Select Category
//SEARCH = YES
//SELECT = Exec SP_IN_Category5Emails
//KEYFIELD = EmailTo
//DEFAULT = Exec SP_IN_Category5Emails
Attachments
2023-09-11 15_49_38-t140 - Remote Desktop Connection.png
Riyaz
Kohai
Kohai
 
Posts: 233
Joined: Wed Dec 02, 2015 2:05 pm
Topics Solved: 2

Re: JiwaRanges Lookup - Stored procedure

Postby Scott.Pearce » Thu Sep 14, 2023 1:00 pm

Only SELECT statements can be used with the "SELECT =" keyword.
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


Return to Crystal Reports

Who is online

Users browsing this forum: No registered users and 5 guests