Electronic reporting excel format (auto hide blanks)

(0) Share

Report

Posted on by Ahmed Ragab Hassan

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

All responses (2)

Answers (1)

Ahmed Ragab Hassan 15 on at

Like (1)

Report

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
Verified answer

huijij 19,811 on at

Like (0)

Report

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?