Blank page in webi report

hi,

I have webi ( BO XI R2) report with 6 different TAB. data is same in each TAB but only difference is number of column. when I schedule this report it ran successfully but when I see latest instance there is no page ( no header/footer, column name , data ) in last 2 TABS. Other Tabs are looking fine with valid data & drilling. but I am not sure what is happening for last 2 TABS. when I go to edit mode everything seems fine.

Any Idea what could be possible root cause of this issue?

Thanks


mkgupta :us: (BOB member since 2009-05-14)

Are they completaly blank?


Marfi :poland: (BOB member since 2006-12-18)

only report header / footer & drilling is there. No report body.
errorpage.doc (37.0 KB)


mkgupta :us: (BOB member since 2009-05-14)

Are there more pages or just one in those to tabs?


Marfi :poland: (BOB member since 2006-12-18)

more than 1 page


mkgupta :us: (BOB member since 2009-05-14)

Is there is any table structure available on the blank page? If so, select the column(s) and change the font size, name etc. I have had similar issues. I had no problems creating reports in HTML view though. It seemed like a Java problem. By default it was assigning font size to ‘Auto’ (-1). Try the above mentioned approach or try installing older version of Java if you can create reports in HTML view.

Regards,
Ameya N.


analavde (BOB member since 2010-08-23)

I dont think font size is issue here. One more thing when I select any value from drill than report page looks fine i.e. table structure , column name , data etc. Then I need to select ‘ALL’ again so that I can see complete report.


mkgupta :us: (BOB member since 2009-05-14)

I had some blank page issues that I resolved by going into Structure mode and making sure the section height at the bottom didn’t leave any white space. Maybe your issue is similar.


pcgeekus :us: (BOB member since 2003-10-16)

I too am getting this issue. When I run the queries with one value in the prompt the pages are ok. When I run the queries with another, it’s not ok. (data for the query that populates these 2 pages is being returned by the query. I created a new page to check this).

Was any solution found to this? :hb:

Edit: When I edit the report the pages display as they should. This is only when viewing the report in interactice and HTML mode.


dopple :uk: (BOB member since 2009-06-19)

i have this issue earlier :

If you have section then reduce it with a height just 2px bigger then the table rem the borders shud not touch.

Secondly try it with decresing or increasing the footer height at times it needs to increase and at times it needs to decrease.

Thirdly Convert the page mode to quick display.It will work


county :india: (BOB member since 2011-08-04)

Hi,

Are there any Sections in the report?


saurabhg :india: (BOB member since 2007-04-02)

Sometimes this is caused by Auto-Width and extends the table past the right margin. Look at it in Page Layout mode and rerun the report with the value that creates the blank page. Again, don’t forget to check Structure mode and make sure you shrink the bottom section line to just under the table or last element.


pcgeekus :us: (BOB member since 2003-10-16)

Hi folks. Sorry for the delay in replying.

Regarding the auto-width, the page is in A3 landscape and when viewing it in page layout mode it doesn’t come near to the sides.

Regarding resizing the footer, how do I do that? This is on BOXI r2 sp6.

Also how would I set the bottom end of the section to a couple of px below the bottom of the table? All I see is a minimum height setting.

There are 3 sections on this repor, each one a sub-section of the one above it.


dopple :uk: (BOB member since 2009-06-19)

I realize this is a very late reply, but wanted to complete this answer for future use. To resize the footer, click on an area that represents the whole page. Header and Footer settings will then show up in the Page Layout properties. they default to 48px and I use about 26 or turn them off. To set the section ending point, put the report into structure mode and drag the botton of each section line until it bumps the bottom of the table or block. P.S. In XI 4, pixels are no longer used, it’s all in ruler style measurements.


pcgeekus :us: (BOB member since 2003-10-16)