Creating report with banding

[spinchuk]

Guys, is it possible to create a report that will print few text objects with dynamic text multiple times on the same page (one for each client)?

Suppose i have a text object (=Sum(Sales)) and I have Customers list box with 10 customers.

What I need to do is to create a report and print the text object once for each customer on the same page.

Banding by customer within page properties puts each of 10 customers and the text object on a new page, but I need to keep it within the same page.

Any ideas would be greatly appreciated.

[ngulliver]

Hi,

You can use set analysis to create an object for each customer but this is a clumsy and laborious method.

You may be better looking at some of the third party reporting tools for QlikView such as NPrinting or CIA.

Regards,

Neil

[dharmarasu]

Hi,

Looping is not possible with in the same sheet.

--->if you want to show the 10 customer in 10 text objects, you want to create separate text object for each customer.

---> otherwise u can show it in a pivot/straight table.

Dharma

[SergeyMak]

What are trying to achieve? What the purpose of your idea?