Comma in numbers

(2 posts) (1 voice)

Tags:

No tags yet.

  1. elb98rm, Member

    Hi,

    I've had a look at the documentation and I can't work out how to remove commas from numbers in a report...

    As an example:

    User ID: 1000

    is shown as:

    1,000

    If you could let me know how to remove this formatting, that would be great.

    Cheers
    Rick

    [Just realised this went in the wrong area of the forum: apologies]

  2. elb98rm, Member

    I've found it tucked away - I think the documentation needs a bit more detail!

    For anyone who's interested, here's how you do it to a column named 'Employee #':

    select 'dbr.colstyle', 'Employee #','%d';

    Cheers
    Rick


Reply

You must log in to post.