I then use @YearDropDown in the following SQL statement in a DataSource.
Code: Select all
SELECT
LD.Description,
ST.StartDate,
ST.EndDate
FROM
SchoolTerms ST
LEFT JOIN
LookupDetails LD ON ST.Name = LD.LookupDetailsID AND LD.LookupID = '2200'
WHERE
ST.SchoolYear = @YearDropDown
ORDER BY
ST.Name DESC
The parameterized query '(@YearDropDown int)SELECT
LD.Description,
ST.StartDate,
ST' expects the parameter '@YearDropDown', which was not supplied.
Any help or being pointed in the right direction would be great.
I read the documentation in the following link https://www.stimulsoft.com/en/documenta ... meters.htm