problem with Number formats

[mynameant]

Hi all, I am using CRXI reports designer and built a report that has 2 sub reports [not linked]. My Main report is just a place holder for these two sub reports
main report
|
|
Sub report1
Sub report2

in sub report1 I have some strings to be displayed which is working fine. On sub report2, I have some totals [kind of aggregate report] and for all these totals I have selected (1123.00) number format. But the output I was getting for these totals are (3456.56) , (4567.89) etc.. [It's including those parenthesis[??]]. If I change the format to (-1123.00) then it's putting those "-" sign on all positive values..I am not sure where it's going wrong.

Any suggestions???
Thanks,

 

[lbass]

Sounds like your values ARE negative. Maybe you should show sample data and share your formulas.

-LB

 

[chelseatech]

You could tick the field format option "Reverse Sign for Display". The numbers are negative for a reason.

Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm

 

[mynameant]

Thanks for your responses. Actualy numbers are not negative. they are totals coming from Oracle database in a procedure and I made sure all the number are positive. So, why is it still putting those brackets around the totals if I select (1123.00) number format?

There are no formuals on this report. All the totals as is are taken from a procedure and are displayed in details section. So, not sure what could be wrong. I am in a process of rewriting my report and hoping that fixes [current report might have got corrupted or something.can't even guess )

Actually I forgot one more information:
this is my report details section:
Monthly Totals Daily totals
Jobs interviewd 4040.00 (202.00)
jobs selected 500.00 (25.00)

I have selected same number fromats for all the above totals and for monthly totals they are showing up correct. But for daily totals [which are (monthly_totals/20)] , it's showing this way. So not all the totals are behaving the same manner. If I select (-1123.00), then daily totals are showing up as negatives [??]

 

[lbass]

I'd say there is something set up incorrectly in the stored procedure, e.g., a stray minus sign on the daily totals.

-LB

 

[chelseatech]

Try a formula of
If {table.field} < 0 then "Have a negative" else "Positive"

That will prove your stored procedure is giving you a negative number. Crystal doesn't change data once it gets it.

But just to be sure, do a verify database. it might be the stored proc was changed and is arriving in a different format to when the report was designed.


Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm

 

[mynameant]

Chelseatech,I think your formula helped me identify the problem. Like you mentioned, it was showing a "Have a Negative" for that value. Not sure why. Atleast i know it's stored procedure and not crystal. Thanks. I'll try testign my stored procedure now.

Thanks for your help.