petejigsaw
MIS
I have a report which lists stock on display within a group of retail stores.
I have grouped the items based on their product code, so that there is one line for each product code, and used a if/then formula to put either 1 or 0 into the respective columns across the page for each store, to mark if the store has the item on display.
At detail level, I have used a sub-report to show the colour of the item, but when I group the detail records based on product code, I don't know how I can create a field which shows the colours of the items that are included in the group????
Normally, all stores show the same colour of a product, but when they don't, I want to show the colours in the format 'Colour A / Colour B etc.' - I don't need to indicate which store has which colour, just show all colours currently on display within the company.
Can anyone help? I fear that as the colour is drawn from a sub-report this will be difficult!
Thanks in advance.
I have grouped the items based on their product code, so that there is one line for each product code, and used a if/then formula to put either 1 or 0 into the respective columns across the page for each store, to mark if the store has the item on display.
At detail level, I have used a sub-report to show the colour of the item, but when I group the detail records based on product code, I don't know how I can create a field which shows the colours of the items that are included in the group????
Normally, all stores show the same colour of a product, but when they don't, I want to show the colours in the format 'Colour A / Colour B etc.' - I don't need to indicate which store has which colour, just show all colours currently on display within the company.
Can anyone help? I fear that as the colour is drawn from a sub-report this will be difficult!
Thanks in advance.