60 columns in a WEBI report-Fit to a single Page

building reports webintelligence
1

Hello All,
Can anyone let me know any work around on the Fit to a single page(Page Layout Mode) in the Web intelligence Document which has more than 60 reporting columns.

kivi :us: (BOB member since 2007-12-26)

2

You can fit it but you can’t see the content inside :nonod:

Thanks,
Zaif

zaif235 :us: (BOB member since 2010-06-15)

3

Hi,

Try to keep the page orientation as Landscape and keep the page size as A0.

Hope this will help you.

S_Shetty (BOB member since 2010-07-15)

4

Hi

click on the report body i will select the entire page and then go to properties —>pagecontent—>change the vertical records and horizontal records per page

Hope this helps u

:+1: :+1:

sunil kumar :india: (BOB member since 2011-10-03)

5

How will that help? :?

6

Hi Mark

Actually they asked to fit 60 columns in a single page . i thought that it is in quick display mode . sorry for the post .

:frowning: :frowning:

sunil kumar :india: (BOB member since 2011-10-03)

7

Um, export to Excel? :slight_smile:

How anyone can work with tabular data in Infoview is beyond me.

If you are trying to get a data range that large to fit to page in WEBI you’ll struggle (I’ve tried myself - I gave up)

Fit To Page is the thing I miss 2nd most about v5… 2nd only to Alt+F11… and only slightly above “Save as Text”

Penfold :uk: (BOB member since 2008-05-09)

8

I’ve managed to fit a LOT in some of my WEBI’s by changing a few things:

  1. Zero out all margins
  2. Set Page to Landscape
  3. Set size to Tabloid (11x17), (Though I now realize A0 is much larger!)
  4. Reduce font size of all objects to around 6 (anything smaller and it was just way to hard to read in most printers we had)
  5. Manually set all column widths, using multi-line headers when needed and abbreviating whenever possible.

However I’ve never come close to 60 columns :slight_smile:

So I have to ask the obvious, here. jumps up on the soapbox.
Who is asking for this and WHY?
Even on a paper size of 17" wide, with no margins, you only get approx .28 inches per column (and that’s assuming all are equal size). That’s about the equivalent to 3-4 characters at most.

I cannot help but think that a report with 60 columns on one page will never be legible.
Even if your users have no intention of printing but want it on one ‘page’ on the screen, they will have to constantlly use scroll bars to look around such a large set of data.

When users I had asked for similar requirements, I always took a step back and asked them “Why One page?”.

Usually the answer came down to something like “When it’s all one one page, I can easily scan the report and see which stores/products/whatever are out of line. Then I can run xyz report to get the detail”.

My compromise was to find out what ‘out of line’ meant, and build exception based reporting around those rules only. One such report ended up with a nice scorecard type layout that had one list of stores with under performing sales, one with overperforming, one with ‘sales out of trend’ etc… Then each of those rows linked to a detail report. Overall it was much easier to read than trying to cram every measure into one report just ‘so we can easily see the issues’.

JPetlev (BOB member since 2006-11-01)