Recent content by Cardstang

Hello, I'm using CR2008 and I have three Remedy tables I need to join and use some shared variables in the final results. The tables are as follows: ParentTicket ChildTicket ChildTicketNotes The database does not allow joins. What I need in the final output is the ID# of the Parent ticket...

I think we're getting closer... Now the "NOT" is getting lit up and telling me I need a Then statement.

Hey thanks for helping me out! It's not liking the If/Then statement. It's telling me I need a Then statement and proceeding to highlight: IF {table.city}= previous [highlight #729FCF]{table.city} [/highlight]

I'm sure that's an unclear Subject, and I apologize if it's confusing...not sure how else to word it. What I'm looking to do is compile all the zip codes in a City into one field. My raw data looks like this: Ticket# City ZIP 123456 Atlanta 30511 234567 Atlanta 30512...

CoSpringsGuy, that worked fantastically. I'm playing around with the formula to try to extract other tidbits. This site is great for helping me learn how things work. Thanks again

thread767-1650510 I have a question similar to the one asked in the referenced thread... I'm trying to extract a date from the memo field, but in this case, the date is not always the same length...meaning that August 8, 2012 is displayed as 8/8/2012, but October 8 is displayed as 10/8/2012...

That's really not an option. The list of devices is not static. Also, the device names are used multiple times in different areas. There may be a device name of A1 in New York, Chicago, and Atlanta. I'll combine the device with another field to create a unique ID. Thanks for trying to help. I...

No, there is no table containing those devices. The field is a free text field and the values are separated by commas.

The "Item" field is actually device names. The multiple devices can be listed in a single ticket. I need to get a count and trend on how many tickets each device has had opened on it. It will be ongoing and automated, therefore manipulating it in Excel isn't a good option at this point. There...

It's a Remedy database using an OBDC connection. My report fields are like this: {Table.Field} This particular field is a string field.

I'm not able to use Excel in this report. Hoping to find a solution from within Crystal.

Hello all. I'm not sure how to word the subject in a way that makes sense, so I apologize if it's confusing. I have a report that contains a string field that lists anywhere from zero to 25 or more items of information. These items are separated by a comma. What I need is a way to make a new...

I've tried using a crosstab, groupings, and running totals and I can't seem to get this right. I'm using a formula to determine the time frame of when a record is created. I then want to show a summary of those time frames. Here is what I'm trying to get to: Time Frame # of Records...

Oh and the date/time and usernames are a field. I'm pulling those seperately now and will combine if needed.

It doesn't seem to be two carriage returns to create the sections. The formula grabbed everything in the worklog. I did get it to grab the last entry by modifying to this: stringvar array x := split({table.Work Log},{table.Last Modified By}); x[ubound(x)] Thanks for the help!