Web Application Designer (WAD) is used to design templates for the report embedded in it. Usually report simply provides an excel based output. In addition to this WAD can provide some extra functionalities or properties such as Links, Buttons, Back screens, Filter panels, Tickers, Drop downs, Radio buttons, List boxes, Hierarchical filter selection, Info Fields etc to the existing report. Here in this blog I would like to share few important commands used,

Suppression of Messages:


While executing the Bex Reports, sometimes we may come across some warning messages, which are not much harm for reports, but Users may feel that there is some issue with the reports. So in this case we should suppress those messages, this can be done through WAD using the Web Item “System Messages”. We need to suppress the messages by selecting the property Visibility as “Hidden”. Please find the below screenshot where the setting needs to be done,

Filter on Selected Record:


Sometimes users may like to filter a row based on a field (For Example: Organizational Unit). Please find the initial data available in the report below,

Organizational Unit

Organizational Manager

Employee

Location

Country

Sales

Karl

Nichol

New York

USA

Sales

John

Martin

New York

USA

Sales

Randy

Micheal

London

England

Finance

Eva

Jana

Munich

Germany

When User selects a row (Organizational Unit) on “Sales”, User should see only data related to the Organizational Unit “Sales”. Please find the data how it should display,

Organizational Unit

Organizational Manager

Employee

Location

Country

Sales

Karl

Nichol

New York

USA

Sales

John

Martin

New York

USA

Sales

Randy

Micheal

London

England

To achieve this type of functionality we should as below,

  1. Create a Button using the Web item “Button Group”.
  2. Edit the description of the Button to “Filter Selected” and select a command “SET_SELECTION_STATE_BY_BINDING”. Please find the details in the below screenshot,

3. Add the field for Selection after selecting above command.


As per the above screenshot, whenever user clicks on the row based on the field “Organizational Unit”, it will filters out that data only and show as output.

How to remove filter after selecting a filter on a Row:


  1. Create one more Button and name as Back to Initial.
  2. Select a command “BACK_TO_INITIAL_DP_STATE”. Please find the details in the below screenshot,

After selecting the above command, the screen of the report will move to the initial screen as below,

Organizational Unit

Organizational Manager

Employee

Location

Country

Sales

Karl

Nichol

New York

USA

Sales

John

Martin

New York

USA

Sales

Randy

Micheal

London

England

Finance

Eva

Jana

Munich

Germany

To report this post you need to login first.

1 Comment

You must be Logged on to comment or reply to a post.

Leave a Reply