Can we take String and real both data in one field and show it in SSRS for two decimal and total ?

Finance and Operations/AX Developer Forum
1

Hi All,

We are uploading data through Excel in which we have one field called “Amount”. In this field holds different type of value for Example : - there are some lines has real value like “1023.00”, “1897.9098”, “87554.78” and some values are string like “Included” , “Inserted” , “Added”.

Now i have to take these value in SSRS report and same value should appear as it’s getting upload.

Now the problem is that

  1. we want 2 decimals value for Real value. if value has more digit after decimal it’s taking same value.
  2. if i am taking Number type field in SSRS all string values are gone.
  3. Total also not coming at last if the field is string.

How can we achieve this solution.

2

There is already a discussion in your duplicate thread on another forum, so I suggest we shouldn’t duplicate it here.