Urgent --- cant get my numbers aligned

[ajen7118]

Hello everyone,

I have two different reports to display when I choose a prompt.  I called these two reports based on the parameters i choose.

The number for one report shows below --> numbers aligned with parentheses

   1234567 -->  positive
(1234567) --> negative

the other report shows (this is the way I want both reports to show)  --> numbers need to be aligned with each other

1234567 -->  positive
(1234567) --> negative

i set up parentheses in property --> data format.

thank you.

[cognos810]

Hello ajen7118,
Looks like one report has that column as right aligned and the other as middle. See if you get the desired results, by making the alignment for that column as middle.

-Cognos810

[ajen7118]

Hi,

thanks for getting me back promptly.

I set up the same alignment for my table. I have a query to call all numbers when I choose the prompt.

please see the attachment.

thanks. I really appreciate.

[bdbits]

For what it's worth, Excel also formats it like Cognos is doing. So I think this is what you want it to look like...


12345
  (12)
  345


I think you can get close with data format patterns. If you select a format type of number, you will find there are two of them, "Pattern" and one "Negative Pattern", near the bottom of the list. For the "Pattern" use this where the word [space] is replaced with a space character:  [space]#,##0[space]
For the "Negative Pattern" use: (#,##0)

If you want it to look very aligned, you may need to switch to a mono-spaced font like Courier. But that is about as close as anything I can think of to get the desired alignment.