Four Report Builder bugs?

oldhawkeye · Newbie Joined: 14 Dec 2007 Posts: 3

I really like the power of Report Builder. It is finally getting close to M$ Access. However, in working with it I believe I found four bugs(?). One, how to group sum a column has a work around discussed previously. I have also found that assigning a Currency format puts a minus sign in front of the number even if not negative this can probably be solved with a custom format for a work around. Underlining a label does not always work. I don't know why and the only work around is to use the horizontal draw facility. Which reminds me of a fourth thing, I know of no way to increase the thickness of the horizontal line. The line format doesn't seem to change anything.

oldhawkeye · Newbie Joined: 14 Dec 2007 Posts: 3

Sorry, I misspoke in the above. The underline does not work for Bold. It looks OK on the build form, but not when executed. It becomes dotted bold.

dlindaman · Posted: Sat Mar 08, 2008 12:17 pm Post subject: Negative Currency Sign

I too am having trouble with the unwanted negative currency sign. Does anyone know a work around for this?

centipede · Newbie Joined: 12 Sep 2008 Posts: 4

Using the following format code works sometimes for getting positive numbers:

[$$]#,###.00;[$$]#,###.00

This worked for a field where I was totaling the giving data for each giver. Each individual gift was still negative, or had no decimal places.