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 Wanet Telecoms Ltd 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: *

  • Users: TGHaddon
  • Content: Threads
  • Order by date
  1. TGHaddon

    Displaying part of the record selection criteria

    Using Crystal Reports 8.5. I want to display the date range that is used in a report at the bottom of the page. I have found the special function that displays the record selection criteria formula but this is no use to me as I want to show just one of the criteria that is set rather than all...
  2. TGHaddon

    Getpivotdata function Excel 2002

    I have a problem with the use of the getpivotdata function in a spreadsheet I've just created. =GETPIVOTDATA("Sum of DOZENS",Pivot!$A$3,"REP",B11,"SUPPLIER",$A$6) For the most part it's working fine, using the cell references to retrieve the data I need on another sheet. However I've now run...
  3. TGHaddon

    Problem with Excel Export / VLookup Formula

    Not sure if this is a Crystal or and Excel problem. Essentially I have been asked to populate someone elses spreadsheet with some data I can get via an existing Crystal report. To do this I have exported the report to an Excel file and then created VLookup formulas in the existing spreadsheet...
  4. TGHaddon

    Combining Related Codes

    I am using Crystal Reports 8.5. I am writing reports to analyse sales of wines generally using their bin number to sort/group. Each product has a unique first 5 digits 12345 then the next three digits are the vintage e.g. 01 and a letter/number related to the case/bottle size 1 / A. Can...
  5. TGHaddon

    Getting the correct data from two similar tables

    My company has recently moved to a new set of computer systems and is using Crystal Reports 8.5 to generate reports. I am trying to build reports that show sales by Rep, Customer, Product, Supplier etc. I have managed to build basic reports to do this but have another problem. The computer...

Part and Inventory Search

Back
Top