Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Answered

Electronic reporting excel format (auto hide blanks)

(0) ShareShare
ReportReport
Posted on by 15

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 advancepastedimage1680732427473v1.pngpastedimage1680732430204v2.png

  • RE: Electronic reporting excel format (auto hide blanks)

    the way to fix it is to use this field , any setup in the excel template will not fix it 
    pastedimage1681138218228v1.png 

  • Verified answer
    huijij Profile Picture
    huijij 19,811 on at
    RE: Electronic reporting excel format (auto hide blanks)

    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?

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,391 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans