Nprinting excel report by column and column information displayed in wrong location

[ronaldwang]

when exporting to excel template by column, by dragging column into the desired cell location, but in the actually print out, the order has changed. does anyone know why and how to address this? thanks

[Chanty4u]

can u share the input screen and output screen?

[ronaldwang]

If I drag column with heading product to columnA and column with heading name to columnB then post code actually appearing in columnA

[miredoju]

Hi,

does you have hidden fields in your table ?

For me nprinting can`t handle hidden fields....

Michael

[ronaldwang]

thanks, I think probably that is the reason, will try it out

[Chanty4u]

Hi,

you can achieve this if you dont have a  hidden fields also.

Need to do like below example:

Actual in Qlik		Nprinting Designer		OutPut File
ColumnA	ColoumnB		ColumnA	ColoumnB	ColumnA	ColumnB
aa	dd	<ColumnA>	<ColumnB>		dd	asas
bb	ee	ee	otherc olumn value
cc	ff	ff	otherc olumn value
You have to do like this in designer
ColumnB	ColumnC	whatever the column values are getting you just  change the name of the label
<ColumnA>	<ColumnB>

[Lech_Miszkiewicz]

It definitely is the reason.

Unhide & Enjoy

cheers

Lech