Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Business Objects
  2. Suggest New Category

how to limit number of rows in a report in business objects
using webi?

Question Posted / vamaninfa

Answers were Sorted based on User's Feedback



how to limit number of rows in a report in business objects using webi?..

Answer / santhosh

to retrieve max no of rows or to limit the max no. of rows
before running the report go to properties tab in that we
can set the max no. of rows so that we can retrieve the data

Is This Answer Correct ?    19 Yes 1 No

how to limit number of rows in a report in business objects using webi?..

Answer / kiran

One can use the Data Provider properties -> Set Max rows retrieved -> 65K
Create a variable check =DocumentPartiallyRefreshed()
and add 2 report level block filters
apply check = no to data block &
apply check = yes to message text block.

This should work fine!

Is This Answer Correct ?    0 Yes 0 No

how to limit number of rows in a report in business objects using webi?..

Answer / rameshbabu.katikireddy

I have a requirement where I need to display the WebI Report data only if the number if record is less than 65k.
Incase if the records are more than 65k then the report should be blank and a text message needs to be displayed.

The client dont want to set the number of records either in universe or at the edit query at the report. They want to limit once the report is executed.

Please let me know if its possible to do it at the report level.
posted by
Rameshbabu.katikireddy
jan.11.2012
09767696346
karimnagar

Is This Answer Correct ?    2 Yes 3 No

Post New Answer

More Business Objects Interview Questions

Explain what are the steps to do to use alerts in bo?

0 Answers  

IN THE REPORT I WANNA APPLY HYPERLINK FOR A CELL IN THE COLUMN/ROW HOW TO ACHIEVE THIS? EG: YEAR COLUMN : 2001,2002,2003,2004 I WANNA APPLY FOR 2001 ONLY

2 Answers   Accenture, Rolta, TCS,

how to creat 2 way drilling mode.can any one know this

0 Answers  

what is fantrap?

2 Answers  

What is meant by ZABO and FC(full-client)?

2 Answers  

What is #refresh,#hash,#Comupation error and How to resolve #refresh,#hash error.

1 Answers   Accenture,

can anybody explain me in detail what is the difference between desktop intelligence and web intelligence in detail?

2 Answers  

How to import BIAR file in bo?

1 Answers   Emirates, Zensar,

How will solve a loop caused by lookup table without using alias?

1 Answers   L&T,

WHAT ARE THE DISADVANTAGES IF WE HAVE MORE FACT TABLES IN UNIVERSE?

4 Answers   Ericsson, Nokia,

What is the definition of derived table ?

2 Answers   JPMorgan Chase,

what is crosstab reporting,slice and dise and drill mode??

3 Answers  

For more Business Objects Interview Questions Click Here
Categories