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 Chriss Miller 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: LWTri
  • Order by date
  1. LWTri

    BOE XI: How to auto print and fit Legal/Landscape on Letter?

    Thanks Dell. SAP agreed I should put in an enhancement request. Seems like a pretty basic feature that Crystal/BOE should really have.
  2. LWTri

    BOE XI: How to auto print and fit Legal/Landscape on Letter?

    Any input? Anyone? I worked with SAP and they couldn't provide a solution. The only closely related issue online was: http://tek-tips.com/viewthread.cfm?qid=181599 (for an old version).
  3. LWTri

    BOE XI: How to auto print and fit Legal/Landscape on Letter?

    BOE XI: How to auto print Legal/Landscape on Letter? Crystal/BOE XI: Within BOE, we automatically email a legal-sized (8.5x14) report as PDF. When users open and print PDF, it resizes and prints on Letter/Landscape (8.5x11), which they're happy with. They now want report to PRINT automatically...
  4. LWTri

    COMMAND DATE RANGE - Yesterday 7AM to CurrentDate 7AM?

    When simply searching for Oracle date formats, I couldn't find syntax for this purpose... but I finally searched for "concatenate date and time": http://forums.oracle.com/forums/thread.jspa?messageID=4014345 I'm hoping something like this will work. I'll try it out. Please share if anyone has...
  5. LWTri

    COMMAND DATE RANGE - Yesterday 7AM to CurrentDate 7AM?

    Hi Turkbear, forgot to include DB - Oracle.
  6. LWTri

    COMMAND DATE RANGE - Yesterday 7AM to CurrentDate 7AM?

    Hello all. In Crystal XI, I'm debugging my SQL COMMAND syntax: This worked in Group Selection, but trying to use logic in a COMMAND instead: {REG.START_DT_TM} >= datetime(currentdate - 1,time(7,0,0)) and {REG.START_DT_TM} <= datetime(currentdate,time(6,59,59)) Thanks for your help!
  7. LWTri

    How to display a substring using &quot;LIKE&quot; and specific words

    Thanks lbass! Actually, I didn't give the best example. Here are 3 more scenarios: ------------ INVOICE #4 ------------ Item: Stuffed Animal Color: Yellow Item Type: Infant toy Toddler toy Children's toy Quantity: 5 Size of Box: 60cm x 60cm x 60cm ------------ INVOICE #5 ------------ Item...
  8. LWTri

    How to display a substring using &quot;LIKE&quot; and specific words

    Hi lbass (or anyone else), I've had a tough time finding online a simple solution for this next question. I'm also trying to extract/display a string that STARTS with a certain string pattern and ENDS with a certain string pattern. There is no consistent start or end position in string/array (so...
  9. LWTri

    How to display a substring using &quot;LIKE&quot; and specific words

    I did try it this morning and indeed it worked! (returns string up to first instance of third argument)...Yahoo. Thanks AS USUAL, lbass!
  10. LWTri

    How to display a substring using &quot;LIKE&quot; and specific words

    Thanks lbass! For all three scenarios, I only want to grab the Length from Size of Accessory (even when there are extra dimensions). My task is to ignore all the other sizes or "cm"s on the invoice. I'll need to extract for Invoice #1: "5.0" Invoice #2: "4.0" Invoice #3: "7.0" I will try...
  11. LWTri

    How to display a substring using &quot;LIKE&quot; and specific words

    ..."Size of Accessory" and before the first instance of "cm" (associated with Size of Accessory). I want to grab a substring LIKE "Size of Accessory*cm", but that won't work because there are numerous instances of "cm" afterwards on the invoice. Or...I could grab a substring LIKE "Size of...
  12. LWTri

    Email Alerts - How to send to email addresses in database field?

    Thanks for the information, Ken! I'll poke around...
  13. LWTri

    Email Alerts - How to send to email addresses in database field?

    Hey all, anyone know how to do this in Crystal XI? I'm trying to set up an Alert that will send e-mails automatically to e-mail addresses from a database field. (Instead of adding e-mail addresses statically within BOE Central Mgmt Console > Schedule > Alert Notification). Logic: Managers...
  14. LWTri

    How to get &quot;Next Next&quot; Value?

    Hi lbass, thanks so much for your input. My teammate changed approach on how to attack the report. Turns out that the data had a "STEP" field (Step A, Step B, Step C, Step D, Step E). Under each Case# group, the 5 records were sorted in same descending order by Step. He needed to diplay the...
  15. LWTri

    How to get &quot;Next Next&quot; Value?

    Thanks for everyone's input! Madawc - I'll try a subrpt method and see if it works out. Lbass - Unfortunately, we're not sorting the data. It's just a raw dump. I'm not certain if we'll be using a group (requestor won't be back till next week). What are your ideas for method within a group...
  16. LWTri

    How to get &quot;Next Next&quot; Value?

    Here is an example of what I'm trying to do. There is NO SORT ORDER. This is a raw dump of data from database. For each record, we're trying to also display the "Next Next" CaseDate (CaseDate from two records later), using a formula. NthLargest function unfortunately won't work because we don't...
  17. LWTri

    How to get &quot;Next Next&quot; Value?

    Hello, I'm reopening an OLD THREAD that I had not finished: How to get "Next Next" Value? HISTORY: _____________________________________________________________________________________________________________________ LWTri (Programmer) 30 Dec 08 14:59 Hey all, we're using Crystal XI. Does...
  18. LWTri

    Count UNIQUE values from String field - SPLIT? Array? Group?

    ...(D) Created RUNNING TOTAL - count on {visits.PERSON} and reset on change of group {depts.DEPT} (E) Selection Criteria: {visits.DEPARTMENTS} like "*"+{depts.DEPT}+"*" The visitors do appear under multiple groups. EX: Jane's single record shows up under all 3 groups (HR, IS and Finance)...
  19. LWTri

    Count UNIQUE values from String field - SPLIT? Array? Group?

    Hey all, could use help! Thanks ahead of time. Using CRYSTAL XI. (1) SAMPLE DATABASE RECORDS/FIELDS: VISITOR DEPARTMENTS (string field w/ comma separators) ------- ---------------------------------------------- Jane HR,IS,Finance Bob...
  20. LWTri

    How to get Maximum (Group 2) of Minimum (Group 1)?

    Ian - nice solution! Implemented the Reset, Eval and Display formulas in appropriate sections using Datetime(YYYY,MM,DD,00,00,00) instead of Date(YYYY,MM,DD 00:00:00)... and finally saw the MAXIMUM (GROUP1) of the MINIMUM (GROUP2) date that I wanted to see! Awesome solution, very excited. Now I...

Part and Inventory Search

Back
Top