topic How to write a batch file for many reports with section access in QlikView https://community.qlik.com/t5/QlikView/How-to-write-a-batch-file-for-many-reports-with-section-access/m-p/245360#M93551 <HTML><HEAD></HEAD><BODY><P>Dear All,</P><P></P><P>Is it possible to create a batch file to reload 10 reports one by one with different username and password (Section Access).</P><P></P><P>I tried for single document with the following, its working fine any idea to write a batch file</P><P></P><P>"C:\Program Files\QlikView\Qv.exe" /r </P><P>"C:\Documents and Settings\Desktop\ Report.qvw"</P><P></P><P>Regards</P><P></P><P>Chris.</P></BODY></HTML> Thu, 13 Oct 2011 10:35:59 GMT 2011-10-13T10:35:59Z How to write a batch file for many reports with section access https://community.qlik.com/t5/QlikView/How-to-write-a-batch-file-for-many-reports-with-section-access/m-p/245360#M93551 <HTML><HEAD></HEAD><BODY><P>Dear All,</P><P></P><P>Is it possible to create a batch file to reload 10 reports one by one with different username and password (Section Access).</P><P></P><P>I tried for single document with the following, its working fine any idea to write a batch file</P><P></P><P>"C:\Program Files\QlikView\Qv.exe" /r </P><P>"C:\Documents and Settings\Desktop\ Report.qvw"</P><P></P><P>Regards</P><P></P><P>Chris.</P></BODY></HTML> Thu, 13 Oct 2011 10:35:59 GMT https://community.qlik.com/t5/QlikView/How-to-write-a-batch-file-for-many-reports-with-section-access/m-p/245360#M93551 2011-10-13T10:35:59Z How to write a batch file for many reports with section access https://community.qlik.com/t5/QlikView/How-to-write-a-batch-file-for-many-reports-with-section-access/m-p/245361#M93552 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Use windows schedular and create a 10 batch files for different QV files.</P><P></P><P>Rgds</P><P>Anand</P></BODY></HTML> Thu, 13 Oct 2011 10:40:00 GMT https://community.qlik.com/t5/QlikView/How-to-write-a-batch-file-for-many-reports-with-section-access/m-p/245361#M93552 its_anandrjs 2011-10-13T10:40:00Z How to write a batch file for many reports with section access https://community.qlik.com/t5/QlikView/How-to-write-a-batch-file-for-many-reports-with-section-access/m-p/245362#M93553 <HTML><HEAD></HEAD><BODY><P> Hello Anand,</P><P></P><P>its really a nice idea but I would like to create a single batch file using section access.</P><P></P><P>any sample codes please</P><P></P><P>Regards</P><P></P><P>Chriss</P></BODY></HTML> Thu, 13 Oct 2011 10:46:30 GMT https://community.qlik.com/t5/QlikView/How-to-write-a-batch-file-for-many-reports-with-section-access/m-p/245362#M93553 2011-10-13T10:46:30Z How to write a batch file for many reports with section access https://community.qlik.com/t5/QlikView/How-to-write-a-batch-file-for-many-reports-with-section-access/m-p/245363#M93554 <HTML><HEAD></HEAD><BODY><P>Hi Chris,</P><P></P><P>You cannot "send" parameters in command line userid or password to section access, but you can use the NTNAME field in section access (DOMAIN\USERNAME) with the user running the batch file, so the reload will save only data corresponding to this user. There is no parameter for user and password in section access from command line (and it makes sense from the security point of view)</P><P></P><P>So you will need 10 lines in your batch with 10 different documents with different values for the reduction field corresponding to the running NTNAME (or 10 different lines in one batch file running 10 different files), or run the same batch 10 times specifying different users in the Windows Scheduler.</P><P></P><P>Hope that helps.</P><P></P><P><A _jive_internal="true" href="https://community.qlik.com/people/mabaeyens" style="font-size: 12px; outline-style: none; padding-top: 1px; padding-bottom: 1px; padding-left: 17px; color: #007fc0; zoom: 1; background-position: no-repeat no-repeat;">Miguel Angel Baeyens</A></P><P>BI Consultant</P><P><A class="jive-link-external-small" href="http://www.grupocomex.com/" style="font-size: 12px; outline-style: none; color: #007fc0;">Comex Grupo Ibérica</A></P></BODY></HTML> Thu, 13 Oct 2011 11:44:40 GMT https://community.qlik.com/t5/QlikView/How-to-write-a-batch-file-for-many-reports-with-section-access/m-p/245363#M93554 Miguel_Angel_Baeyens 2011-10-13T11:44:40Z How to write a batch file for many reports with section access https://community.qlik.com/t5/QlikView/How-to-write-a-batch-file-for-many-reports-with-section-access/m-p/245364#M93555 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I think it is not possible with the credentials you may run 10 batch files and provide windows scheduler for that batch and run one by one by schedular and use different credentails for the batch files.</P><P></P><P>Hope this may help you.</P><P></P><P>Rgds</P><P>Anand</P></BODY></HTML> Thu, 13 Oct 2011 11:50:39 GMT https://community.qlik.com/t5/QlikView/How-to-write-a-batch-file-for-many-reports-with-section-access/m-p/245364#M93555 its_anandrjs 2011-10-13T11:50:39Z How to write a batch file for many reports with section access https://community.qlik.com/t5/QlikView/How-to-write-a-batch-file-for-many-reports-with-section-access/m-p/245365#M93556 <HTML><HEAD></HEAD><BODY><P> Dear All,</P><P></P><P>Thanks a lot, I will try it from myend.</P><P></P><P>Regards</P><P></P><P>Chriss</P></BODY></HTML> Thu, 13 Oct 2011 12:24:06 GMT https://community.qlik.com/t5/QlikView/How-to-write-a-batch-file-for-many-reports-with-section-access/m-p/245365#M93556 2011-10-13T12:24:06Z