Disable Drilldown on Prepared Reports

seansmith

Hi all,

I'm a developer maintaining and updating a Delphi (XE2) application where users can save a prepared report (fp3) into a database. When I create the report (prior to saving into the database), I have two GroupHeader bands, both of which have DrillDown and ExpandDrillDown enabled. This work is working as you'd expect at this stage.
At some later point, a user will load the report from the database (which is working) and then viewing the prepared report (which also works). However, while viewing if a user attempts to click on a GroupHeader (any, doesn't matter) the entire report goes blank, i.e. same number of pages but with nothing on them.

So my question(s) is

a) should ExpandDrillDown work on prepared reports; or

b) how can I disable ExpandDrillDown or just Drilldown in general for the the prepared report.


Thanks

seansmith

For anyone else with similar problems, I solved b) by disabling DrillDown for all each GroupHeader prior to saving the prepared report into the database.

Here's the code I've used

for i := 0 to Report.AllObjects.Count - 1 do begin
  if TfrxComponent( Report.AllObjects[i] ) is TfrxGroupHeader then
    TfrxGroupHeader( Report.AllObjects[i] ).DrillDown := False;
end;
frxReport.DrillState.Clear;