I have a report that pulls info from a form and passes it to the stored procedure the report is based on. In the form I have a field where the users put in a month number. The sproc has an expression:
Field: Datepart(m,FullDateField)
Criteria: =@MonthValue
My problem is with the Input Parameters property in the report. It requires that I specify the datatype, but it doesn't accept any datatype I use for the month. I know it probably requires the datatype to match the datatype of the field in the table, but of course that doesn't work on an expression. Help?
Field: Datepart(m,FullDateField)
Criteria: =@MonthValue
My problem is with the Input Parameters property in the report. It requires that I specify the datatype, but it doesn't accept any datatype I use for the month. I know it probably requires the datatype to match the datatype of the field in the table, but of course that doesn't work on an expression. Help?