z report xml problem

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?

Reply to
NcS
Loading thread data ...

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

Reply to
Glenn Adams [MVP - Retail Mgmt]

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:

Reply to
Bradley

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.