JiwaRanges Lookup - Stored procedure
Posted: Mon Sep 11, 2023 4:50 pmHi 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
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