web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Supply chain | Supply Chain Management, Commerce
Unanswered

Electronic Reportings (ER) - Hide empty fields in a report

(0) ShareShare
ReportReport
Posted on by 20

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  

I have the same question (0)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Supply chain | Supply Chain Management, Commerce

#1
Laurens vd Tang Profile Picture

Laurens vd Tang 271 Super User 2025 Season 2

#2
Siv Sagar Profile Picture

Siv Sagar 171 Super User 2025 Season 2

#3
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 130 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans