Report Templates - Employee Report need to add a new Tracking Group

[poisonshift]

I am trying to add some things to the current Employee shift report but I can't seem to find the exact template that is being used. I figured I could back track it through the Touch Screen designer, got a couple steps then lost the trail.

Then I opened the Configurator and selected Reports, then Autosequences. I found the template name but I can't find which template folder it is in.

Please help. 3700

 

[DrZogg]

Hi,
Lets take it back one step: Do you have crystal reports to add your tracking group changes to the Version 7 for 3.2 and Version 9 for 4...
If you are familiar with this then we can look at the Micros part.

 

[poisonshift]

I have Crystal Reports yes. I have the ability to edit, create and save templates.

 

[DrZogg]

ok.

To enable the Db navigator for Tracking Totals go to DBISQL.

u=custom p=custom

Enter this SQL:
update micros.trk_grp_def
set ob_grp_in_use = 'F'
where trk_grp_seq = 1

This is if 1 is the tracking group number.

Add your new tracking total here, then add them to the report.
Make sure it is a custom report (modified system report) and do not modify system reports as this stops upgrade patches running.

You should create a \custom directory for your custom reports, i.e.
c:\program files\micros\res\pos\reports\custom
or
%resrootdir%\reports\custom

The easiest way to add this is by copying the REPORT TEMPLATE (as it has the correct Report Class) and then PASTE it above 10000 (System only reports below 10000)

Then go through to the Autosequences, autosequence steps and add them with parameters. The parameters sent are controlled by the REPORT CLASS, so your job will be easier if you copy the system one, paste it and modify the path, then rewrite it.

 

[poisonshift]

I execute and I get an error somewhere along the lines of "Line F is an invalid column" something to do with the F value.

To be completely honest I have no experience using the ISQL. I do have experience in various other coding but this is all new to me. If you could spare an more indepth set of instructions I would appreciate it.

 

[MikeRose]

If you do not have single quotes around the 'F', Sybase will think you are trying to look for a column nameed F. Make sure you have single quotes.

 

[poisonshift]

Okay. I'll give it another shot.

But how do I find the right template that is in use? Or do the changes take effect when I execute the code?