Nprinting Issue - The same worksheet name already exists

[Jesh19]

Hi All,

we're using Nprinting 16 and while i'm trying to create a new report and run, i'm getting the below error.

Source Date Time Type Message

Application 5/25/2018 10:50:13 PM Information QlikView NPrinting Designer

Application 5/25/2018 10:50:13 PM Information QlikView NPrinting version: 16.1.0.0

Application 5/25/2018 10:50:13 PM Information Log File: C:\Users\Public\Documents\NPrinting\Log\20180525_nprinting.log

Application 5/25/2018 10:50:13 PM Message Run Task: Shared_Reports_RollingWeeks_Parent_Customer

Application 5/25/2018 10:50:13 PM Message Open file: qvp://BIDAPAUP004/Ops Compliance/TGF_OpsCompliance.qvw

Application 5/25/2018 10:50:13 PM Information QlikView version: 11.20.12354.0

Application 5/25/2018 10:50:13 PM Message Clear all selections: qvp://BIDAPAUP004/Ops Compliance/TGF_OpsCompliance.qvw

Application 5/25/2018 10:50:13 PM Message Creating output folder: C:\Users\jeshwanb\AppData\Local\Temp\57\NPrinting_Temporary_3BEBBD32B56045219C0AA68B2897DEA1\

Application 5/25/2018 10:50:13 PM Message Output folder created: C:\Users\jeshwanb\AppData\Local\Temp\57\NPrinting_Temporary_3BEBBD32B56045219C0AA68B2897DEA1\

Application 5/25/2018 10:50:13 PM Message Creating output folder: C:\Users\jeshwanb\AppData\Local\Temp\57\NPrinting_Temporary_Distribution_0E33A44FC8424C1D8FFDBA0722B64520\

Application 5/25/2018 10:50:13 PM Message Output folder created: C:\Users\jeshwanb\AppData\Local\Temp\57\NPrinting_Temporary_Distribution_0E33A44FC8424C1D8FFDBA0722B64520\

Application 5/25/2018 10:50:17 PM Message Apply filter: YEAR

Application 5/25/2018 10:50:22 PM Message Filter field: NC_Year {2017, 2018} ()

Application 5/25/2018 10:50:22 PM Message Start Load Task

Application 5/25/2018 10:50:22 PM Message End Load Task

Application 5/25/2018 10:50:22 PM Message Start Execute Task

Application 5/25/2018 10:50:26 PM Message Start OpsCompliance_Rollingweeks_Parent_Customer

Application 5/25/2018 10:50:26 PM Message Report type: Excel Workbook (Excel Workbook)

Application 5/25/2018 10:50:26 PM Message Producing report: OpsCompliance_Rollingweeks_Parent_Customer

Application 5/25/2018 10:53:09 PM Error Error: The same worksheet name already exists

Application 5/25/2018 10:53:09 PM Message End OpsCompliance_Rollingweeks_Parent_Customer

Application 5/25/2018 10:53:15 PM Message End Execute Task

Application 5/25/2018 10:53:15 PM Message Start Output Distribution

Application 5/25/2018 10:53:15 PM Message End Output Distribution

Application 5/25/2018 10:53:16 PM Message Terminate Task: Shared_Reports_RollingWeeks_Parent_Customer

Application 5/25/2018 10:53:16 PM Message This task took 183 seconds to execute

Application 5/25/2018 10:53:16 PM Message -------------------

Could someone please help me in solving the issue.

Thanking in Advance.

Regards,

Jesh

[Lech_Miszkiewicz · Accepted solution]

Looks like your report is using PAGE function on some field. It is likely that the values in your field are not distinct so it tries to create 2 sheets in Excel with the same name. Excel does not allow this!

What you need to wath for are things like:

• Qlik is case sensistive so: CLIENT a and CLIENT A are 2 different values for Qlik, but not for Excel....

Make sure that the values you are looping through are distinct!

regards

Lech