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!

  • Congratulations gkittelson 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. bcmom90

    Adding an Excel worksheet to a Crystal report

    We are using Crystal version 9 connecting to an Oracle 9 database. I have created a report which is an actual price quote for a specific product, however, the report requestors wish to see a second page of the report which is text and a picture embedded into an Excel spreadsheet. Does anyone...
  2. bcmom90

    Using Historical data in a new Crystal report

    I am using Crystal 9, Oracle 9.2 database. I have a report based on inventory date transactions which, based on parameter dates for those transactions, gives part quantities. I need to add a column which will give the qty balance forward of each part, in other words, historical data. I have...
  3. bcmom90

    Extracting the Maximum date

    We use Crystal 9 to build reports from an HR database. The database holds multiple records for each employee for every change whether it's an open enrollment selection, job change, supervisor change etc. I need to extract the latest information based on a 'modified date' for our 2006 open...
  4. bcmom90

    Replacing a null date field with another date in a formula

    As I previously stated, I've tried several Date functions. These fields are definitely date-time fields. How would you write this formula? I would appreciate any assistance.
  5. bcmom90

    Replacing a null date field with another date in a formula

    I am using Crystal Reports 9. I have similar fields from 2 different tables.I want to replace any null Dates from the Purc_Order_Line table with the ones from the Purchase_Order table. Here's what I tried: if DateValue ({PURC_ORDER_LINE.DESIRED_RECV_DATE})= DateValue (0,0,0 ) then DateValue...

Part and Inventory Search

Back
Top