Search results for query: *

Damon & LB, Both solutions worked perfectly - Thanks to you both for the fast response! - Robin

Hi, CRv10 on Enterprise Data source: Encore/Impact 6.0 (ODBC) Field Name: {ARINVOICE.InvoiceDate} Field type: Date Background: I'm writing a "welcome letter" (form letter) to send to our customers who buy our warranty support services. The warranty start date is always the 1st day of the...

Thanks for the suggestion. Setting defaults to pull a report with no detail and displaying the user's specified parameters in the header is a good idea as a standard practice anyway. I'll make sure I start doing that on all reports. When you mentioned "Pink Slip" report, what did you mean?

CRv10 on CEv10 Data source: Encore/Impact 6.0 (ODBC) When business users run (schedule) reports on CE, they are not presented with a "Parameters" dialog box asking them to make their choices (date range, invoice number, etc.). I know the "Customize Your Options" pick list is there and the...

Thanks to you both for the fast response. (I've been trying to work this out since 7:30 this morning) Your suggestions worked perfectly. My report is beautiful; it's on time and my boss thinks I'm a Rock Star! Thanks again and have a happy holiday! - Robin

Hello, Using CRv10 Data Source: Excel Data Type: String I'm trying to show the date of manufacture & the manufacturer of our product using a formula based on their 10 digit serial numbers. Not sure how to get what I'm after though... Serial Example: 0436040002 the 1st & 2nd digits represent...

CR Version 7 DB = Encore/Impact/Syspro 5.1 ODBC Hello, I'm working with a Transaction Time field that returns time values like: 8311576 and 10125494. CR Field Type is: Number How can I convert the above values into an HH:MM format? Thanks as always for the help. Robin

Hi Brian, I was in fact the cdate! I went to CR Tech Support site again and downloaded a whitepaper on date/time formulas. It says that the cdate function is not available until version 8. I did as you requested and replaced "cdate" with "date" in SV's formula... VOILA! It worked. Thanks...

EUREKA! I FOUND IT! I went to CR tech support site and found the following: NumberVar YYYY; NumberVar MM; NumberVar DD; YYYY := Truncate({SORCHANGES.TrnDate} / 10000); If Truncate(({SORCHANGES.TrnDate} - (YYYY * 10000)) / 100) > 0 and Truncate(({SORCHANGES.TrnDate} - (YYYY * 10000)) /...

Hi, No, I get the same error message on: cdate(val(left(totext(19700101,0,""),4)),val(mid(totext(19700101,0,""),5,2)),val(mid(totext(19700101,0,""),7,2))) Could it possibly be the "cdate"? My cursor gets placed in front of it every time I get the "The remaining text does not appear to be part...

Of course I used MY table names, I just didn't paste correctly in my reply. (shoot!) Here's the real formula... cdate(val(left(totext({SORADDITIONS.TrnDate},0,""),4)), val(mid(totext({SORADDITIONS.TrnDate},0,""),5,2)), val(mid(totext({SORADDITIONS.TrnDate},0,""),7,2))) Sorry for the error...

Hi Dave, I tried your formula too, but also get an error message. "The ) is missing..." When I put the ) where my cursor lands, I get: "The remaining text does not appear to be part of the formula..." Sorry to be a pain in the posterior - I sure appreciate the help. LMK if I can provide any...

Hi SV, I'm in the Formula Editor. My formula looks like this: cdate(val(left(totext({table.numberfield},0,""),4)),val(mid(totext({table.numberfield},0,""),5,2)),val(mid(totext({table.numberfield},0,""),7,2))) When I click the "check for errors" button, I get this error message:"The remaining...

Hi Vampire, I right clicked the field, clicked "browse data" and the Type is in fact: "number" I tried your subsequent formula just in case and got the same error message as before... - RRR

Hi Vampire, Thanks. I tried the formula (replaced "19700101" with my fieldname), but I'm getting the following error msg: "The remaining text does not appear to be part of the formula..." And my cursor is placed at the very beginning, right before "cdate". Any ideas?

Hi, Using CR7 with Impact/Encore 5.1 ODBC Today I'm writing a bookings report. When I pull a "transaction date" field from our DB, it produces date values in the following format: 20011012 20030707 20040205 However, my desired output is mm/dd/yy. The data type for this field in CR is...

Hi K, Thanks for taking the time to respond to my question - the first formula you provided worked like a charm! - RRR

Hi, I'm writing an invoice report (Crystal 7.0) and I'm running into problems calculating the line item discount and arriving at the correct extended amount. My discount field returns a value of "60.00" for a 60% discount - and I think that's one of my problems. Formula Example: if...

I want to send an email to Groupwise user. But I want to do that when I click a button in my application (Java). After that I would like to be able to know if the email has been read by destination. Is there any Groupwise API to do that ? Thanks Robin robin.tremblay@cognicase.ca