OT:Crystal Reports

Topic

New Reply

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?

Reply | Quote

Replies

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

Reply | Quote

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.

Reply | Quote

Have you checked with the people who designed Crystal Reports?

Their website is Crystal Reports

Bob

Reply | Quote

Actually, that link is to Quasar Business Solutions. I tried http://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.

Reply | Quote

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.

Bob

Reply | Quote

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.

Bob

Reply | Quote

You might also want to try here looks like they might have something on Crystal Reports.

The difference between Genius and Stupidity:
A Genius knows their limits.
- Albert Einstein

Reply | Quote

You might also want to try here looks like they might have something on Crystal Reports.

The difference between Genius and Stupidity:
A Genius knows their limits.
- Albert Einstein

Reply | Quote

Actually, that link is to Quasar Business Solutions. I tried http://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.

Reply | Quote

Have you checked with the people who designed Crystal Reports?

Their website is Crystal Reports

Bob

Reply | Quote

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.

Reply | Quote

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

Reply | Quote

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

Reply | Quote

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

Reply | Quote