14 Replies Latest reply: Nov 12, 2015 6:01 PM by Bill Markham RSS

    Access to hidden tabs?

    Mark Gertgen

      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

        • Re: Access to hidden tabs?
          Mark Little

          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

          • Re: Access to hidden tabs?
            Prem Kumar Thangallapally

            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 )

            • Re: Access to hidden tabs?
              Adam Krepistman

              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

              • Re: Access to hidden tabs?
                Mark Gertgen

                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

                  • Re: Access to hidden tabs?
                    Mark Gertgen

                    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

                      • Re: Access to hidden tabs?
                        Aaron Morgan

                        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?

                        • Re: Access to hidden tabs?
                          Daniel Jenkins

                          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.

                      • Re: Access to hidden tabs?
                        Yury Tomachinskiy

                        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

                        • Re: Access to hidden tabs?
                          Mark Gertgen

                          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