Sort Order in Cycle Rapports

[johnan]

Hi, i have a XLS there i'm getting my orders. I just want N-Print to create my reports as they are in my XLS in that order.

Is it possible?

Cheers!

[pradosh_thakur]

Can you please mention what you want clearly? It's unclear.

[johnan]

Okay.

I have a QlikView with lot of data and i have created a Wordtemplate in N-Print.

It's based on ordernumbers and getting data from QlikView to N-Print to my wordreport.

N-Print is cycle reports if there is more than one order. I getting my ordernumbers from a XLS.

Like this (XLS):

Varu	Ordernummer	pall
237	472393	18
240	740873	17
227	22700737	20

Then i get the reports in my mail with the reports attached. But i want them to be in that order as the XLS is.

MAIL:

Br John

[pradosh_thakur · Accepted solution]

Well. It is printing eveerything in the numeric order.

Try this which may work, just a work around which i can think of.
create a column in the xls which will have unique value for all the order number and in ascending order . Use that field in your cycle as well. I would try this with a few records first.

Varu Ordernummer pall sort_order
237 472393 18 1
240 740873 17 2
227 22700737 20 3

[johnan]

Working perfect!
Thanx Mate!
Br John

[pradosh_thakur]

Great!!

[Lech_Miszkiewicz]

I would simply use "Load Order" sorting on the field you are cycling through in NPrinitng. Simple solution and does not require any additional fields.

regards

Lech

[johnan]

Hi Lech, can you tell me more?
The first load I made read directly from XLS and I thought it would cycle in that order. But not
Br John

[Lech_Miszkiewicz]

Are you using QlikView or Qlik Sense with it? 

[johnan]

QlikView
Br
John