cancel
Showing results for 
Search instead for 
Did you mean: 

How to hide query filter cell

Former Member
0 Kudos

Can anyone tell me if it is possible to hide a query filter cell from the query results? I only want the query result.

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Bao,

I assume that you are using BEx in Excel.

You can put the filter cells on a separate worksheet from the query result table.

You can hide the worksheet that has the filter cells on it.

Or, you can leave both on the same worksheet and hide the rows that have the filter cells on them.

Or, you can leave both on the same worksheet and "group" the rows that have the filter cells on them, then hide the grouping (Excel menu; Data >> Group). This way, the user can easily unhide them to see what filters were set if they want to.

- Pete

Former Member
0 Kudos

thanks for the response

Here is what i'm doing. I've created a rporting agent for a web template to export an excel file via download sheduler. When it is exported the filter cell and results are displayed even thought the web template allows you to not display the filter cells. I guess download scheduler just dumps the data into excel with whatever is in the document store.

So i was hopeing to hide the filter cell in the query properties. The reporting agent...download schduler is automated so i can't open >30 worksheet and hide or delete the filter cell manually.

How do you put the filter cell on another worksheet? is this an excel or query function.

Former Member
0 Kudos

Hi Bao,

Why dont u try creating a new template with the properties u want(just with the table and a few custon properties) and attach it the reports in which u wanna hide query filter cells. See if this works. Hope this will help.

Cheers,

Mav.

Former Member
0 Kudos

I've already did that. The web template comes out fine. Just the query results are shown when you call up the html link. But when the excel is exported, the filter cells come back up.

Any more ideas?!!

Former Member
0 Kudos

HI Bao,

Where r u seeing the report, on the portal or from Web application designer? lemme know.

Mav.

Former Member
0 Kudos

Hi Bao,

Where r u trying to view the report .. on the portal or from web application designer? lemme know.

Mav.

Former Member
0 Kudos

Neither. The report is exported out of download scheduler into a plain excel worksheet with no workbook template.

Former Member
0 Kudos

You can try the option of from the BEx screen "Layout -> Move Result Area".

The result area can be moved to a new worksheet. Refresh the query and the data will be published without the filter values.

Anil.