Banding on multiple pages

Thu, 22 Sep 2011 11:56:07 GMT

Hello community!

I am facing a quite tricky problem on printing a report, maybe you could help ?

I want that a group of 3 pages (lets say stock, sales, inventory coverage) to be printed for a group of country (Mexico, USA, UK, Canada).

In this case, I create a report and I want in the end :

stock, sales, inventory coverage of Mexico

stock, sales, inventory coverage of USA

stock, sales, inventory coverage of UK

stock, sales, inventory coverage of Canada

I searched for long on forums and if I understand well, macros are needed.

Though, I am looking something like :

1) get the list of possible countries

2) loop on countries

3) print the report by appending the doc already created

Any kind of help on one of these 3 steps will be most (most!!) welcome.

Looks quite simple right now but I did not even manage to get the lisbox values in a msgbox,

Until now my code looks like this:

'get nb of countries

set lb = ActiveDocument.GetSheetObject("Country_List")

n = lb.GetCardinal

msgbox(n) 'Here, ok, it works

'iterate on each country

For i = 1 To n

msgbox(lb(i))

Thanks a million in advance!

Hubert

topic Banding on multiple pages in QlikView