Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Not sure on the Nprinting Side, one option in QlikView could be to hide the tab row and then use buttons for the users to navigate the tabs you want them to see?
Mark
make one inline filed , and trigger the variable whenever some field value is selected in the inline field,
on nprinting execution , filter that filed value accordingly(which leads show/unshow hidden tab/object )
I use hidden tabs all of the time when I have objects that I need just for reporting and do not want users to see. The trick is to palce the objects on the tab you want to hide, build your NPrinting report accessing those objects and then hide the tab. If the tab is hidden at the time you are building your tempalte, you will not see the objects, but once the template has the object, the tab can be hidden and the report will work
Thanks for the replies! It's funny, I tried Adams idea yesterday because I assume that would work. Even if the objects were hidden they would be in the doc and accessible. The task completed without error but the PDF was blank. I tried again today and now it appears to be working. Not sure what to make of that, I guess I had something misconfigured.
Thanks again,
~Mark
Well, I spoke too soon. It worked once, now I get an empty PDF no matter what I do. (Unless I unhide the tabs, then everything works great.)
I tried my filter again, but this time I put it on the task, not the report. Then I left it on both, but empty PDF.
I guess I can have two QVWs, one with the tabs and one without. I admit I'm reasonably disappointed.
Thanks for the ideas. If anyone else has any ideas please let me know. (We're using NPrinting 16.2.0 and QV 11.2 SR10.)
~Mark
Hi Mark,
Much like Adam, as long as I've unhidden the tab on creation of the objects, it doesn't seem to matter if it's hidden when generating the reports, however I've only used this for HTML and Excel reports, so maybe it's a particular issue with PDF generation?
I've always found it weird that you need to unhide on first access but it doesn't thereafter.
Wonder if fsv could shed any light?
NPrinting builds a permanent 'bridge', if you will, to any visible QV object when accessed and then added as an object to any of the NP template editors.
Once this 'bridge' or link has been made, then NPrinting can continue to use it. When this bridge/link is created, NP can continue to use the object even if it is subsequently hidden. But it must be 'seen' / 'visible' first before the bridge/link can be made.
Thanks for the clarity - assume this means Mark must have a separate issue?
Hi Mark,
Try this
1. Create a hidden tab with objects you want to NPrint
2. Create a variable which will hide/unhide the tab
3. Make the tab visible temporary and save the app
4. Create a nprinting source based on that app (it will read all objects now, because you tab is not hidden)
5. Create a filter which changes your variable and unhide the tab
6. Add objects from your tab to a template
7. Open the qv app, hide your tab
8. Run NPrinting task
I hope it helps.It worked for me.
Cheers,
Yury