Restricting access to a report

[#1]

Hi

I have a report that I have used Section Access and a spreadsheet with usernames and passwords to restrict access. This part of the process works fine in that you need to enter a username and password to open the report in the web browser or the client application. My issue lies in the QMC when my reloads take place. All my reports reload apart from the one that has the security restrictions using Section Access. I have made sure my admin username and password is on the spreadsheet but that still does not make it work. Is there something I have missed?

I have attached a copy of the log file as best I could as I cannot seem to be able to just copy and paste the whole log file.

Thanks

Steve

[#2]

Thank you both. The report has been successfully reloading since last night using the credentials in the spreadsheet.

Thanks again for all your help.

Steve

[awhitfield]

Yippee!

[#4]

Quick question, if I have a report with multiple tabs in the script, which tab do I set the section access in. I'm guessing at the first tab but just wanted to check.

Thanks Steve

[awhitfield]

Correct guess, as the SECTION APPLICATION applies to what follows!

Andy

[Peter_Cammaert]

QlikView best practice is that you put Section Access in the front. Optionally place this dangerous piece of code in a Hidden Script which will always be executed first.

HOWEVER...

no-one prevents you from putting Section Access anywhere in your script. You can even put it at the end, after all tables have been loaded. Section Access and Section Application only delimit an area in the flow of your script. You can put as many of them in your script as you want. The default section at script beginning is Section Application.

You can put a Section Access; statement on the very last script tab, followed by your section access statements, and no-one will complain. Execution will proceed as usual.

Peter

[#7]

Thanks again for all your help. Much appreciated. Steve.