Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
magertgen
Contributor III
Contributor III

Access to hidden tabs?

Hi all, I'm using NPrinting to generate some reports.  I have a tab I created that I want to use for the report.  (Use the sheet object as an image.)  I can do this, but I'd like to hide the report tab from regular users.  Is there a way to access hidden tabs in NPrinting?

I used a variable to conditionally hide the tabs, so I thought I could use a filter to change the variable and unhide the tabs while NPrinting was generating the report.  I was able to create the filter, but it doesn't appear to unhide the tabs and make them available.  (The report generates without error, but it's empty.)

Any thoughts or ides?

Thanks in advance,

~Mark

14 Replies
Daniel_Jenkins
Specialist III
Specialist III

Hi Mark,

This is expected behavior and works as designed. Objects on a sheet used in an NPrinting report template can be subsequently hidden and NPrinting will still render them. However, when an entire sheet is used as an image, it should not be subsequently hidden if you want NPrinting to render it.

HTH - Daniel.

magertgen
Contributor III
Contributor III
Author

Hey all, sorry for the late response, I've been on other tasks.

After doing some testing, I've realized what my hidden issue is.  If I create a sheet, put objects on it, use Nprint then hide the sheet it works as everyone says it should.  What I'm trying to do is reference the sheet itself.  I have a ton of nested text boxes that I don't want to have to try and recreate in excel.  So I made a sheet that has a print friendly layout with all my nested text boxes.  I add the sheet itself as an image (SH05) to an NPrinting report, then I hide the sheet.  Once the actual sheet is hidden, it's no longer available to NPrinting.

I wish I could merge or flatten my nested boxes into one object, but there doesn't seem to be a way to do that.

At this point I don't know what else to do, so we may have to have two versions of the app, one for users with the tabs hidden and one for NPrinting, both of which will have to be refreshed on their own.  I was hoping I could have just one app, but it may not be possible.

~Mark

bill_markham
Champion III
Champion III

You could use the OSUser() function for the conditional hide/show, only showing it for the NPrinting User and maybe yourself.

magertgen
Contributor III
Contributor III
Author

Daniel, I didn't see your response, but you confirmed what I discovered through trial and error.  Thanks!

Bill, I think you're on to something!  I tried to unhide the sheet using a filter in NPrinting but it never worked.  I'll see if I can do it you way.  Thanks!

~Mark

bill_markham
Champion III
Champion III

Mark, I do it that way myself and it works fine.