1. Home
  2. Point-Of-Sale Software
  3. Modifying Z Report

Modifying Z Report

One of our staff members has probably been a bit too enthusiastic in regard to the Departments (I don't really mind) but it results in this huge Z-report (bit wasteful on each till, everyday) I know I could remove all the departments off the Z-report by removing the Department totals section, but the thing is I want the figure from just one department.

I've tried adding the following

Report.Department.Name Photographics

Report.Department.Name "|" Report.Department.Sales "|" Report.Department.PercentageSales

but get the following error in IE

A name was started with an invalid character. Error processing resource 'file:///C:/Program Files/Microsoft Retail Manageme...

Report.Department.Name Baby

-----------------------------------------^ ss="t">ROW>"Paid on Layaway|" Report.LayawayPaid

Any advice?

Cheers

Reply to
jetspeed
Loading thread data ...

It's infuriating, but the stupid receipt template language will only compare numeric values...

Open SO Administrator and connect to the database (File/Connect). Open a query window (Query/New) and enter the following command:

Select * from Department where [Name] = 'Photographics'

Run the Query (Query/Execute).

This will show you the Numeric ID of the department.

Try the condition: Report.Department.ID = X Where X is the ID found above...

Glenn Adams Tiber Creek C> One of our staff members has probably been a bit too enthusiastic in regard

Reply to
Glenn Adams [MVP - Retail Mgmt]

Thanks for that Glenn, much appreciated.

I had a go at adding it in, but my xml skills are non-existent I don't get any errors when viewing in explorer, but when performing the z-report, get an error "Compile Error: Token 'Report.Department.ID' was not found."

I've attached the xml, in case I'm doing something really stupid

Cheers

"Glenn Adams [MVP - Retail Mgmt]" wrote in message news: snipped-for-privacy@TK2MSFTNGP15.phx.gbl...

begin 666 Zreport.xml M__X\`#\`> !M`&P`( !V`&4`0!P`&4`/0`B`'8`8@!,`&\`;@!G`"(`/@`@`" `( `@`" `- `S`#

Reply to
jetspeed

That is because Report.Department.ID is not a valid variable. Below are the only valid Department variables you can use in your Z report: Report.Department.Name These values apply to the department indicated by the specified key value for X and Z reports.

Report.Department.Sales

Report.Department.PercentageSales

Rob

Reply to
Rob

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.