I have a detail row that lists a series of numbers. I need to put a dollar sign in front of each number but ONLY on the first row, like so:
$1 $2 $3 $4 $5
1 2 3 4 5
1 2 3 4 5
How might I accomplish this within the Crystal Report?
Printable View
I have a detail row that lists a series of numbers. I need to put a dollar sign in front of each number but ONLY on the first row, like so:
$1 $2 $3 $4 $5
1 2 3 4 5
1 2 3 4 5
How might I accomplish this within the Crystal Report?
Instead of directly using fields, use formula
In formula you can use an if statement with like
if(recordnumber==1) then
your code
Quote:
Originally Posted by sraheem
OK just a little more detail on my problem. It is actual a summed field in a group header so I need to count the (detail) each summed row then place a $ on the first summed row. First question, what is recordnumber? Is that a variable or some sort of Crystal keyword. After the then is there anyway to programatically add the cuurency symbol to the field or do I just use a textbox (which won't format as well)?
Just a thought, you might try custom formatting.
Select the field, right click and select format.
choose the number tab, click the customize button.
choose the currency symbol tab
check the boxes for enable currency symbol and for one symbol per page.
Recordnumber is the special field which gives serial no for the rowsQuote:
Originally Posted by tripower