Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

InfoPath 2010 Form Not Displaying Decimal Fields

Posted on 2011-03-04
2
Medium Priority
?
1,147 Views
Last Modified: 2012-05-11
Hi,

I have a BCS External Content Type based on an Oracle connection via a .NET assembly.  I've used this to create an External List in SharePoint 2010.

When I try to display the fields in an InfoPath 2010 using the SharePoint External List as my data source, the fields can all be selected, except for the ones with the Decimal data field type.  They do not show up in the list to be able to be selected.

I know that I need to change the data type from decimal to something InfoPath can handle, but I don't have any ideas how to do that.  For those who might say, edit the schema, the schema does not show the fields of the decimal data type.

Any suggestions for this specific situation or advice where to make the datatype change?
0
Comment
Question by:wmholt
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 28

Accepted Solution

by:
clayfox earned 2000 total points
ID: 35056258
InfoPath can handle decimals but for whatever reason is not detecting them properly in this case.

You should go into your BCS setup and try changing the field type there. That is the best place, then refresh your list and data connection.
0
 

Author Closing Comment

by:wmholt
ID: 35075669
Thanks for the help!
0

Featured Post

How Blockchain Is Impacting Every Industry

Blockchain expert Alex Tapscott talks to Acronis VP Frank Jablonski about this revolutionary technology and how it's making inroads into other industries and facets of everyday life.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
In case you ever have to remove a faulty web part from a page , add the following to the end of the page url ?contents=1
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

688 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question