Modifying Z Report

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

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`#

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