Crystal Report formula Questions

1

Formula question
Hi I have a question about a short formula: IF {ado.UOM}=”LB” THEN crNoColor ELSE IF {ado.UOM}=”KG” THEN “{ado.Pieces}x{ado.Size1}” When I check this formula,there is an error. it always shows that there is some number required. Thank you for help

Answer Question   |  August 20, 2012  4:35 PM
Crystal Report formula
asked by:
10 pts.

How do I put a bottom border on null fields?
In Format Formula Editor : Bottom_Line_Style, how do I put a bottom border on when the field is null.

Answer Question   |  July 26, 2012  12:49 AM
Crystal Report 8.5, Crystal Report formula
asked by:
5 pts.

Crystal Reports CSV with quotes inside string
I need to export a CR XI report to csv. Some of the fields allow users to use double quotes to indicate inches. When exported to CSV I get something like this: “Andy”, 4685, “requires 5″ by 2″ silver plate”, 1132 According to CSV standard it should be: “Andy”, 4685, “requires 5″” by 2″” silver [...]

Answer Question   |  May 24, 2012  4:26 PM
Crystal Report formula, Crystal Report XI, CSV
asked by:
5 pts.

Crystal crosstab formulas
When I create a crosstab report using general ledger debits and credits, I can’t get the formula to subtract the credits from the debits. Can you tell me what formula I can use to fix this issue?

Answer Question   |  April 17, 2012  7:41 PM
Crystal Report formula, Crystal Reports 10
asked by:
10 pts.

1