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)
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].
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…
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…
@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.
Where to drop fields for Pivot Tables
How to save a pivot table
You need to drop Cantidad, Total, Status into Drop Data Items Here section: Drop MenuItemName, Porcion, Grupo into the Drop Row Fields Here section.
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.
Once you get them dropped correctly you then need to right click the report and choose 