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 Mike Lewis 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. ksnielsen

    Hello- I have an invoice report.

    I got it. All is working and beautiful! Thank you both for helping me. It is greatly appreciated. Karen
  2. ksnielsen

    Hello- I have an invoice report.

    Ok, I started over following the instructions from Mike and not it works. Thanks for helping me know how to trouble shoot the problem Ian. That helped me know that the subreport was wrong. Now my report is going to a new page after the heading fields. The whole report would easily fit on one...
  3. ksnielsen

    Hello- I have an invoice report.

    This is what I have in my subreport. RHb - nothing Details ?Pm-@Invoice Number (to pass the invoice number to subreport) Amount-Deposit-Applied (This is the field that needs to be summarized. RFa @PostageSum This is the formula: WhilePrintingRecords; Shared NumberVar...
  4. ksnielsen

    Hello- I have an invoice report.

    IanWaterman- I created another section under Group Header 1 and the value is still "-" or zero. GH1a Reset Postage to 0 GH1b SubReport GH1c DisplayPostage If I go to the subreport the value is correct, but it isn't coming back to the main report through the DisplayPostage formula field.
  5. ksnielsen

    Hello- I have an invoice report.

    Thanks for you persistence Mike. I made the suggestions you recommended however I still get zero as the return value. RH PHa PHb PHc PHd PHe PHf GH1a - resent postage to 0 GH1b - subreport GH2 GH3 Details GF3 GF2a Just to be sure, in your previous post, you stated: "The NumberVar...
  6. ksnielsen

    Hello- I have an invoice report.

    Mike- I have tried moving the reset formula and the final total formula to every section of the report and it is always zero. Do you think it is a problem to have the final total formula based on another formula in the subreport. PostageDeposits: IF {CashRecDetail.Postage-Deposit} = True THEN...
  7. ksnielsen

    Hello- I have an invoice report.

    Thank you Mike. Your explanation really helped to make it more clear to me. It isn't working completely for me yet. The first formula setting the NumberVar PostageInvoice:=0 is working. The NumberVar PostageInvoice in the subreport is working. It is calculating the correct total. However, I...
  8. ksnielsen

    Hello- I have an invoice report.

    Hello- I have an invoice report. I need to calculate postage deposits to display on the invoice. I cannot include the tables needed to calculate postage deposits in the main invoice report so I think I need a subreport. I have added a subreport but I cannon figure out how to get the...
  9. ksnielsen

    Sum one field based on value in another field

    Thank you for the quick responses. I had to use MCuthill's method. When I tried jcrawford08's method I got a different error. I think I need to have this in a subreport so I am trying to figure that out now. If I like the tables in the main report the way I need them to get the correct...
  10. ksnielsen

    Sum one field based on value in another field

    Hello- I am using Crystal Reports XI. I need to total the deposits for an invoice when field "Postage Deposit" is True. I was trying to use the Sum(fld, condFld, cond) function but it errors. This is what I entered: Sum ({CashRecDetail.Amount-Deposit-Applied}, {CashRecDetail.Postage-Deposit}...

Part and Inventory Search

Back
Top