Skip to Content
author's profile photo Former Member
Former Member

Unlimited rows in single page (Webi 4.0)

Hi experts

I am using Webi Bo Xi 4.0 sp2

My client requirement is , if my report consists more than 5000 rows then they want to see all the rows in a single page .

I done all these possibilities

1)I unchecked the limit at universe level

2)I unchecked the limit at report level

3)At CMC i kept the limit up to 9 lakhs

4)At right click i set the vertical page limit 20000 ,horizontal 100,oreintation portrait

so everything seems fine techinically , But webi report restricting only 1000 rows per each page,

Client want see all the data(more than 5000 rows) in single webi report page.

what will be solution to this problem?

This is an urgent requirement . waiting for ur replies.

Appreciate u r help

Thanks & Regards

Sunil

Add a comment
10|10000 characters needed characters exceeded

Related questions

7 Answers

  • Best Answer
    Posted on Jul 31, 2012 at 05:07 AM

    Hi Sunil,

    Try using custom page size which will suit your requirement in page sizing window..

    and also use quick display mode instead of page mode.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 30, 2012 at 04:08 PM

    Sunil,

    What you are looking for "Fit to Page", this feature is currently NOT available for WebI. This is something major I have been requesting for several years since they discontinued DeskI. Hopefully they will decide to include this feature if enough users ask for it.

    At this point the best you can do change you page size to 11 x 17 and when you print use an 8.5 x 11 page.

    Regards,

    Ajay Gupta

    PS. If you want to vote on the SAP Idea, please see link below.

    https://cw.sdn.sap.com/cw/ideas/12002

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 30, 2012 at 05:05 PM

    in quick display mode you can set the number of vertical rows, this should do the job

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 30, 2012 at 01:51 PM

    hi Sunil,

    the rules of engagement explicitly discourage from marking questions as urgent.

    please see http://wiki.sdn.sap.com/wiki/x/FgQ for more details

    thanks

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 30, 2012 at 03:34 PM

    Hi Sunil,

    In Information Design Tool look for tab 'Query Options' under Universe Parameters. It allows setting record count and time limits for Universe specified. By default those are set to 5000 records and 10 minutes.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 30, 2012 at 04:52 PM

    The number of rows you can see is defined by the report view you are look at if you have page layout enabled and trying to view 5000 rows on a A4 or letter or other format i doubt it will fit unless you make it unreadable. If you are not using the Page Layout option then you can increase the number of rows restriction on the Style Sheet and it will show you all 5000 rows.

    Hope this helps

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 31, 2012 at 09:54 AM

    Hi All

    Thanks for inputs 😊 . I manually kept the fit to number of pages and also the width ,But what i am seeking is Fit to page in webi , As we dont know how many pages the report have .😈 . Now its time to vote at idea place 😉

    Regards

    Sunil

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.