Skip to Content
0
Former Member
Oct 13, 2009 at 05:52 PM

Aligning database information on the report

10 Views

Hello! I have a problem with aligning something. In my database I have some information that doesn't line up properly and I need to line it up a certain way. This is how the information shows in my database:

This is for Table.Description column

1      WTR CHARGE                                10000 Gal      @  $0.00
2                                              3040 Gal      @  $0.00050
3      BASIC CHARGE                         1 service           @    $20.00

I have {Table.Description} in the details section in a subreport and the data displays just like that. However I need to line up the '@' symbols so it will look like:

1      WTR CHARGE                                  10000 Gal      @  $0.00
2                                                   3040 Gal      @  $0.00050
3      BASIC CHARGE                           1 service           @    $20.00

Can anyone help me do this? {Table.Description} can't be left or right aligned due to the varying amount of characters on each side, and I have to line up the @ symbol specifically. Each line is a separate line in the Table.Description column.

Thank you for any help.

Edited by: MarcieHennessy on Oct 13, 2009 7:52 PM