Decimal Parameters losing decimal points

1 posts, 0 answers
  1. Nadun
    Nadun avatar
    1 posts
    Member since:
    Sep 2018

    Posted 26 Sep 2018 Link to this post

         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 ?

Back to Top