how to limit number of rows in a report in business objects
using webi?
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 services the broadcast agent offers on the server side?
Can some one say abt "ALL" in prompt .. How to get the word "ALL" in the prompt along with the list of values? Plz give me the steps?
We can have two separate installations of BOE XI 3.1 on a single server?
How to particiapte the columns availabe in the Derived tables in the Reporting window? How it's done?
Explain what are the steps to do to use alerts in bo?
WHAT IS THE DIFFERENCE BETWEEN OLAP AND DATAWAREHOUSE? WHAT IS MICROCUBE EXACTLY?
Explain about alerts in bos, under what situation we need to use alerts?
How can I display the query execution time for a particular DP on Web-I report? Or is there any other way to know the 'exact query execution' time at BO end?
Can more than 1 metric be applied on an analytic in business objects?
HOW MANY TABLES ARE EXISTED IN WEBI REPORT?
CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN
what is stacked chart , Bar chart, Column chart?