Cell too large to display on 1st page.

building reports webintelligence
1

Hello all. Using BO XIR2 Webi.

I have a report with portrait layout. There are a bunch of fields toward the top. About half-way down the page I have a field with a very large text description. When I refresh the data, and the report is rendered, one of two things has happened.

(1) The first half of the text field was displayed on the remaining portion of the page, and it wrapped to the second page. Issue is that it broke the field in the middle (vertically) of a line. So, page one had the top half of the letters, and page 2 had the bottom half of the letters (for that line only - of course).

(2) The entire field was pushed to the second page.

These two things happened in that order. I did some modifications between the two, and can’t seem to re-produce the first event.

Is anyone familiar with this? Ideally, I would like to display as much of the field on the first page as I can, and then the remaining portion on the second page without corrupting the text. And then save to PDF.

I have this field set to Autofit height and Wrap text.

Any help or hints on this would be great.

Thanks,
hagnik

hagnik :us: (BOB member since 2006-08-01)

2

Is it possible for you to give us a graphical explanation of your problem :?:

phil70 (BOB member since 2009-10-09)

3

How many characters you have in the cell??

Thanks

BOCP (BOB member since 2007-07-02)

4

Hi,

Can you send sample screen shot of your report so that we can analyze further… thanks

nahtanoj :philippines: (BOB member since 2009-07-08)

5

Hi, hagnik

Please provide us screenshots of your Report.

Thanks and B’ Regards!
MeZ :wave:

mez19 (BOB member since 2009-08-10)

6

Thanks for the interst in this post. I’ve posted a doc with 3 images.

(1) STRUCTURE LAYOUT
(2) RESULTS (Page 1)
(3) RESULTS (Page 2) - didn’t include the entire field.

You’ll notice the field is rather large it’s probably has 2 or 3 times more characters than I displayed in this screen shot.

Ideally, I would like that field to begin right under the “Qualifications” header, and to wrap to a second page if necessary.

Thanks,
hagnik
PCM1.doc (76.0 KB)

hagnik :us: (BOB member since 2006-08-01)

7

Set up a section for Qualifications. On the top of this section create an empty cell called “Qualifications”. Below that the cell which contains your field, e.g. “Qualifications”. Fill this field using =[Qualifications].

In the properties of this sections you can configure, how the section should be generally displayed.

Please let us know, if your problem is solved.

phil70 (BOB member since 2009-10-09)

8

Thanks for the suggestions.

I gave it a shot. It still doesn’t do what I hope to accomplish, but I’m still not sure it’s possible. The main difference after adding a section for Qualifications is that it keeps the Title with the Text cell. The Text cell prints on the first page if it is small enough to entirely fit, else it begins on the second page.

I still hope to have it begin on the first page, and wrap to the second if necessary.

Thanks,
Nick

hagnik :us: (BOB member since 2006-08-01)

9

Just a suggestion…but do you think you can store one line of text with a line number individually in the datamart? Then select both the line # and line of text on the document. On the first page, include only line # 1 thru line 30 (if it only 30 lines can fit on the page) by using a block filter of line # between 1 and 30. Then include subsequent lines on a separate page within the same report, filtering for lines greater than 31.

bkaporch :us: (BOB member since 2008-12-02)

10

Thanks for your creativity. I don’t have access to the data structure or the universe to make changes. It’s a third party reporting solution. I’m limited to the features in Webi.

Thanks,
Nick

hagnik :us: (BOB member since 2006-08-01)