Search results for query: *

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!

Hello all, I'm using CR12 and pulling from a Remedy database using an OBDC connection. I'm looking for a way to extract the last entry in a worklog. Here is an example of the worklog: Monday, September 05, 2011 10:11:19 AM usnername Report assigned. Tuesday, September 06, 2011 4:36:12 PM...

Hello LB, That worked just great! I'm going to try to write it so that I'll get it to pull the time if there is actually an entry for the time, and if not, then just fall to the default time. Right now, not every record has that entry and I'm now getting bad date/time format errors. I'll try...

Here is a sample of the memo field: Rec date 08/10/2011 15 gobbledygook, sentences, words, sentences, words, gobbledygook Currently, it's just extracting the date. The folks entering the data in the memo field are only entering the date. I'm just trying to see if there is an easy way for them...

Hello again, The above formula has been doing the trick...no problems with it whatsoever. Something I'd like to see if I can add to this is to add the time also. The default time is going to be 00:00:00. If have an integer in the text field representing an hour, can I add that into the...

I have already tried all those suggestions. However, I cannot suppress the blank section as suggested in your last suggestion. The checkbox is grayed out.