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 Rhinorhino 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: *

  1. Debug44

    Extracting a name from string text field (Delimiters)

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

    Extracting a name from string text field (Delimiters)

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

    Variable Selection for month formula

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

    Extracta date from a string

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

    Extracta date from a string

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

    Select a specific Baan field @ the Group level

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

    Select a specific Baan field @ the Group level

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

    Select next 3 months for distinct quantities

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

    Select next 3 months for distinct quantities

    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_...
  10. Debug44

    Select next 3 months for distinct quantities

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

    Select next 3 months for distinct quantities

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

    Conversion of julienne type date

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

    Conversion of julienne type date

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

    Number of weekdays in each month

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

    Number of weekdays in each month

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

    CR ver. 9 I have a report that is

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

    CR ver. 9 I have a report that is

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

    Formula to total a date range

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

    Formula to total a date range

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

Part and Inventory Search

Back
Top