Using Decimal data type with External List in SharePoint 2010 and InfoPath 2010 - InfoPath Dev
in

InfoPath Dev

Using Decimal data type with External List in SharePoint 2010 and InfoPath 2010

Last post 08-23-2011 12:07 AM by Diana. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next

  • 08-01-2011 03:29 PM

    • BamaEric
    • Not Ranked
      Male
    • Joined on 08-01-2011
    • Marietta, GA
    • Posts 1

    Using Decimal data type with External List in SharePoint 2010 and InfoPath 2010

    Reply Contact

    I have a BCS connection to a SQL Server database with an External Content Type (ECT). I created an External List in SharePoint 2010 using the ECT.  When using the External list as a data source in InfoPath 2010, none of the fields that are the Decimal data type fields show up in the list to choose from in the data connection.  All the other fields show up fine.  I would like to be able to use the Decimal fields in the InfoPath form to perform calculations and sum totals.

    Any ideas how to fix this?  Is this an InfoPath 2010 or SharePoint 2010 bug?
    Filed under: ,

  • 08-23-2011 12:07 AM In reply to

    • Diana
    • Not Ranked
    • Joined on 09-04-2008
    • Posts 5

    Re: Using Decimal data type with External List in SharePoint 2010 and InfoPath 2010

    Mark as Answer
    Reply Contact

    Hi

    I created External Content Type (ECT) with SharePoint Designer 2010. I created External List in our Site. This ECT I used in InfoPath 2010 (I created Data Conection ). After time, I added some filed in existing ECT. When I would like modify data conection for this ECT, I don't see this added  fields. Added Fields are Intiger data Type.

    Tnx! LP Diana
Page 1 of 1 (2 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.