Search results for query: *

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

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

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

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

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

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

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