cancel
Showing results for 
Search instead for 
Did you mean: 

BEx Web Reports

Former Member
0 Kudos
142

Hey gurus, I need your help!

First question:

In BEx Web reports, is there a limit of rows you can have? Excel is restricted to 65,000 rows. What happens when you export a BEx Web report with more than 65,000 rows to Excel?

Second question:

Is it possible to have all rows displayed on one screen – i.e. get rid of the scrolling arrows which you use to get to the next set of rows?

Thanks a lot for your replies!

Sabine

Accepted Solutions (1)

Accepted Solutions (1)

former_member188975
Active Contributor
0 Kudos

Hi Sabine,

There is no limit for the number of rows in a web report.

In the Table web item properties, there is a property called BLOCK_SIZE. You can modify this to see the number of rows displayed at once.

Hope this helps...

Answers (1)

Answers (1)

Former Member
0 Kudos

Additional Feedback Welcome

Former Member
0 Kudos

What happens then when you export more than 65,000 to Excel

former_member188975
Active Contributor
0 Kudos

You get a message that remarks that the maximum numbers of rows is reached, so the resultset is incomplete. The remaining rows are not displayed, but the ones above the 65K limit can be seen.

Hope this helps...