Results 1 to 5 of 5

Thread: [RESOLVED] Formatting Crystal Report Formula

  1. #1

    Thread Starter
    Junior Member
    Join Date
    Nov 2007
    Posts
    30

    Resolved [RESOLVED] Formatting Crystal Report Formula

    Is there any way to customize the PageNofM field in CR so i can change the separator to something else not "of"?

    I've made a formula with syntax:
    PageNumber &"/"& TotalPageCount

    but the result is something like these:
    1,00/3,00

    How do I format the formula so the output would be:
    1/3

    Im using Crystal Report installed with VS 2005 Professional Edition

    Thanx,

  2. #2
    Frenzied Member
    Join Date
    Aug 2006
    Location
    India, Punjab, Bhatinda
    Posts
    1,689

    Re: Formatting Crystal Report Formula

    I don't know about this
    Crystal Report installed with VS 2005 Professional Edition
    but Try this... (works for cr9 & 11)
    Open the Field Explorer click (+) on the special fields You should find page N of M pull it and place it at the reqd place in the report

  3. #3
    Frenzied Member
    Join Date
    Aug 2006
    Location
    India, Punjab, Bhatinda
    Posts
    1,689

    Re: Formatting Crystal Report Formula

    sorry I got your question wrongly.
    Try this
    Code:
    totext(pagenumber,0) & "/" & totext(totalpagecount,0)

  4. #4
    Frenzied Member
    Join Date
    Aug 2006
    Location
    India, Punjab, Bhatinda
    Posts
    1,689

    Re: Formatting Crystal Report Formula

    Pls Resolve the thread if got your problem solved

  5. #5

    Thread Starter
    Junior Member
    Join Date
    Nov 2007
    Posts
    30

    Smile Re: [RESOLVED] Formatting Crystal Report Formula

    Thanx VBFNewComer, it helps me a lot, sorry for the late response.

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