Numeric Group Header displaying incorrectly

[Marichele]

I have a group header based on a sequence number (for a work list). When we browse the data in the field it is (1,2,3,4,5,6) but it displays (49,50,51,52,53,54).

It appears to be displaying the ascii value rather than the number. How do we stop this?

Thank you for any help you can provide.





Thanks,
Mary

 

[Marichele]

We figured it out. For your benefit.

We are using an Oracle database, the field was of type NUMBER(4). Change the type to NUMBER, without the length designation and it works just fine.

Thank you for reading this.

Thanks,
Mary