Uploaded image for project: 'Reporting Module'
  1. Reporting Module
  2. REPORT-331

Numeric data is treated as Text when exported to an Excel template

    Details

    • Complexity:
      Undetermined

      Description

      When creating a report where the underlying DataSet is a SqlDataSet, and one of the columns is a numeric column, specifically:

       
          case 
              when o.value_coded in (6539, 6540, 6682) then 0
              when o.value_coded = 6538 then 50
          end as PaymentCost
      

      When this value is exported to an Excel Template, it is treated as Text, rather than as a Number.

        Attachments

          Activity

            People

            • Assignee:
              mseaton Mike Seaton
              Reporter:
              ball Ellen Ball
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: