
Hello Dynamics Community,
I'm creating an invoice project report using Eletronic Reporting. My client wants a format completely differents compare to the Microsoft Invoice Project Model.
When the report is generated the Microsoft Project Invoice Model (Excel) is hiding the fields that aren't filled.
Let me explain more in details :
There are multiples transaction categories within a project, for example Items, Revenue, On-account, Hours, Cost... If I generate a project Invoice proposal with ONLY Item Transactions, the other transaction category fields are hidden in the format generated. We don't see the Revenues, On account, Cost and Hours placeholder. I couldn't succeeded to do the same with my own report, as we see the other project transaction categories even if there's no data inside.
Moreover, there are mutliple Project Invoice Proposal types, depending on the details you want to put on it. You can choose a Summary Invoice, a detailed Invoice, or a summary Invoice by category. When I use the ER Microsoft Excel Format, the Report generated is changing depending on the invoice type I chose. When I generate the Report I made myself the report generated is exactly the same. The report doesn't change depending on the Invoice Type I chose. Which formula should I put to generated different reports from the same model format depending on the Project Invoice Type ?
Thank you in advance, you would be very helpful