Skip to main content
Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
cbaqir
Specialist II
Specialist II

Nprinting 16: Remove Blank Pages (Excel)

I am still stuck on this requirement and need some help...no luck so far.

My NSQ creates an Excel doc with paging by REQUEST_REGION. Each tab contains 2 charts, an image and some random text.

My requirement is to remove the tab if CH229 is empty.I've played with conditional formatting and variables but I cannot get it to work.

I've been working on this for 2 weeks and cannot make it work.

Here's an example of a tab that I want removed (Arizona) because CH229 is blank:

8-2-2017 8-38-30 AM.jpg

8-2-2017 8-36-55 AM.jpg

TIA!

10 Replies
Andrea_Ghirardello

It's correct as it is.

Try to run a preview.

You should see the page multiple times, replicated as many times as the number of rows of the CH428, with the value as tab name.

Does it happen?

Br.