Profile

Tuesday, 28 June 2011

Create Dynamic prompt on WEBI report.

Compared to Crystal Report, create a dynamic prompt on Web Intelligence report is simplier. The design view of WEBI is always has two window: Top window contain any data field you drag and drop from the Business Objects Universe as display on the report. Bottom window contain any filters you could build. The filter can also turn to prompt.

1.in WEBI report design window, drag a data field into the Query Filter window, select a condition as "prompt".


2.When user access this WEBI report, the prompt windows will display. in this case, user must select a data value (Year name) from a list of values. 


3. Then click Refresh Query, the WEBI report display the filtered data based on user selection prompt.


4. One thing about Business Objects WEBI is quick. One click can turn filter to prompt. In this case, one right click can turn a report table into graphic. Just select "Turn To"



5.Select the graph you prefer then click OK



6. Report table now turns to bar graph.