Skip to main content
Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
nadkalyan
Partner - Creator
Partner - Creator

Export to Excel Renders only Chart name and no data is showing up in Excel output

Hello, We just started using NPrinting and when we build  the report in NPrinting and added some Charts to the Designer. When this is exported to Excel we do not get any data, only the template shows up. How do we populate data when exported report to excel.  Attached are the images with NPrinting Designer and also output when export to Excel.

Please suggest some insight on what might be missing.

Thanks

kalyan

Nprinting DesignerNprinting DesignerData in Excel OutputData in Excel Output

Labels (2)
6 Replies
Daniel_Jenkins
Specialist III
Specialist III

Hi Kalyan,

When you say "export to Excel" what exact steps do you take? What do you see when you click the Preview button (in the Actions section of the ribbon) from within the Template Editor?

HTH - Daniel.

Ruggero_Piccoli
Support
Support

Hi,

You just started to use Qlik NPrinting so I strongly suggest to execute the getting starting tutorial step by step https://help.qlik.com/en-US/nprinting/April2019/Content/NPrinting/Introduction/Get-started.htm.

Then you should study the chapters about Excel templates development https://help.qlik.com/en-US/nprinting/April2019/Content/NPrinting/ExcelReports/Intro-Excel.htm

There are also many video tutorials.

For example, placing tags and column titles on the right of another tag (<CH175>) is wrong because the data from CH175, that has 11 columns) will overlap the columns C, D and E.

Best Regards,

Ruggero



Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.
nadkalyan
Partner - Creator
Partner - Creator
Author

I am trying to export from NPrinting Webportal-  Reports/Reportname > Export.

When I do preview, it does populate the data.

NPrinting ExportNPrinting Export

nadkalyan
Partner - Creator
Partner - Creator
Author

These are very useful links and Tips. Thank You. 

I just wanted to show a simple sample of my issue by placing chart items, individual items and show the output, that is the reason i placed them in successive columns. 

Ruggero_Piccoli
Support
Support

Hi,

This is the button to export the template for example to import it again and clone to a new report or to move it to a different Qlik NPrinting installation.

You must run a report preview from the template editor.

Best Regards,

Ruggero



Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.
nadkalyan
Partner - Creator
Partner - Creator
Author

Thanks for clarifying on Export button functionality. The Preview button shows the preview of data, how would a user who needs to get full data run report in excel format from NPrinting web console?