Skip to Content
avatar image
Former Member

Blank page in Webi reports

I have created a letter form report with 4 pages. This report contains one Horizontal table in 3rd page. When I run the report the horizontal table is extending to next page by leaving lot of blank pages.( Getting total 8 pages on running the report, Page 1-fine, page 2- blank, page 3- fine, page 4 - blank, page 5- fine, page 6 - horizontal table extended till here, page 7 - fine, page 8 - blank) Because of page 6 I am getting 2,4,8 as blank page. Can anyone please suggest a solution.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Nov 02, 2016 at 11:20 AM

    Try with these steps.

    Add one row above in the Horizontal table.

    Add variable1=runningcount([Your Object]) (This is going to be measure variable)

    One more variable Show/Hide=[variable1] (This variable type select as dimension)

    Drag Show/Hide in the first row.It will generate the sequence number.Add filter on the table to restrict the values like less than 10.with this in first table you will get 10 records only.

    Copy then same table and paste again.Change the filter in second table to get the records from 11 to 20.

    Right click on the second table->Format Table-> tick the box "Hide when empty".with this if records are less then 11 then second table will be hidden automatically.

    Last is right click on the Show/Hide object in the table and hide the dimension.

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 01, 2016 at 10:06 AM

    Is there any column which is by any chance shifting to the second page? Check that. Try decreasing the width of the column, so that all of them can be adjusted to one page.

    Also try setting the "Horizontal records per page" to a higher number. Default value is 20. that means one page an have 20 col.

    Add comment
    10|10000 characters needed characters exceeded