I have a sql datasource. The query creates variables such as ( declare @LastYearVal Decimal(28,12) ), and a calculated result is assigned to this variable for further processing later in the query.
When configuring the sql datasource, the parameter @LastYearVal is automatically picked up by the wizard, and I can select the type as "decimal".
Doing so will set @LastYearVal to be Decimal(29,0) at the report run time. (This i could see through the sql profiler)
Due to the variable being Decimal(29,0) instead of Decimal(28,12), it loses decimal points of the calculated result that is getting assigned to it.
Is there a way to configure the sql datasource, so that it sets the above parameter as Decimal(28,12) and can retain the decimal points correctly ?