Locking Down Interactive Reports (Hiding the highlight rule)

Problem


You create an interactive report, and you don't want people to change it.
You can create the interactive exactly as you want it to be displayed, with highlighting etc.


You can save it as the default report.


Now you don't want the user to change anything, so you switch off the whole actions bar.
(Interactive Report) > Attributes...



...problem is the highlight rule still shows, and the user can simply uncheck it to undo all your hard work.


Solution


Hide the highlight rule.
Give your Interactive Report an alias.


Now go to your page properties, and put in a value for CSS inline.

I've used the name "apex", change it to (whatever you called it )_control_panel.

 #apex_control_panel{display:none;}

Result, your report shows nicely, and the user can't change it.


Update 26 October

There are a number of other attributes that can be changed with this method. examples from MattsBits Blog
.apexir_WORKSHEET_DATA {
  border:0 #fff solid;
  empty-cells:show;
  border-collapse:collapse;
  font-size:8pt;
  }
.apexir_WORKSHEET_DATA tfoot tr td{
  background:#efefef;
  }
.apexir_WORKSHEET_DATA th{
  background:#4e4e4e;
  font-weight:bold;
  color:#fff;
  border-top:1px #ccc solid;
  border-bottom:1px #aaa solid;
  white-space:nowrap;
  vertical-align:center;
  letter-spacing:1;
  font-size:8pt;
  background-image:url(../ws/report_bg.gif);
  background-repeat:repeat-x;
  }
.apexir_WORKSHEET_DATA th div{
  color:#fff;
  letter-spacing:1;
  font-size:8pt;
  text-decoration:underline;
  cursor:pointer;
  margin:3px 9px;
  }
.apexir_WORKSHEET_DATA td{
  background:#efefef;
  border-top:1px #fff solid;
  border-bottom:1px #ccc solid;
  font-size:8pt;
  padding:3px 9px;
  empty-cells:show!important;
  }
#apexir_WORKSHEET .apexir_REPEAT_HEADING{
  padding:10px 0 5px 0;
  border:0 solid #fff;
  background:#fff;
  font-weight:bold;
  font-size:9pt;
  text-align:left;
  color:#000;
  }
#apexir_WORKSHEET .apexir_AGGREGATE_VALUE{
  font-weight:bold;
  background:#eee;
  text-align:right;
  }


Acknowledgement

https://community.oracle.com/thread/3898447
http://www.mattsbits.co.uk/item-24.html

Comments