Help with formatting numeric report field, please.

[Stella740pl]

Hello, everyone!

My report has a numeric field that is currently formatted as #,###,###, and another one formatted as 9999.9, so they show minus signs for negative numbers.

Now I have a request to show also a plus sign for the positives. Short of making the whole field character, or putting the plus into a separate field, is there a format mask or a trick to easily achieve it?

Thanks.

 

[Stella740pl]

Jim, I get the error when trying to REPORT FORM, not MODIFY REPORT.

 

[Stella740pl]

OK, I get the error in both cases, when doing REPORT FORM and MODIFY REPORT, but to replicate that, I need to change your code a little:

USE dummy1.frx
REPLACE Expr WITH REPL('x',9999) [red]FOR objtype=8[/red]   
USE
MODIFY REPORT dummy1   &&  Here you go.

 

[jimstarr]

Using your code still produces no error for me - VFP5. -Jim

 

[Stella740pl]

Do you have at least one field in your Dummy report (objtype=8)? If not, plese create, then try again.

 

[Stella740pl]

Since I have not so many of those records with the length of Expr over 255, I am now trying to get around it by creating 10 more report variables. It looks like it might work.

I didn't want to do it at first, since I already have a lot of them, and those long expressions can be (and are) calculated from existing report variables, but since the whole construction gets out of hands, I didn't have much choice.

 

[Stella740pl]

Jim, did you reproduce the error?
Or did it work differently in the VFP5?

 

[jimstarr]

Hi Stella,

Yes I did reproduce the error. The maximum length allowed seems to be 255. -Jim

 

[Stella740pl]

Thanks. That's my experience, too - and seems to be confirmed in the link I posted above.

So I went with a workaround.
Thanks everyone for the ideas.