Calculated Column generation using WAD and Report Designer

[Former Member]

Hi,

I have a question can I add a new calculated column using WAD like BEx Analyzer.

If my query is returning Column 1 and 2. Can I add a new column Column 3 (Column 1 Column 2)

Can I hide few column from the query in the Web Reports.

Thanks

Raghu

[Former Member · Accepted solution]

You can add teh required columns in BEx Query designer itself. Also you can hide the required columns there itself. The hidden columns will not be displayed on web(WAD). The newly added calculated column will be displayed like the other two...

[Former Member · Accepted solution]

Hi Venkat,

Thanks a lot for your quick answer. I can not change the existing query.

Can you please explain how can I hide a column from WAD.

Thanks

Raghu

[Former Member · Accepted solution]

Hiding a column in WAD needs lot of work around. One way I suggest you to make necessary changes in the query itself.

[Former Member · Accepted solution]

Hi Venkat,

Thanks for you reply. Can you please give me some brief idea how you can hide rows in WAD.

Thanks

Raghu