how to supress the heading, and filter area? plz help

[Former Member]

Hi Experts,

Happy new year!!

i have a reqt in which <b>i need to display only the result area.</b> i have the query heading, and filters(sales rep ID, sales Organization, etc). is there a way where i can supress the filter area, and heading of the query?

i will be very glad if someone can help me out. its realy urgent.

Thanks in advance

kavi

[edwin_harpino · Accepted solution]

hi kavi,

in bex analyzer or webtemplate ?

in bex analyzer you may hide the rows of heading and filter area then save as query view or save as workbook.

in web you may set the remove mark for 'generate caption' and not use navigation block.

hope this helps.

[Former Member · Accepted solution]

Hi AHP,

Thanks for the response.

I am in Bex Analyzer.

plz let me know, how to hide the heading and filter area?

i was looking into Layout icon in the Bex analyzer. and didnt find a suitable option to hide the filters values and heading. plz help.

Thanks

kavi

[edwin_harpino · Accepted solution]

hi kavi,

seems can't do in layout->text elements,

try to use excel functionality, block the rows of header and filter area and go to format->row->hide then save query as views or workbook.

hope this helps.

[Former Member · Accepted solution]

Hi AHP

Thanks a ton for prompt reply.

it worked absolutely.

i rewarded points to you.

Thanks

kavi

[edwin_harpino · Accepted solution]

hi kavi,

you are welcome. thanks.

[former_member183777]

The delete warning when you move the results area is only for that action. Once you move it to another location, do a refresh and you will get the desired result as well. Of course A.H.P option is the best way to do it.

[Former Member]

Hi! BW guru's

I have the same problem as Kavi here. I would like to go the VBA route. But ,I am very new to it. Eugene, could you be kind enough to let me know the procedure and place to add the code which you mentioned.

My yahoo id is sarbanesox@yahoo.com

Thanks a lot.

S.

[Former Member]

Hi,

Please see some basics here:

Best regards,

Eugene

[Former Member]

Hi Kavi,

The following code placed into SAPBEXonRefresh(queryID As String, resultArea As Range) Sub does the job.

Dim ws As Worksheet, Range1 As Range

Dim RowsRange As String

Set ws = resultArea.Parent

resultArea.Name = ws.CodeName & "_results"

Set Range1 = resultArea

firstrow = Range1.Cells(1).Row

RowsRange = "1:" & Trim(Str(firstrow - 1))

Rows(RowsRange).Select

Selection.EntireRow.Hidden = True

Best regards,

Eugene

[Former Member]

Hi Eugene,

Thanks for the reply. it helped. i rewarded points to you. i will ask, if i need any further help.

Thanks

kavi

[Former Member]

Hi Kavi,

Using some VBA code you can hide what you don't want to show.

It's easier to move result area into another worksheet:

Layout->Move result area (toolbar icon or menu)

and save the workbook.

Best regards,

Eugene

[Former Member]

Hi Eugene.

well, i tried your option before posting it here. but it says "moving the result area will delete its result area's contents.", which i dont want.

so, now with AHP's answer i used the hide option and it worked. you were talking about VBA code. can you please provide me with some code, which does this work automatically.

Thanks

kavi