Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Drill-Downs in report

Status
Not open for further replies.

t16turbo

Programmer
Mar 22, 2005
315
GB
Hi,

I'm quite new to Actuate and probably know only the basic functionality.
What I want to be able to do is cilck on the project number in a project summary report (showing actuals, baseline, project number etc)and for it to then bring up another report showing project details etc.

Is this possible?
if so, how?
also, is it possible to have expanding sections in report so that the same thing could b shown but the other report is actually already in the main report, just collapsed.?

thanks in advance,
 
Although I've never done it, my guess is that you can change the Visibility properties for frames and put code in the report to show or expand those sections when selected. You'd probably have to add a link to that section as well.

For a drill down, add code to the project number control to link to the other report. You can also use a LinkExp, but if there is a few checks and balances you'll want to put it in the BuildFromRow:

Something like the following, but Im not sure what fields you have and what the other report is called

Function BuildFromRow( row As AcDataRow ) As AcBuildStatus
BuildFromRow = Super::BuildFromRow( row )
If Not row Is Nothing Then

Me.LinkTo = "/ProjectSummaryReport.Rox?ProjectNumber=" & Row.GetValue("ProjectNumber")

End If

End Function
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top