https://community.qlik.com/t5/Reporting-Service-Alerting/Nprinting-report-How-to-split-the-records-in-multiple-sheets-in/m-p/1977484#M399 <P>Hi,</P> <P>I suggest you post Qlik NPrinting questions in the related community <A href="https://community.qlik.com/t5/Qlik-NPrinting-Discussions/bd-p/qlik-nprinting-discussions" target="_blank">https://community.qlik.com/t5/Qlik-NPrinting-Discussions/bd-p/qlik-nprinting-discussions</A></P> <P>To create a separate worksheet on the same Excel workbook you can add a field in the Pages node. This will create a different worksheet for each distinct value of the added field. Here there is the explanation for PowerPoint&nbsp;<A href="https://help.qlik.com/en-US/nprinting/May2022/Content/NPrinting/PowerPointReports/Pages-individual.htm?unminified" target="_blank">https://help.qlik.com/en-US/nprinting/May2022/Content/NPrinting/PowerPointReports/Pages-individual.htm?unminified</A>&nbsp;and in Excel, it is the same.</P> <P>To split generated reports into different files you have to use cycles that are explained in details at&nbsp;<A href="https://help.qlik.com/en-US/nprinting/May2022/Content/NPrinting/ReportsDevelopment/Cycling-your-reports.htm" target="_blank">https://help.qlik.com/en-US/nprinting/May2022/Content/NPrinting/ReportsDevelopment/Cycling-your-reports.htm</A></P> <P>Best Regards,</P> <P>Ruggero</P> Tue, 06 Sep 2022 12:12:39 GMT Ruggero_Piccoli 2022-09-06T12:12:39Z https://community.qlik.com/t5/Reporting-Service-Alerting/Nprinting-report-How-to-split-the-records-in-multiple-sheets-in/m-p/1977324#M397 <P>In Nprinting report, can you help</P> <P>- How to split(by 45000 rows) the Qliksense pivot table or table records generate in to multiple sheets in same excel report in Nprinting?</P> <P>- How to split(by 60000 rows) the Qliksense pivot table or table records generate in to multiple sheets in seperate excel files in Nprinting?</P> <P><LI-PRODUCT title="Qlik NPrinting" id="qlikNPrinting"></LI-PRODUCT>&nbsp;</P> Fri, 15 Nov 2024 22:03:09 GMT https://community.qlik.com/t5/Reporting-Service-Alerting/Nprinting-report-How-to-split-the-records-in-multiple-sheets-in/m-p/1977324#M397 sriabt 2024-11-15T22:03:09Z https://community.qlik.com/t5/Reporting-Service-Alerting/Nprinting-report-How-to-split-the-records-in-multiple-sheets-in/m-p/1977484#M399 <P>Hi,</P> <P>I suggest you post Qlik NPrinting questions in the related community <A href="https://community.qlik.com/t5/Qlik-NPrinting-Discussions/bd-p/qlik-nprinting-discussions" target="_blank">https://community.qlik.com/t5/Qlik-NPrinting-Discussions/bd-p/qlik-nprinting-discussions</A></P> <P>To create a separate worksheet on the same Excel workbook you can add a field in the Pages node. This will create a different worksheet for each distinct value of the added field. Here there is the explanation for PowerPoint&nbsp;<A href="https://help.qlik.com/en-US/nprinting/May2022/Content/NPrinting/PowerPointReports/Pages-individual.htm?unminified" target="_blank">https://help.qlik.com/en-US/nprinting/May2022/Content/NPrinting/PowerPointReports/Pages-individual.htm?unminified</A>&nbsp;and in Excel, it is the same.</P> <P>To split generated reports into different files you have to use cycles that are explained in details at&nbsp;<A href="https://help.qlik.com/en-US/nprinting/May2022/Content/NPrinting/ReportsDevelopment/Cycling-your-reports.htm" target="_blank">https://help.qlik.com/en-US/nprinting/May2022/Content/NPrinting/ReportsDevelopment/Cycling-your-reports.htm</A></P> <P>Best Regards,</P> <P>Ruggero</P> Tue, 06 Sep 2022 12:12:39 GMT https://community.qlik.com/t5/Reporting-Service-Alerting/Nprinting-report-How-to-split-the-records-in-multiple-sheets-in/m-p/1977484#M399 Ruggero_Piccoli 2022-09-06T12:12:39Z