z report xml problem

Dec 08, 2006 3 Replies

I'm trying to add a total of just the 'credit-card' tenders and seem to have a problem with the 'condition' in my 'IF' statements. All three different If's are 'true' but should not be! see xml below. I think there must be something I'm not aware of.



........Variable Declarations "VISAMC" "AMEX" "DISCOVER" ........some code between.....



Report.Tender.TenderType = tenderCreditCard



CC1_Name =Report.Tender.Description Report.Tender.ShiftTotal


CC2_Name = Report.Tender.Description Report.Tender.ShiftTotal


CC3_Name = Report.Tender.Description Report.Tender.ShiftTotal


Why would all three : CC1_Name =Report.Tender.Description ,CC2_Name =Report.Tender.Description, CC3_Name =Report.Tender.Description be TRUE?


You can't do text comparisons - only numeric.

Glenn Adams Tiber Creek C> I'm trying to add a total of just the 'credit-card' tenders and seem to have

Maybe there is a way to include a custom SQL command that can be mixed with the data in the data in the report to assemble the WHERE clause?

If you figure out something like that, I'd love to know how also...

Bradley

"NcS" wrote:

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required