Results 1 to 3 of 3

Thread: Crystal formating Suggestion

  1. #1

    Thread Starter
    Addicted Member
    Join Date
    Nov 2002
    Posts
    150

    Crystal formating Suggestion

    hi guys,
    I have a question for Crystal Developers. I have database that keeps track of employees functions and times. I'm trying to develop a report that shows these records but some employees have multiple functions. I attached an image of what I'm looking to do.

    joe smith have three records in database but in my crystal I want to show his name once and the three functions and times. any suggestions are appreciated.

    I'm using Crystal 10 with SQL server.
    Thank you,
    waely
    Attached Images Attached Images  
    Last edited by waely; Jun 15th, 2006 at 09:50 AM.

  2. #2
    Lively Member
    Join Date
    Mar 2006
    Posts
    94

    Re: Crystal formating Suggestion

    Quote Originally Posted by waely
    hi guys,
    I have a question for Crystal Developers. I have database that keeps track of employees functions and times. I'm trying to develop a report that shows these records but some employees have multiple functions. I attached an image of what I'm looking to do.

    joe smith have three records in database but in my crystal I want to show his name once and the three functions and times. any suggestions are appreciated.

    I'm using Crystal 10 with SQL server.
    Thank you,
    waely
    Easy. Go to the field on the report that shows the name. Right click and choose format field. Check the "Suppress if Duplicated" checkbox. Presto all done!
    Energy can be neither created not destroyed. It can only be wasted.

    Red Green

  3. #3
    Frenzied Member
    Join Date
    Nov 2001
    Location
    Mass USA
    Posts
    1,674

    Re: Crystal formating Suggestion

    You can also just group by the employee name.

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