CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 5 of 5
  1. #1
    Join Date
    Jul 2006
    Posts
    14

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

  2. #2
    Join Date
    Jan 2006
    Posts
    194

    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
    [email protected]

    Try your best then wait for things to happen....

  3. #3
    Join Date
    Jul 2006
    Posts
    14

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

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

  4. #4
    Join Date
    Aug 2007
    Posts
    180

    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.

  5. #5
    Join Date
    Jul 2004
    Location
    Chennai, India
    Posts
    1,064

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

    Quote 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
  •  





Click Here to Expand Forum to Full Width

Featured