How to make Bex Analyzer report rows static

[Former Member]

Dear experts,

I have a question to ask regarding Bex Analyzer query.

Is there a way in query designer or in bex analyzer to make report rows

cannot be collapse? I want to make it static, mean user cannot expand or collapse

the record in the row (example: attach expand.jpg).

Hope experts can give me an idea. Thank you.

[Former Member · Accepted solution]

Dear experts,

Issue solved. I created a workbook for my query and I protect the sheet with a password, therefore it will be static because user cannot edit the cell.

Thanks experts for the help.

[former_member202718]

Hi Azhar,

By using macros in workbook you can make it Static.

regards

SVU123

[Former Member]

you have the script? can you post it here? Thanks.

[former_member202718]

Sorry Azhar,i dont have the code but i know we can do it using Macros.

rgds

SVU123

[former_member182470]

Have you created this report using Cell structure? Have you pasted the Row descriptions as Childs to each other? If yes, then you cannot make the report Static. Just keep them one by one below each.

[Former Member]

This message was moderated.