Items sold by Group

This is a Report that I use in daily basis. This helps me to know what has been sold and can be drilled down from totals by grupo to individual menuItems.

This is the report:

[!Totales por Grupo con TAGS):2,2,2, 1, 1,1]
>Grupo|Porcion|MenuItemName|[N]Cantidad|[C]Total|Status
{REPORT ORDER DETAILS:O.ItemGroup,O.PortionName,O.MenuItemName,O.Quantity,O.Total,OS.GStatus}

This is the configuration file that should be uploaded to the database with database tools:
ItemsxGrupo.zip (1.2 KB)

hope this is usefull!!!

G.

2 Likes

@gerlandog,
Thank you very much I love the reports you make :smiley:

1 Like

@gerlandog

any screen shot? just want to see how it’s looks :slight_smile:

here…
hope this helps!!!


G.

@gerlandog a great effor i was about to do a similar report

this is my first report to customize need your assisstance.

i have tried to edit the template provided above but i get error

like i want to change the title to item sale per group

that is wnat edit template to simple english

how can i do that

you juswt need to change this part Totales por Grupo con TAGS) and put whatever you want there.
This part are the fields titles: Grupo|Porcion|MenuItemName|[N]Cantidad|[C]Total|Status but remember not to change the [N] or [C].

G.

Grupo|Porcion cant be changed to Group|Portion

yes you can, but you have to change those also in the report design. Click with the right mouse button over the report and enter into design mode… ther you can change almose anything…

be carfeull to save changes.

G.

ok thanks was quite helpful

1 Like

still facing problem
did following changes in edit report:

they seem to be reflected in design mode



but still not working any assisstance

thanks

exactly what is still not working?

G.

i am getting this

that is becuase you changed field names, so you will have to drag fields again to theyre posititon in order to obtain again the report…
just drag the three first to the part where says DROP ROW FIELDS then drop the rest to the area where it says DROP COLUMN FIELDS HERE. After that you will see your report. Remember to save it. After that enter into DESIGN MODE and you can change things…

G

i have tried but still unable to do it

@madiha There are several things missing from this that are just understood if you had read the Custom Reports tutorials. @gerlandog is posting these in this forum category with the understanding that you have read and understand how to use custom reports. These are reports built for you so you can get ideas or simply copy them for ease. You must read and understand how to use custom reports before any of the reports listed in this forum category will make sense to you.

  1. Where to drop fields for Pivot Tables
  2. How to save a pivot table
  1. You need to drop Cantidad, Total, Status into Drop Data Items Here section: Drop MenuItemName, Porcion, Grupo into the Drop Row Fields Here section.
  1. :warning: Once you get them dropped correctly you then need to right click the report and choose save changes

Finally Design mode can be used to format the look to get rid of the headers. This can be found here.

yes u are right i went through the tutorial and got it right

one thing still left how to adjust the height?

[!Totales por Grupo con TAGS:2,2,2, 1, 1,1:450] Set 450 to whatever height you want.

i was just about to try that :slight_smile:

what do i need to set in print templates under design mode in order to print the report