Need to display '$' in the first detail row of numbers

[tripower]

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?

[sraheem]

Instead of directly using fields, use formula

In formula you can use an if statement with like

if(recordnumber==1) then
your code

[tripower]

Instead of directly using fields, use formula

In formula you can use an if statement with like

if(recordnumber==1) then
your code


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)?

[Ned Pepper]

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.

[Madhi]

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)?
Recordnumber is the special field which gives serial no for the rows