Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Cardstang
  • Content: Threads
  • Order by date
  1. Cardstang

    Subreports with shared variables - I think?

    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...
  2. Cardstang

    Compiling non-duplicate data into one field

    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...
  3. Cardstang

    Extract and use date from memo field

    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...
  4. Cardstang

    Comma Separated List to new rows

    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...
  5. Cardstang

    Display rows with no data

    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...
  6. Cardstang

    Last Entry In Worklog

    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...
  7. Cardstang

    Exporting to Excel - too many rows

    Hello all, I'm using CR 2008 (Version 12). I have a report (which contains a subreport) that is working exactly as I need it to work except when I export it to Excel. When exporting, there are multiple blank rows at the top, requiring me to scroll down 200 or more rows before I get to the...
  8. Cardstang

    Extract and use date from memo field

    Hello all, I'm using CR 2008 (Version 12) and I'm trying to extract a date from a memo field and then use the results in a formula. The date is always after the words "REC DATE" in the memo field. I'm able to pull the date out by using the following formula...

Part and Inventory Search

Back
Top