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

    Suppress printing only on some groups

    Using CR 8.5 I have a report with several groups: Accounting_Period, Sub-Account, Account, and Customer_Type. Accounting_Period and Sub-Account are hidden. For presentation purposes, the report needs to show Accounts within Customer_Type for the first two Customer_Types but hide the Accounts...
  2. kthacher

    Many to One

    Using Crystal 8.5 I'm attempting to get rid of some running totals (per a previous thread). I have two tables, Revenue and Budget. The report is to show total Revenue $, total Budget $, and variance for each account/sub-account combination. The problem is that there are many revenue records per...
  3. kthacher

    Record selection for not exact match

    Using CR8, I am reporting sales in $ and units, then calculating an average sales price. Each sales account represents a class of customers--residential, commercial, etc. There are sub-accounts within the $ sales accounts that represent various types of revenue--accruals for unbilled...
  4. kthacher

    Subreport data to Main Report

    Using CR 8.5 I have created two subreports. One has Account Numbers and Actual Amounts from our Lawson software database. The other has Account Numbers and Budget Amounts from an Access database. Now I want the main report to show Account Number, Actual, Budget,and Variance by obtaining all...
  5. kthacher

    Subreport Location

    I have a simple report comparing actuals to budget and calculating the variance between the two. The budget is in an Access database which I could not get to link to the main database (Lawson Software). I kept getting an error: Invalid File Link-Not all fields in same index expression. This...
  6. kthacher

    Group total and single record

    I have a report capturing transactions by account (many transactions per account). The group footer is a subtotal by account. I want to compare each subtotal to the budget for the account. The budget is in a different database file and has only one record per account. If I put the budget in...

Part and Inventory Search

Back
Top