Creating reports and dashboards | Stimulsoft community forum

Posted: **Fri Mar 04, 2011 3:52 pm**

So, in another thread, I copied the code I'm using to convert my query result data into a Stimulsoft compatible dataTable.

Unfortunately, once I get all the way into the designer, it thinks all my columns are type "String".

Here's a copy of the exported dictionary that shows what stimulsoft is working with, followed by some trace output from my conversion function, which shows the expected outcomes.

Code: Select all


  
  
    
      QOrdersList
      
        Contactid,System.String
        ConvFee,System.String
        ConvFeeTotal,System.String
        Fname,System.String
        HANDLINGCOST,System.String
        HandlingTotal,System.String
        Lname,System.String
        ORDERID,System.String
        REFUND_AMOUNT_Total,System.String
        SELSHIPCOST,System.String
        SSystemOrigination,System.String
        ShippingTotal,System.String
        SubTotal,System.String
        THEDATE,System.String
        TaxTotal,System.String
      
      
      QOrdersList
      Data

Code: Select all

Building Column for Contactid:int
 StorageType.IntType
Building Column for ConvFee:Number
 StorageType.DecimalType
Building Column for ConvFeeTotal:Number
 StorageType.DecimalType
Building Column for Fname:String
 StorageType.StringType
Building Column for HANDLINGCOST:int
 StorageType.IntType
Building Column for HandlingTotal:int
 StorageType.IntType
Building Column for Lname:String
 StorageType.StringType
Building Column for ORDERID:int
 StorageType.IntType
Building Column for REFUND_AMOUNT_Total:int
 StorageType.IntType
Building Column for SELSHIPCOST:int
 StorageType.IntType
Building Column for SSystemOrigination:String
 StorageType.StringType
Building Column for ShippingTotal:int
 StorageType.IntType
Building Column for SubTotal:Number
 StorageType.DecimalType
Building Column for THEDATE:Date
 StorageType.DateTimeType
Building Column for TaxTotal:int
 StorageType.IntType

What do I need to do, in order to get these types behaving? Have a missed a step in building out my dataTable, or is this a bug in the software?

Thanks so much!

Posted: **Sat Mar 05, 2011 2:01 am**

Hello,

We have fixed this error, the update will be available in prerelease build on March 9.

Thank you.

Creating reports and dashboards | Stimulsoft community forum

DataTable and column types

DataTable and column types

DataTable and column types