This is a migrated thread and some comments may be shown as answers.

Decimal Parameters losing decimal points

0 Answers 59 Views
Report Designer (standalone)
This is a migrated thread and some comments may be shown as answers.
Nadun
Top achievements
Rank 1
Nadun asked on 27 Sep 2018, 02:08 AM

     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 ?

No answers yet. Maybe you can help?

Tags
Report Designer (standalone)
Asked by
Nadun
Top achievements
Rank 1
Share this question
or