Decimal Places in a column in a Dataview...

Hopefully a simple an easy question for the group to help me

I have gone through and created a new IDO getting data from an SP. My intent is to display this information in a Dataview. I created the Dataview, but the columns I have with decimal places are limited to 2. That doesn't work when users will want to extract that data into Excel for pricing and costing of an item. The SQL Table has 8 decimal places and returns this correctly in SSMS and SSRS reports. The Dataview only shows 2. I can not find anywhere in setting up a Dataview to change the column to display a certain number of decimal places.

Since I was thinking that has to be an easy thing, I asked Infor. They suggested I change the regional settings on my PC --> Great - now every column shows 8 Decimal Places...

I see in the IDO for that particular property/column, the length is set to 20 and the decimal places to 8. So, I'm not sure why the Dataview wouldn't grab all 8. On that screen, the formatting part is blank for "Display Decimal Places" - Would this be where I have to set it to 8 so the Dataview can grab it from here ???

I have to believe someone has done this for a particular column in a Dataview ??? This is CSI 9.01.10 if it matters...

Help

thanks,

Glenn

Find more posts tagged with

General Discussions

Accepted answers

All comments

burnsg

We have this issue with SL8.03.11. Our solution was to display the column as a string where we could control number of decimal places. This solution caused another issue when exporting to Excel. So we added a hidden column in the layout that was the decimal version. Users that wanted to export to Excel can change their layout to include it. I thought I heard the two decimal place restriction on DVs went away in newer versions?

burnsg

unknown

Formatting of the data is based on the Property Class assigned to your IDO Property on your IDO. AmountType (or simply Amount when you select it on the IDO Properties form) will typically give you two decimal place formatting. For costing, use the CostPrcType (or CostPrc) to get five decimal place formatting. I don't typically see people use or need 8 places, but you can experiment with the various decimal-based Property Classes and see which one will give you the formatting you want.

burnsg

In my example (above), we are using Property Class of QtyUnit, but still only get 2 decimal places (tha Prop Class says 3). It was our understanding this was just a limitation of DataViews in SyteLine 8. I assume in newer versions, this would indeed solve this problem?

unknown

I will try that and see if there are any changes !!

thanks

Copyright © 2025 Infor. All rights reserved.