NPrinting 16.0.0, Qlikview 11.2 SR12, Windows Server 2008 R2 Enterprise
Hi, Is there a way to consistently make NPrinting open a qvw to a particular sheet besides the qvw's own OnOpen trigger that NPrinting seems to be sidestepping? This is to help NPrinting open to a lightweight sheet and not risk errors related to the document taking a long time to open or load/calculate stuff on another sheet. More detail below if desired.
Some of my qvws are a bit large and have some tabs that are calculation-intensive to suit certain business needs. In order to help them open faster, I set OnOpen triggers to activate sheet 1 which just has some list boxes so people can narrow selections as desired before moving on to the calculation-intensive tabs. This way if a user wants to see only one client's data aggregated, they can move more quickly, and if they really want the book of business aggregated, they have that option too. NPrinting is one of the 'users' who sometimes needs only one client and sometimes needs the whole book of business aggregated too.
When I run the nprinting job manually, I see the qvw open to the sheet 1, but for some reason NPrinting is jumping out to another sheet in the middle. It's not the sheet with the desired tables, nor the sheet I last worked on, accessed ,or saved, so I'm not sure how/why NPrinting is deciding to hop over to that sheet. This seems to be the sequence:
open to desired sheet 1,
jump to calculation intensive sheet it doesn't need,
--wait a long time,
--sometimes make selection sometimes error out,
export table from a different sheet,
I can avoid the issue by opening the qvw first and waiting for it to load, then running the nprinting job, so guessing that aside from picking the sheet that makes its life harder, nprinting is just trying to move a little too fast for its own good sometimes. (I have another nprinting job that prints 40 reports, consistently messed up report 1, and I made a little cleanup job to re-do report 1 after the other 39 are clear. I chalked that bad report 1 up to nprinting impatience, and other clean reports to qvw being loaded by the time nprinting started those. )
Actually, maybe a way to tell NPrinting to pause for an extra 30 seconds after opening a (large) qlikview might help. But having it stick to my cover sheet tab would be nice too.