SLQ or Report??

Hi there,

Retail Analytics from Professional Advantage will enable you to easily report on any information that is populated in RMS.

Retail Analytics for Microsoft RMS is designed to help retailers manage their business by delivering analytical reporting on business performance. Easily identify trends, buying patterns, seasonality, and other key performance indicators for your business.

If you have any questions, please let me know.

Thanks,

Jen Bridgeford snipped-for-privacy@profad.com

701 235 2363 ext 248 For a quick dem> I need to create a list of items for the till staff of what items are

Thanks for your post Akber,

I understand the sale price reporting via sale dates - and i do use it. I have however not been able to find a report which would show me the following:

Discounts set up via the mix and match and the buy X and get Y for Z promotions under the Discounts menu in Database - I have 50 or 60 different named promotions set up - I then assign the item to the promotion in the item properties.

What i wanted was a report which would summarise which items are assigned to each promotion type, so i can keep an eye on it all in one place.

Hope that makes better sense!

Philip

Hi Philip - it might be easier to use a select statement

Backup first and after hours try

select item.itemlookupcode, item.description, quantitydiscount.description AS Discount_Description from item, quantitydiscount where item.quantitydiscountid = quantitydiscount.id and item.quantitydiscountid 0

Then export the results to excel or notepad. The above query will return three columns: the ILC, item descripti> Thanks for your post Akber,

Perfect!!! exactly what i needed. Thanks v much!