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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by slewis66

  1. slewis66

    Help for a beginner please!!

    Finally got there!! Thanks for all your help.
  2. slewis66

    Help for a beginner please!!

    Hi, Well you'll no doubt be pleased to know that I think I've cracked it. I changed the details in Report Options to convert NULL values to default and that seems to have done the trick. Thanks so much for all your help. At the risk of pushing my luck I have one final (hopefully) question -...
  3. slewis66

    Help for a beginner please!!

    Hi, My original cost was a specific field (Total Value at Cost) but I've now replaced this with a formula field that reads:- {@NetValue} if isnull({JOB_COST_TRANSACTION.TOTAL_VALUE_AT_COST}) then 0 else {JOB_COST_TRANSACTION.TOTAL_VALUE_AT_COST} I've also reset the Running Totals so that each...
  4. slewis66

    Help for a beginner please!!

    Hi LB, Firstly, please ignore previous post - I've sorted it. I'm not entirely sure what I've done but whatever it was it worked!! My only remaining problem (I think) is that if there are no line items for a particluar group (For example no materials costs for a particular job ref) the running...
  5. slewis66

    Help for a beginner please!!

    Hi again, Thanks for your reply. I've tried putting in a running total (haven't used this before!) and have it set as follows:- Field to summarize - {@cost} Type of Summary - Sum Evaluate on change of group - {@transaction type} Reset on change of group - {@transaction type} This almost but...
  6. slewis66

    Help for a beginner please!!

    Hi again, I have to admit you've somewhat lost me now - I'm a new to all this Crystal stuff. What I have is GH1 which is a job number based on an existing field GH2 is created by a formula on a field called transaction type, which is as follows ( I left the other possibilites out of my...
  7. slewis66

    Help for a beginner please!!

    Hi LB, Thanks for such a prompt response. I've tried the formula you suggested and it's certainly heading in the right direction. It's including a total against each grouping in GF1 for the actuals, however it is pulling in the figures from the previous GF1 each time, and only changing the GF1...
  8. slewis66

    Help for a beginner please!!

    Hi, Using Crystal v9. I have the follwing already created:- GH1 JobRef GH2 Transaction Type (this is based on a formula) Revenue Invoice 1 £100.00 Invoice 2 £200.00 Total Revenue £300.00 Materials Invoice 9...
See more

Part and Inventory Search

Back
Top