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

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

    XMLWordPrintable

    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: