Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Modifying a Custom Report 1

Status
Not open for further replies.

GreekBeak

Programmer
Aug 20, 2011
32
US
I've only started messing with Micros recently so be kind when you reply to my question(s)!

On the system I'm testing with there is a custom report called "Revenue Center".

I've got Crystal Reports installed (this is a Micros rev. 2.6) and when I open this report and go to log on the server it starts with the user name of Micros. Since I don't know the password for this user (is this a standard user and a password I should know?). I change the user to custom/custom and log on.

So I started by looking at "Show SQL Query" where I find the following:

{call micros.sp_R_cons_rvc_ttls}

I open up Sybase Central and I find that procedure (actually listed 7 times for 7 different "Creators" but they basically all call the Micros creator procedure).

This is quite a detailed procedure and I see from the documentation that this procedure "Consolidates totals for a range
of business days and returns a result set." which makes sense because this is what is used to record daily sales.

The report breaks down the discounts used but when I search the procedure I don't see any reference to the dsvc_def table which holds the discount information. The report has a section that lists all the discounts and amounts and as an example one of the discount names is sp_R_cons_rvc_ttls.ttl_name_15. How would I know that the discounts start with 15? Is that buried somewhere in that procedure that I didn't see?

I added some new discounts (using the POS Configurator) and I can see them in the dsvc_def table but they didn't show up on the report but some other discounts with 0 totals do.

Looks like I'm missing something once again!

 
I've been poking around and tracking certain fields and reports and it seems that this report I'm working with is basically RVC_102.RPT.

From what I can tell from the procedure, the totals that are shown in the middle of the report page come from trk_ttl_def_temp. The changes/additions I made to the discounts using POS Configurator are not showing up in this table. I added 2 new discounts and renamed an existing one. The report still shows the old discount name which matches the last record in trk_ttl_def_temp table. I can't seem to find any reference to this table to determine how records are added.

Perhaps there is something that runs automatically at night or something is not happening because I am in Demo mode (BTW is there a way around that on your development machine?).

I'm hoping someone can chime in here and give me some clues.
 
Very complex situation here. Tracking totals in Demo Mode goto year 2015. Link your tenders and thinks you want tracked to the Tracking Totals. Its the tracking Totals you pull reports from (serving period, cashier, revenue centre etc)
 
I did notice that transactions I make while in Demo mode get posted in year 2015 but even if I run the report for 2015 I'm not seeing the new discounts shown on the report.

I'm not sure I follow your "Link your tenders and thinks you want tracked to the Tracking Totals"

Do I need to do something different because I'm in Demo Mode? I would have thought that the reports all work the same and I only needed to watch out for the dates that my transactions are posting as.
 
If you look at the report you will see the values from the recordsets used are tracking total name, count and value.
You need to add the new discounts to a tracking total. look a t reports\tracking totals in configurator.
 
OK, got it now, that makes sense now. Is there any limit to how many tracking groups you can make?
 
64 in a tracking group. You can create other tracking groups, but each group has a limit of 64 (1-64).
 
In POS Configurator it's throwing an error saying

"Tracking Group In Use. Cannot edit or insert Tracking Total Records."

whenever I try to edit or add anything in the Tracking Groups through POS Configurator. I went into Micros Control Panel and tried different combinations (BOH, Restaurant Off, ..) but anything I tried wouldn't let me make any changes to the tracking groups.

What's the magic of being able to add tracking groups?
 
update micros.trk_grp_def
set trk_grp_def.ob_grp_in_use = 'F'
where trk_grp_seq = '1'

 
Thanks again! A couple of questions.

His trk_grp_seq was equal to 41 instead of 1, should I be concerned about that?

If you want some discount items to list next to each other there doesn't seem to be an easy way to do that other than to overwrite the contents and start over. I tried to change the numbers of the items and that threw a hard error. I had to delete a couple of records and then I was able to move things around and after I was done I went back and made sure that there were 64 records in that table. Not a big deal but I'm trying to write up detailed instructions for someone and I wanted to be 100% clear in the instructions.

What seems odd to me is that this tracking group is linked to only a single tracking total number. I would have expected that something called group would have been able to hold more than 1 item but in this case every discount I create has to be entered in the tracking group total which seems like a duplication.

Maye you just need to handle that in the actual reports but I was expecting something else I guess. As an example, he has 3 types of post cards that have discounts on them. The system is currently programmed for only 1 card so we are adding in these other 2 cards. I was thinking that we could still track individual card redemption but then create a group called post cards and have that total available.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top