Output a Department Name to Variable in x/z report.


B

BrentWhiting

I need to pull a department out of the report.departmentname &
report.department.sales lists on the x/z receipt. The previous POS system
that I had seperated my paid in gift certificates on the x/z receipts.

What I want to do...
<FOR each = "ReportDepartment">
<IF>
<CONDITION> Report.Department.Name <> Gift Certificates </CONDITION>
<THEN>

I'm pretty sure that the expression must be numeric to pass within an
IF-Condition situation. I would prefer not to have to use the department ID
for this to work.

Any help would be greatly appreciated
 
Ad

Advertisements

B

BrentWhiting

sorry... to clarify what I really want to do....

<FOR each = "ReportDepartment">
<IF>
<CONDITION> Report.Department.Name = GiftCertificates </CONDITION>
<THEN>
<SET name = "GiftCertTotal" description = "Gift Certificate Sales" type =
"vbCurrency">Report.Department.Sales</SET>

This would allow me to subtract the gift cert sales from the overall
department sales on the x/z.

Brent
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top