What sort of datasource connection are you using? TERADATA or odbc?

With ODBC you can just use a single question mark in place of parameters in the query.

I've not connected to TERADATA before but I know different databases use different syntax. For example Oracle uses

:parameter

it might be something like that

?parameter

SSRS might try to create this in the query

@parameter

and then the datasource would not recognise that as a parameter at all. It would think you've defined a parameter in the dataset properties, yet not provided one to the data-connector hence the error message about a mismatch of number of parameters.