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 bkrike 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: stoopers
  • Content: Threads
  • Order by date
  1. stoopers

    Allocate costs from 1 group level to another

    Can you allocate costs from group level to another? I am creating a margin analysis report where I am combining revenue and cost data by cust code, warehouse, and order#. I currently have the following groups: Customer Code Warehouse Order # I need to allocate costs summarized at the...
  2. stoopers

    Number to string conversion

    How can I convert a 10-digit order number to a 6 digit string? The 10-digit number startswith 4-6 zeroes and ends with the order #. (ie. 0000040000 or 000094451 or 0000009499). We need to access the last 6 digits - but need to eliminate all zeroes (ie. order #= 40000, or 94451, or 9499)...
  3. stoopers

    Linking Budget and Actual data

    What is the best way to link Budget and Actual data? Using Crystal 11 Actual data is coming from Iscala; table/view in Crystal Budget data is coming from Access DB. Customer code is common field between the 2 tables. Budget data may contain new customer codes that will not appear in...
  4. stoopers

    Subreport data used in formula

    I am using Crystal 11.0 and iScala 2.02 (financial system) and an external access DB. I have created a report in Crystal using project information from the iscala system to get total rev and expenses by project: Project number account number dept number amount transaction date From the access...
  5. stoopers

    Linking tables based upon formula result

    I am attempting to write a report to categorize our revenue data. I have 2 tables: Revenue Data & Customer File, which are linked by the Customer Code. Revenue Data: Customer Code Transaction Text (Customer Code + Invoice#) Invoice# Amount Account Dept Customer File: Customer Code Customer...
  6. stoopers

    Linking tables based upon formula result

    Can you link tables based upon a formula result? I have 2 tables: FINA_ALL and AR. I need to link the two tables based upon Invoice #. AR contains the field Invoice#. FINA_ALL has a field TRANS_TEXT which is a combination of the customer code and invoice#. I can extract the invoice# by...
  7. stoopers

    Crystal 7 - Linking Sales Order # from 2 sources

    Using Crystal 7.0 & Scala 5.0. I am combining revenue & cost data into 1 report. I need to combine the details by sales order # and use the customer code from the revenue source. Unfortunately, the data tables are not linked by sales order#. Customer Code SO# ACCT Rev$$ COS...
  8. stoopers

    Subtotals in Crystal

    Formulas for summarizing Dollar amounts by specific month cannot be subtotalled. What would be causing this? I am attemptig to create a report which contains the months for 2005 across the top... Product Sales Jan05 Feb05 Mar05 8263 $100 $100 $100

Part and Inventory Search

Back
Top