|
-
June 10th, 2008, 08:41 AM
#1
Need to display '$' in the first detail row of numbers
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?
-
June 11th, 2008, 04:46 PM
#2
Re: Need to display '$' in the first detail row of numbers
Instead of directly using fields, use formula
In formula you can use an if statement with like
if(recordnumber==1) then
your code
-
June 12th, 2008, 07:58 AM
#3
Re: Need to display '$' in the first detail row of numbers
 Originally Posted by sraheem
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)?
-
June 17th, 2008, 05:38 PM
#4
Re: Need to display '$' in the first detail row of numbers
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.
-
June 26th, 2008, 01:38 PM
#5
Re: Need to display '$' in the first detail row of numbers
 Originally Posted by tripower
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
Madhivanan
Failing to plan is Planning to fail
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|