troubleshooting Question

InfoPath 2010 Form Not Displaying Decimal Fields

Avatar of wmholt
wmholt asked on
Microsoft SharePointMicrosoft SQL Server 2008InfoPath
2 Comments1 Solution1225 ViewsLast Modified:
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?
ASKER CERTIFIED SOLUTION
Clay Fox
Director of Business Integration

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros