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

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

can some body explain how migrate the BoXI r2 to BO 3.x and crystal reports XI r1 to Crystal report 2008 ?

926


How to Explain about BO projects in interviews?(in Banking,insurance,Manufacturing domains)

4314


Explain in detail about type 2(scd),

587


Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?

619


Its regarding Javascript coding for customization in BI4 reports. We need to have all the options disabled in the report except the option to Export(save the report in computer in Excel/pdf formats). I am able to hide TopBar,TabBar,Left Navigation etc but I need "Export" option to be displayed to the users in Read mode. Can this selective "hiding" be achieved?

1471






What three things do you consider to be the most important factors for a manager?

587


what is the difference b/w the refresh and buffered data?

1758


what are the day to day activities of BO administrator ?

1968


Explain is there any default username & pwd for bo designer & supervisor?

591


what are the tables used in health care domain project and columns used in report?

4031


Explain what sort of existing documents should business analysts refer to when starting on a new project?

596


is it possible to export the webi reports to crystal reports?with out using businessview?

1812


If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?

1771


Can we Save (save as) WEBI Doc as DESKI?

7059


What is package in BO

2680