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: 
Lauri
Specialist
Specialist

Filter out Excel tab with paging when zero rows

I have an Excel template with two tabs, and each tab uses paging on field "PCLoc". Each tab displays some text and data from one straight table in QS. Is it possible to tell NPRinting to NOT generate a tab for a value of PCLoc when it has zero rows in the table? 

The template looks like this:

Lauri_0-1650298724097.png

 

Labels (2)
1 Solution

Accepted Solutions
Lech_Miszkiewicz
Partner Ambassador/MVP
Partner Ambassador/MVP

The easiest approach is to use "Advanced Search" filter on the [PCLoc] field. You can create filters which will check if there are existing records like:

  • Count(Distinct [Acct#]) >0 

Or if there is a measure use measure to filter only existing values. 

More about advanced search filters here:

cheers

Lech

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.

View solution in original post

1 Reply
Lech_Miszkiewicz
Partner Ambassador/MVP
Partner Ambassador/MVP

The easiest approach is to use "Advanced Search" filter on the [PCLoc] field. You can create filters which will check if there are existing records like:

  • Count(Distinct [Acct#]) >0 

Or if there is a measure use measure to filter only existing values. 

More about advanced search filters here:

cheers

Lech

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.