Solved

InfoPath 2010 Form Not Displaying Decimal Fields

Posted on 2011-03-04
2
1,140 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 500 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

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

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

Before you can digitally sign infopath forms, you must have a digital certificate. Microsoft Certificate Services will need to be enabled on a Windows Server 2008 to facilitate the creation and verification of the digital certifciates on the web ser…
In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …

623 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