Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Morning
does anyone know if its possible to automatically hide the empty rows in excel when a report is produced by NPrint?
I.e. NPrint may produce a report with 50 rows of data - i'd like to hide all of the remaining rows as they're blank.
is this possible?
cheers,
Phil.
NPrint 16.5
Qlik 11.2 SR12
Hi Phil,
it is possible.
In the template select all rows under your table tag (ctrl+shift+down arrow) and hide them.
Make sure you have the Expand range checkbox set on your table.
Btw. you can hide the columns the same but there is no expanding of columns so you need to leave as many columns visible as you will get.
BR,
Matus
Hi Phil,
it is possible.
In the template select all rows under your table tag (ctrl+shift+down arrow) and hide them.
Make sure you have the Expand range checkbox set on your table.
Btw. you can hide the columns the same but there is no expanding of columns so you need to leave as many columns visible as you will get.
BR,
Matus
Thanks Matus, Perfect!