Search results for query: *

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

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

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

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

Hi Turkbear, forgot to include DB - Oracle.

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!

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

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

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

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

Hey all, Using Crystal XI. Does anyone know the best way to do this? Please see the 3 scenarios (invoices) below: (1) The whole invoice is free-form text in {Invoice.InvoiceText} field of data type, MEMO. (2) I need to grab the Length (Size of Accessory). EX: For Invoice #1, that would be 5.0...

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

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

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

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

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

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

Thanks lbass! (1) Just confirmed that we will have a table that contains a list of departments. That does make things MUCH easier. I decided to try it with no subreport and it actually worked. (A) Added "depts" (list of departments) and "visits" tables, unlinked. (I put this data in an excel...

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

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