Interested to Buy Any Domain ? << Click Here >> for more details...
how to limit number of rows in a report in business objects
using webi?
- 3 Answers
- 19964 Views
- Cap Gemini, TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGNING UNIVERSES?
What is the difference b/w the simple Universe and Complex Universe?
how to coneect to a server in a business objects
How many ways you can restrict data in business objects?
what is custom sorting?how we can do this expalain with procedure???
IS THERE ANY MINIMUM RQUIREMENT TO DEFINE CONTEXT?
IN BO i have data source having the data like "abc" and after creating the Report on that datasource the data unmathed like "def".what will you do ? please anybody help me
What are the steps to do to use alerts in bo?
Why do we need Three environments Like DEV, UAT, PROD. Need detailed answer please
filename would be GCP_ARS_BO_TM_BERT MMDDYYYYHH24MISS.xls. how to do it?
Explain the data types present in bo and what happens if we implement view in the designer and report?
Can anybody tell How a report will burst into .pdf files? Thanks in advance .....Prakash
Teradata 
