Hide Column Dynamically

[ScottMans]

Working with your nested reports and have a requirement to allow users to dynamically hide specific columns of a nested report. This action will be based on a switch or checkbox to show and hide columns x, y, and z. How can this be accomplished using css and javascript?

[pstaniszewski]

Hi,

it's not built into the current solution, but definitely doable with some JS. As I understand, you would like to keep the information about hidden/presented columns in the database so those users can have their predefined reports saved?

Let me know the details or recreate an example at apex.oracle.com so I can suggest some actions. Alternatively, we can also develop a solution tailored exactly to your requirements for you.

Best regards, Przemek

Przemysław Staniszewski Pretius Low-code CEO Oracle ACE Pro ♠ mobile: +48 600800881 <+48+600800881> site: www.pretius.com [image: facebook] https://www.facebook.com/pretius/ [image: twitter] https://cNwLJ04.na1.hs-sales-engage.com/Ctc/ZT+23284/cNwLJ04/JkM2-6qcW6N1vHY6lZ3lxW2HB4dM4X_H8RW1jCFmM7zDpR-W1kbGfg3nf1mZW3wXw1C9lV9MVN3mdrrB7XNTMV3jQLd3yY_YFW6GymyF5d-f5HW3lyVmq2Rtd1CW926LYB2v1Lk6W6njVMN5fw2bxVJx7qw65fGqQW6vdp5K20Y2JqW2HLFRD7q1rD2W6qXWGp7KrwVgW4-GDWv634q64W1nxWgs6fPBjxW31ZRn07nxK-YW4WdghS6NTlRBN903tyClpT77W1__rRq1sJ0JJN2PvQwCqym23N8hdz1DhZSsNf54yYSF04

Planned absences/business travels:

22.01 - 24.01.2024 - CloudWorld Tour, Dubai, UAE

31.01 - 5.02.2024 - Out of the office

14.03.2024 - CloudWorld Tour, London, UK

20.03 - 22.03.2024 - APEX World, The Netherlands

11.04 - 13.04.2024 - APEX Alpe Adria, Maribor, Slovenia

22.04 - 24.04.2024 - APEX Connect, Düsseldorf, Germany

24.04 - 25.04.2024 - OUGN, Oslo, Norway

12.07 - 18.07.2024 - Kscope24, Nashville, USA

8.09 - 12.09.2024 - Oracle CloudWorld, Las Vegas, USA

czw., 18 sty 2024 o 15:40 ScottMans @.***> napisał(a):

Working with your nested reports and have a requirement to allow users to dynamically hide specific columns of a nested report. This action will be based on a switch or checkbox to show and hide columns x, y, and z. How can this be accomplished using css and javascript?

— Reply to this email directly, view it on GitHub https://github.com/Pretius/apex-nested-reports/issues/45, or unsubscribe https://github.com/notifications/unsubscribe-auth/ADU44OIOO2DG3PKBTOGDQJ3YPEX4ZAVCNFSM6AAAAABCAMSPFOVHI2DSMVQWIX3LMV43ASLTON2WKOZSGA4DQNBSHE2TMMA . You are receiving this because you are subscribed to this thread.Message ID: @.***>

[ScottMans]

I have a page containing a report that contains a nested report. This is operating fine. My nested report has the columns name, address, age, email address. I now need to add a check box to my page that will allow the user to specify whether to include the email address column in the nested report. Check box is checked, the email address column is displayed. Check box is NOT checked, the email address column is not displayed.

Can this be done with the current release? If so, how do I accomplish this? Thanks for responding.

[ScottMans]

So can this be done?

[akierzkowski]

Hello, I have verified is it possible and to my best knowledge plugin won't support functionality that you have described within the current release. There may be only one set of columns that is fetched in scope of one APEX report, and even using multiple plugin instances won't do the trick.

However as a workaround solution I would suggest trying to set the column to be always visible and then use custom javascript/css code that would hide it under desired conditions. Functionality may be considered to be in scope of future releases, but I can't estimate any precise date at the moment.

[ScottMans]

Thanks. I have worked a solution for my case. The option to display the columns is a page checkbox. Report is simple so I just duplicated the nested report DA and applied a condition to each. The shown report is determined by the checkbox value. Y shows the report containing the additional columns. N shows the report without those columns. Seems to work.