-1

In database it is stored in Bigint but when comes tocrystal reports page it displays in decimal format; Value is in database (3), But when comes to crystal reports page becomes (3.00). How to change it?

sample

but I need it in integer round off like below 

A | B
7 | 6

i'm using visual studio 2005.

there is no number format tab enter image description here

Swathi Venugopal
  • 83
  • 1
  • 10

2 Answers2

0
  1. Select the number field on the report.
  2. Right-click and format.
  3. On the Number tab, click on the Customize button.
  4. On the Number tab, set the number of decimal places to 0.
Spider man
  • 3,224
  • 4
  • 30
  • 42
0
  1. Select The field
  2. Right Click
  3. Click on Format Object
  4. Click on Number Format
  5. Click on Customize
  6. On Decimalas Select 1

Click on OK

vcs
  • 3,675
  • 4
  • 17
  • 15
  • In the Format Editor there is no Number Format Tab check my post again for updates – Swathi Venugopal Jun 24 '15 at 07:08
  • Number tab appears only for Numerical fields. Check your Database for field definition. Field is definitely not defined as Bigint. If it is defined as Bigint then goto field explorer click on table name and click Verify Database – vcs Jun 24 '15 at 08:04