Good day everyone
I am design a report for the BO.EmployeePackage.
BO.InvoicePackage -> BO.InvoicePayment (Payment for the Invoice) -> BO.EmployeePackage (Each Payment Select the Employee Name (to track the commission).
In the BO.EmployeePackage, I have the ShortCut for GrossAmount as "EmployeePackage.MyInvoicePackageID.GrossAmount", there is no problem to show on the query.
REPORT DESIGN
In the Report, I Group by Employee Name and I want the Employee Group Footer showed the Sum of each amount.
Now In the detail row, I have this attribute:
If I use the attribute called "EmployeePackage.GrossAmount, the report result of the Gross Amount showed only XX.0 (1 decimal point only). I think this is the bug here. As the BO.InvoicePackage.Gross Amount already set as 2 Decimal Points.
Now I use "EmployeePackage.MyInvoicePackageID.GrossAmount", it showed correct on the Report now with 2 decimal point.
But I want to to the Sum of this Field. The Report Design give me error -"SUM EmployeePackage.MyInvoicePackageID.GrossAmount" -
Error: "Syntax Error at token ","
Both way has the error. What should I do now???
I need to showed the Total Amount for the GrossAmount, TaxAmount, Net Amount. All these attribute is from the InvoicePackage.
Please help...
