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...
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...
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.
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...
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...
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...
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...
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...
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}...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.