Hi
Im using VB.NET 2003 and SQL Server 2000.
Im currently changing a column 'NoOfPallets' in my database from int to float. I run an sql view to group all the rows that were collected on the same day.
e.g. Date: 24/01/2007, NoOfPallets: 3.5
When I run this report using crystal reports the NoOfPallets doesnt show any decimals. I have removed the field from the report and verified the database and then added the field again. The field shows as (Number) when I hover the mouse over it at design time.
I have also right clicked the field and selected 'format' and tried various options in here.
Anybody know why it doesnt show me any decimals?
Thanks
Darren
