Results 1 to 8 of 8
  1. #1
    Star Lounger
    Join Date
    Dec 2002
    Location
    New Orleans, Louisiana, USA
    Posts
    95
    Thanks
    0
    Thanked 0 Times in 0 Posts

    OT:Crystal Reports

    Hi,
    The people on the Access page have been a huge help to me and now I've been googling for an answer to something in crystal reports for several hours and apparently, I'm just not using the right phrases to search. I want to separate a field name into two fields. Currently, our ** Possible SPAM post - please alert a Moderator (2)** system uses one field to store the patient's name. It's stored in the field CCUSNM and in the format LastName,FirstName. I want to separate it into two fields so I don't have to use text-to-columns after I export the report to excel. Anyone know the answer or know where I can find the answer?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: OT:Crystal Reports

    Where are the data? Crystal Reports is not a database system, or am I wrong?

  3. #3
    Star Lounger
    Join Date
    Dec 2002
    Location
    New Orleans, Louisiana, USA
    Posts
    95
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: OT:Crystal Reports

    No, It's a software program used to pull data from databases. I pull from an Oracle database but then I can export the data into an Excel file and sort and manipulate. I just thought someone here might have been experienced with Crystal and know the answer. Thanks anyway. I'll just keep doing text-to-columns once I get it into Excel.

  4. #4
    Uranium Lounger viking33's Avatar
    Join Date
    Jun 2002
    Location
    Cape Cod, Massachusetts, USA
    Posts
    6,308
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: OT:Crystal Reports

    Have you checked with the people who designed Crystal Reports?

    Their website is Crystal Reports

    Bob
    BOB
    http://lounge.windowssecrets.com/S/flags/USA.gif http://lounge.windowssecrets.com/S/f...sachusetts.gif


    Long ago, there was a time when men cursed and beat on the ground with sticks. It was called witchcraft.
    Today it is called golf!

  5. #5
    Star Lounger
    Join Date
    Dec 2002
    Location
    New Orleans, Louisiana, USA
    Posts
    95
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: OT:Crystal Reports

    Actually, that link is to Quasar Business Solutions. I tried www.crystaldecisions.com which is the website I was given in the Crystal class I took. They told us in class they only give support if your company pays for it and you guessed it, mine won't. I thought there might be a messageboard like this one but I wasn't able to find one. I'll have to google some more.

  6. #6
    Uranium Lounger viking33's Avatar
    Join Date
    Jun 2002
    Location
    Cape Cod, Massachusetts, USA
    Posts
    6,308
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: OT:Crystal Reports

    I guess Quasar is a distributor.

    Ok, how abou t support ?

    It looks like they have at least a Knowledge Base and online freebies there, without getting into the pay-me side of the house. <img src=/S/free.gif border=0 alt=free width=30 height=15>

    Bob
    BOB
    http://lounge.windowssecrets.com/S/flags/USA.gif http://lounge.windowssecrets.com/S/f...sachusetts.gif


    Long ago, there was a time when men cursed and beat on the ground with sticks. It was called witchcraft.
    Today it is called golf!

  7. #7
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Phoenix, Arizona, USA
    Posts
    265
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: OT:Crystal Reports

    You might also want to try here looks like they might have something on Crystal Reports.
    Ed
    "Somebody left the cork out of my lunch." - W. C. Fields

  8. #8
    New Lounger
    Join Date
    Aug 2002
    Location
    Ontario, Canada
    Posts
    16
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: OT:Crystal Reports

    Hi Laura

    I don't know if this will help you. It is in VB6 but should be adaptable to VBA in Excel if it won't work as is.

    Private Function GetLastName(CCUSNM as string)
    'Get last name from CCUSNM
    Dim intCommaPosition As Integer

    'Find the comma
    intCommaPosition = InStr(1, CCUSNM, ",")
    'Take left characters up to comma
    GetLastName = Left(CCUSNM, intCommaPosition - 1)
    End Function


    Private Function GetFirstName(CCUSNM as string)
    'Get first name from CCUSNM
    Dim intLength As Integer
    Dim intCommaPosition As Integer

    'Find the comma
    intCommaPosition = InStr(1, CCUSNM, ",")
    'Length of first name is length of full name - up to comma plus one for space
    intLength = Len(CCUSNM) - (intCommaPosition + 1)
    'First name is to the right of the comma
    GetFirstName = Right(CCUSNM, intLength)
    End Function

    Good Luck

    Mary

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •