Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

flyingcheesehea
Contributor II

Report banding and headers/footers

I'm trying to create a report in QlikView that prints a national report as well as an identical report banded across all regions for a client.

The report is on two multi-paper pages: The first has a title, date, text box with some statistics in the header, and then a long table with data and graphics that takes up several pages. The second is another text box in the header and table in the body. That part is working as well as it ever does in QlikView reports.

The problem comes when I print the regional reports. I started by duplicating the above pages and then switching on banding across all values in the ClientRegion field. Unfortunately, the headers are only printed once for the entire set of regions, rather than being printed once per region as I would expect. I need to print "Statistics for Region xxx" and I have a text box that dynamically updates when a single region is selected. It looks exactly how it should when the first region prints, but when subsequent regions print there is no longer a header at all, so it looks like a bunch of repeated data with no easy way for the end user to see which region it is for.

Since the headers won't work, I was hoping I could put that text box in the body of the report, but the multi-paper report pages do not allow more than one object to be in the body. I would do a dynamic caption on the objects, but there still doesn't appear to be a way to get object captions to print in a report.

Does anyone have any suggestions for how to accomplish this?

I must say, as nice as most of QlikView is, the reporting absolutely stinks - It has a very "1.0" feel to it, unacceptable in a version-11 product IMO. (No undo? Seriously?)

Tags (2)
1 Solution

Accepted Solutions
Highlighted
flyingcheesehea
Contributor II

Report banding and headers/footers

Figured it out: From the Edit Reports window, select the page, then Page Settings -> Settings. I was thinking "header" and "footer" so much that the "introduction and appendix" settings didn't occur to me!

So, turn on Introduction Placement for Intermediate Papers and Last Paper and it prints the "header" (ie the introduction" for every value of the dimension.

View solution in original post

3 Replies
Highlighted
flyingcheesehea
Contributor II

Report banding and headers/footers

Figured it out: From the Edit Reports window, select the page, then Page Settings -> Settings. I was thinking "header" and "footer" so much that the "introduction and appendix" settings didn't occur to me!

So, turn on Introduction Placement for Intermediate Papers and Last Paper and it prints the "header" (ie the introduction" for every value of the dimension.

View solution in original post

Not applicable

Re: Report banding and headers/footers

QV 9  seems to not have this function. Is there another way to suppress the header on the first page?

ljdlumley
New Contributor III

Re: Report banding and headers/footers

Well I'm over 3 years late but this exactly solves my problem. Thank you.