I am developing a report that uses a relational hyperblock to display the current reports created in Application Studio. I was wondering if it is possible to access the 'Hide from report viewers' setting in a hyperblock or formula?
Hi Leanne,
please find attached a comment of Mike Lewis from about 2 years ago, that helped me finding out these hidden reports in the repository tables
(Replace ForecastEntry with your Report Name.)
SELECTR.Name as ReportName,S.Name as SettingName,CR.ValueFROM coReport RJoin coCombRepSCL CRON R.IDReport=CR.IDCombReportJoin cSetting SON CR.IDSetting=S.IDSettingWhere R.Name='ForecastEntry'And S.Name='Reporting_Report_HideInWS'
ReportName SettingName ValueForecastEntry Reporting_Report_HideInWS 0
May this can help you, too?
Regards,
Ralf
That's a great help, thank you for sharing Ralf.
Leanne, can I ask you to describe the business case in the enhancement request and share in the community (better in the new community as this one will be soon off) ? The direct access to the repository won't work in the cloud environment and might be changed in the future versions, so I wouldn't rely on it fully, however if it works for you now, great!
Nick,
I could give you a business case. In the case of creating a default dashboard for a set of users we often want to show the contents of multiple folders on one dashboard in a list. We do this by using a hyperblock to show specified folders. But anything that is "hidden" in those folders will still show. In the past we have had to hardcode exceptions for specific reports and folders. Any time a new report is created and hidden, it has to be added to the hardcoded list. Would be nice to be able to filter based on that property.
Hi Nick, maybe there is an alternative way to achieve this in V12 (on-premise), could you please advise? I am wanting to create a navigation panel for the application studio reports that can collapse to the left of the reports rather than the default dialog that drops down from the top toolbar next to dashboards. I have used the above tables to create a dimension with this setting as an attribute. I have then created a report in application studio referencing this dimension and filtering based on the attribute.
More broadly, it would be helpful to know if the report navigation window can be set to permanently appear like a widget in the custom reports for navigation through the report Catalog. Or if the report structure and visibility set in application studio can be access from OLAP.
@ralf-zerfass do you know which tables hold the relevant application role permissions for each report?
