[!Totales por Grupo con TAGS):2,2,2, 1, 1]
>Grupo|Porcion|MenuItemName|[N]Cantidad|[C]Total
{REPORT ORDER DETAILS:O.ItemGroup,O.PortionName,O.MenuItemName,O.Quantity,O.TotalPrice}
which is ok on items but not ok on the Total Price… t should be CERO.
When I had that report done with sql sentences, I had a case to calculate this kind of cases… is there any way to do it here too?
[Tickets por Cliente:2,2,2,2,2,3, 2]
>Ticket|Fecha|Hora|Cliente|Telefono|Puntos|Total
{REPORT TICKET DETAILS:T.TicketNumber,T.Date,T.Time,EN.Customer,EC.Customer.Phone,EC.Customer.Points,T.TotalAmount:(TCET=Customers)}
>Total Ventas||||||${REPORT TICKET TOTAL:(TCET=Customers)}
[Exception Info 1]
Top-level Exception
Type: System.FormatException
Message: Input string was not in a correct format.
Source: mscorlib
Stack Trace: at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal)
at System.Number.ParseInt32(String s, NumberStyles style, NumberFormatInfo info)
at System.Convert.ToInt32(String value)
at Samba.Domain.Models.Tickets.Ticket.<>c__DisplayClassf1.<ContainsEntityType>b__f0(TicketEntity x)
at System.Linq.Enumerable.Any[TSource](IEnumerable`1 source, Func`2 predicate)
at Samba.Domain.Models.Tickets.Ticket.ContainsEntityType(String entityTypeId)
at lambda_method(Closure , TicketData )
at System.Linq.Enumerable.WhereEnumerableIterator`1.MoveNext()
at System.Linq.Enumerable.WhereSelectEnumerableIterator`2.MoveNext()
at System.Linq.Enumerable.Aggregate[TSource,TAccumulate](IEnumerable`1 source, TAccumulate seed, Func`3 func)
at Samba.Addon.CustomReports.Functions.AbstractDetail`2.GetDetails(IEnumerable`1 sourceItems, String configStr)
at Samba.Addon.CustomReports.Functions.TicketFunctions.<RegisterFunctions>b__a(Object x, String d)
at Samba.Services.Implementations.PrinterModule.ValueChangers.FunctionData`1.<>c__DisplayClass1.<GetResult>b__0()
at Samba.Services.Implementations.PrinterModule.ValueChangers.Helper.FormatData(String data, String tag, Func`1 valueFunc)
at Samba.Services.Implementations.PrinterModule.ValueChangers.FunctionData`1.GetResult(T model, String currentData, PrinterTemplate template)
at Samba.Services.Implementations.PrinterModule.ValueChangers.FunctionRegistry.<>c__DisplayClass11e.<ExecuteFunctions>b__11d(String current, FunctionData`1 func)
at System.Linq.Enumerable.Aggregate[TSource,TAccumulate](IEnumerable`1 source, TAccumulate seed, Func`3 func)
at Samba.Services.Implementations.PrinterModule.ValueChangers.FunctionRegistry.ExecuteFunctions(String content, PrinterTemplate printerTemplate)
at Samba.Services.Implementations.PrinterModule.PrinterService.ExecuteFunctions(String printerTemplate)
at Samba.Addon.CustomReports.CustomReportBuilder.<UpdatePrinterTags>b__2(String line)
at System.Linq.Enumerable.WhereSelectListIterator`2.MoveNext()
at System.Linq.Enumerable.<SelectManyIterator>d__14`2.MoveNext()
at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
at Samba.Addon.CustomReports.CustomReportBuilder.UpdatePrinterTags(IEnumerable`1 lines)
at Samba.Addon.CustomReports.CustomReportBuilder.AddRow(String row)
at Samba.Addon.CustomReports.CustomReportBuilder.ProcessLine(String line)
at Samba.Addon.CustomReports.CustomReportBuilder.Build(SimpleReport sp)
at Samba.Addon.CustomReports.CustomReportViewerViewModel.CreateCustomReport(String reportName, SimpleReport simpleReport, Boolean addHeader)
at Samba.Addon.CustomReports.CustomReportViewerViewModel.GetReport()
at Samba.Presentation.Common.Reports.AbstractReport.<RefreshReport>b__2()
EN.<entity type> Entity Name
EC.<entity type>.<field name> Entity Custom Field Value
TS.<state name> Ticket State
TT.<tag group name> Ticket Tag Value
CA.<calculation type name> Calculation Amount
PA.<payment type name> Payment Amount
T.Department Department Name
T.TicketType Ticket Type Name
T.User User Name
T.Date Ticket Date
T.Time Ticket Time
T.Terminal Terminal Name
T.Tax Total Tax Amount
T.TotalAmount Total Amount
T.RemainingAmount Remaining Amount