In Projects—>Inquiries---->Invoice ----> invoice Proposal ---->print Preview in this report i need to display the
(1) invoice id , project name, Purchase order for the selected invoice.
(2) details of all the project for that particular invoice(i.e all the projects in hour tab,expense tab…)
(3) i have a column named ‘amounts’ how can i total all the amounts in that column and display it.
(4) is there any possibility to display the total amount in words(i.e if the total amount is 2345 i want to display it as two thousand three hundred and forty five)
But Kranthi in ProjInvoice , when you run the report,it does not display the ProjInvoiceId by default. and i have written a display method for “ProjName” if((ProjInvoiceJour.ProjInvoiceId == ProjInvoiceOnAcc.ProjInvoiceId) && (ProjInvoiceJour.ProjInvoiceProjId == ProjTable.ProjId)) { Name = ProjTable::name(ProjInvoiceOnAcc.ProjId); } return Name; But i’m not getting the corresponding ProjName