Search results for query: *

Worked Great...thanks a million for the fast reply, Ian. Bart

I need to extract the proper name on a field where the string data looks like below... (Using Crystal 10) Example {unit.operator} returns "cn= Alan Mathis/OU=Waco/O=WEB" or "cn= Anthony Winkelmann/OU=Waco/O=WEB" I need it to extract the proper name. Preceding the name is always "cn= " and is...

I am using Crystal reports 10.0.5 accessing an SQL database. My brain has turned to mush as I have not had to do this simple task in a few years... The current report is set-up with a formula for each month in 2006 as a separate formula to only report that months quantity to be able to sum it...

Thanks so much to the both of you...and yes the field is never blank...so I went with: if instr({unit.sqlKey},"WEB") >0 then mid({unit.sqlKey}, instr({unit.sqlKey},"WEB")+3,22) else mid({unit.sqlKey}, instr({unit.sqlKey},"AFS")+3,22) (Changed it to the 22 to capture AM-PM) It appears to be...

I am using Crystal 10.0.5 writing a report on a SQL data table. I have the below string that I need to extract the date and time. The information in the field is as below. CN=Bart Preston/OU=Waco/O=WEB01/07/2004 11:28:26 PMcel_2 The date time is always preceded by the words WEB or AFS and...

Sorry LB I got it figured out right after I posted... I put the formulas in the detail section and then did a summary on each. It worked fine. Funny, I worked on this for about 6 hours to no avail and then figured it out 10 minutes after posting... (Forest, trees I guess) Yet thank you very...

Using Baan IVc3...Crystal Reports 10 Report is ran on data table tiitm001 I have my report grouped by "Item Group" The selection code field is used in our system with 4 possible selections (MA, MB, MC, and MD) I need to have the report print out the "Lead Time" by "Selection code" in the "Item...

I used the -1 configuration and it worked great... All the #'s match up to the previous report. Thanks again for the help

I tied the above and it worked like a champ... Thanks for the help... One ?last? question...If I use the formulas as above, it will include the 1st day of Month 3 into the #'s for month 2 won't it? dateserial(year({?PDate}),month({?PDate])+2,1) to_...

Could {?PDate} = Today's date? As i would like this report to run at night with ZERO input as to the Parms? Thank you very much for the help...

I have a report that we have been using Parm Promts to enter the start dates for the next 3 months. I am using Crystal version 8.0 connecting to Baan 4cIV. I am trying to sum the quantity on Order by date ranges. Ex Late = (Sum of all quantities with a due date later than today) if...

Thanks a lot LB...I made a 1 mod and it worked AOK for me. {still can't figure out why Baan programmers use 5 different date formates in IVC products} Thanks again for the help....

I am using Crystal 8.01 accessing Baan IVc4. Does anyone have a simple formula to convert the hours accounting dates to a standard date format? Example 3 seperate fields in Baan Day = 4 Week = 18 Year = 2004 This represents April 21st, 2004 (4th day of week 18th in year 2004) I need the...

Thanks for the help...Got it in 1... Regards Bart

Using Crystal 9.0 on a single data table...Connecting to UNIX shipdate.orders qtyshipped.orders Grouped by date shipped (by month) The report is summed by month (qtyshipped and count of orders) I need a formula that calculates the # of weekdays in the group summary. (By month) I have done...

Sorry for the late response. I have been away on business. I took your advise and re-wrote the report to simplify the logic. Worked great. As always---thanks for the assist LB Bart Preston

CR ver. 9 I have a report that is using running totals. The report uses 2 export tables from UNIX. The 1st is Today’s sales order information by part #. The 2nd is yesterday’s sales order information by part#. The sales quantities of both are bucketed weekly on the export. I am using running...

-k Thanks for the assist. It worked and gave me options for expanding the use of data. -LB This is the formula I had used previously and it worked GREAT. I guess I went brain dead, as I knew I had used a similar formula. Thanks for the awakening I also created a third variation with the...

I feel like I am loosing something here as what I am trying to do should be easy, yet I can not get the formula to report correctly. I have only 1 table with approx 29 fields. I am trying to sum the orders.shipqnty field by a date range by orders.partid. The report selection criterion is for...