Page 1 of 1

Drill-Down to a Different Report

Posted: Mon Aug 10, 2009 7:51 pm
by johnham
There seems to be a field in the Drill Down properties called "Drill-Down Report". I figured that this would allow you to have drill down into another report. However, my problem is that I store my reports in an SQL Database. Is there a hook or event that I can use to load a report during drill-down?

Drill-Down to a Different Report

Posted: Tue Aug 11, 2009 9:37 am
by Jan
Hello John,

You can use GetDrillDownReport of component. You need fill e.Report property in hanlder of this event. For example:

Code: Select all

StiReport report = new StiReport();
report.Load("report.mrt");
e.Report = report;
Thank you.

Drill-Down to a Different Report

Posted: Tue Aug 11, 2009 10:43 am
by johnham
Where do I find a reference to the Component. My code is all based on the Report.

For Design:

Code: Select all

StiReport Report = new StiReport();
Report.Design();


For Print:

Code: Select all

StiReport Report = new StiReport();
Report.Print();
For Preview:

Code: Select all

StiReport Report = new StiReport()
Report.Preview();
Of course these are simple examples but as you can see I am not using a component directly. Is there a reference to an StiComponent somewhere in my Report object?


Drill-Down to a Different Report

Posted: Wed Aug 12, 2009 12:15 pm
by Jan
Hello John,

I mean GetDrillDownReport event of any component in report. Please look at attached image.

Thank you.

Drill-Down to a Different Report

Posted: Wed Aug 12, 2009 12:37 pm
by johnham
My end users are not programmers. Is there anyway I can hook this event in my code like I do the loading event and just provide this functionality for them?

Like before I load the designer or print or preview I good hook an event that would attempt to find the report they specify in the "Drill-Down Report" property of the component.


Drill-Down to a Different Report

Posted: Fri Aug 14, 2009 1:25 am
by Jan
Hello John,

New global event is added -StiOptions.Engine.GlobalEvents.GetDrillDownReport. Please check next prerelease build.

Thank you.