Trying to create drop down of parameter values from stored procedure

[JasGrand]

Hello, I'm having a little trouble creating a drop down list of parameters for the user to select when loading the report. The report's data source is a stored procedure. Here is the steps i have done:

1) Entered name of parameter
2) Type = String
3) List of Values = Static
4) Value Field = Employee_Name (from stored procedure)
5) Description Field = Employee-Name (from stored procedure)
7) Selected "Actions"
8) Selected "Append all data"
9) Entered database login/password

The below error shows up:

The table 'XNI_SUD_HRPY_ARCHIVE.dbo.stpGetEmployeeDeductionLedgerInfo;1' could not be found. Error in File UNKNOWN.RPT: The table could not be found. (rptcontrollers.dll)


Does anyone know what i'm doing wrong?

Thanks,


Jason

 

[Madawc]

Probably Crystal won't allow this sort of thing in a Stored Procedure. It helps to give your Crystal version - 8, 8.5, 9, 10, 11 or whatever. Methods sometimes change between versions, and higher versions have extra options.

The best option I can think of would be to have the 'drop-down' in the main report and then feed it as a parameter to a subreport that contains the stored procedure. No idea if this would work, I've never done anything like it. But no one else has answered so this may be the best way forward.

Madawc Williams (East Anglia, UK). Using Crystal 10 & 11.5 with Windows XP

 

[Turkbear]

Hi,
Does your report access that SP correctly?
Does the SP require a parameter?




To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[JasGrand]

Hello, the issue was that the stored procedure changed... stupid mistake... haha.

Thanks though.


Jason