D
David
I have a daily report that I run on the invoices for that day. Recently I
had to add a CreditCard column in addition to the Cash and Charge column on
the report. When I run the report I have 2 issues - the cash column is blank
and it asks for Enter Parameter on 2 fields.
I have tried putting the calculations in the query and also on the report in
a bound column. When the report pulls from the query, the entire column is
blank. When it calculates it on the report, the columns display correctly,
but it ask for Enter parameter on those 2 columns and they won't sum up on
the bottom.
Here are the calcuations I am having trouble with:
Change: IIf([curAmountReceived]<>0,[curTotalAmount]-[curAmountReceived],0)
CREDIT: IIf([lngTransactionId]=7,[curAmountReceived],0)
CASH: [curAmountReceived]+[Change]-[CreditCard]
I needed to calculate the "change" amount so it would return the exact value
instead of the dollars we received.
When run, it asks for parameter values on Cash and Credit and these are also
the =Sum[Cash] and =Sum[Credit] does not work on.
Any ideas what I am doing wrong?
had to add a CreditCard column in addition to the Cash and Charge column on
the report. When I run the report I have 2 issues - the cash column is blank
and it asks for Enter Parameter on 2 fields.
I have tried putting the calculations in the query and also on the report in
a bound column. When the report pulls from the query, the entire column is
blank. When it calculates it on the report, the columns display correctly,
but it ask for Enter parameter on those 2 columns and they won't sum up on
the bottom.
Here are the calcuations I am having trouble with:
Change: IIf([curAmountReceived]<>0,[curTotalAmount]-[curAmountReceived],0)
CREDIT: IIf([lngTransactionId]=7,[curAmountReceived],0)
CASH: [curAmountReceived]+[Change]-[CreditCard]
I needed to calculate the "change" amount so it would return the exact value
instead of the dollars we received.
When run, it asks for parameter values on Cash and Credit and these are also
the =Sum[Cash] and =Sum[Credit] does not work on.
Any ideas what I am doing wrong?