Announcements
No record found.
Hello experts
i have created an ER invoice and it works great however the generated electronic report still show all lines , even the empty once , meanwhile i have some other electronic reports automatically hide the empty rows , i tried the VBA of excel on the template of the ER report but it doesn't really work , just wanna know where is the setup of hiding empty rows in these ranges , see screenshots
thanks in advance
Hi Ahmed,
What do you mean as you said it doesn't really work? Do the macros in the Excel template operation fit your requirements? Did you try the event macro triggered by a change in values for a cell within a worksheet. Does this make sense?
the way to fix it is to use this field , any setup in the excel template will not fix it
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.
Congratulations to our 2026 Super Stars!
We are thrilled to have these Champions in our Community!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Giorgio Bonacorsi 608
André Arnaud de Cal... 591 Super User 2026 Season 1
CP04-islander 430
