Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist II
Specialist II

Report Editor Question

Hello :

I've designed a multipage (landscaped) report that works fine. It has a long table with a lot of columns in each page but a few rows.

This is what I get in two pages Captura.JPG

And this is what I want to get in one page

Captura 2.JPG

Is there any way to get this result without using two diferent tables ?

Thank you very much

Joaquín

1 Solution

Accepted Solutions
Highlighted
Specialist II
Specialist II

Re: Report Editor Question

Hi Peter:

I can create to tables and print them togheter in a simple page ... but I need multipage because the table would grow up to the right.

The same in the vertical mode, I wish to use the full area of the sheet not leave in blank the bottom or the right part.

I don't have NPrinting, and I won't have it.

Thanks in anyway

Joaquín

View solution in original post

11 Replies
Highlighted
Specialist
Specialist

Re: Report Editor Question

Hi Joaquin, I would say that you need to use two tables. But without any sample of how the report is build I'm afraid I can't say anything else.

Not a big help but hope it helps.

Cheers,

Andrés

Highlighted
MVP
MVP

Re: Report Editor Question

May be just disable 'Multipage' setting?

Highlighted
Specialist II
Specialist II

Re: Report Editor Question

Hi Andres:

I know that using two tables I can get it ... but the effort to maintain two tables is just the double.

Joaquín

Highlighted
Specialist II
Specialist II

Re: Report Editor Question

Hi Tresesco:

I've dissabled it, but I have one table with just the double of columns ... the numbers are very very little and I can't read them.

Joaquín

Highlighted
Specialist II
Specialist II

Re: Report Editor Question

Hi people:

Is there any other possibility ?

Thanks

Joaquín

Highlighted
Partner
Partner

Re: Report Editor Question

Hi, Joaquín.

The idea is to have the "remaining" columns in the second page? If so, I believe that it is not possible, since the multipage feature works by line.

With multipage option disabled, please try to change the stretch definition in your report's table. Maybe setting it to "fill" should work.

Regards,

João Duarte

Highlighted
Master
Master

Re: Report Editor Question

Hi,

May be

setting the print settings to 1 x 2 pages.

It seems as if your object is narrow enough, multi page is fine. But if your object is (too) wide, you can't use 'clip' and fill/ fill with aspect fill only the current sheet.

HTH,

Hirish

HirisH
“Aspire to Inspire before we Expire!”
Highlighted
Specialist II
Specialist II

Re: Report Editor Question

Hi João/Hirish:

I would like to print the second sheet of the table on the first sheet of the report, below the first part of the table

Thanks

Joaquín

Highlighted

Re: Report Editor Question

Using the builtin Report Designer, this cannot be done vertically in an automated way. Large/wide tables overflow on the next page in a Multipage setup. You will have to simulate two tables. If the width of the large table is fixed at n columns, it shouldn't be too difficult to accomplish. You can hide these objects from your UI by hiding the sheet on which they're placed. That's how the Report Designer does it anyway.

Peter