Drill through Report

[nfldbunker]

HI

I have a summary report which contains institution,diag code,diagnosis, and case count in a summary report.

Can i create a drill through report which would use this report as the main summary report and users will be able to drill through to a more deyail report which would contain individual records if it is required to see deatils of indivuals?

regards

bunker 

[MFGF]

Sounds perfectly reasonable to me! :)

You could either define the drill-through definition within the summary report, or alternatively define it for the package the summary report belongs to.

Regards,

MF.

[ksvchowdary]

One way is Drill through and Another Process is Master Detail Relationship.

Drill Through:
Create a Source ( Summary Report ) and Target ( Detail Information for every record ) and define the drill through definition in the source and run the report.

Master Detail:

take one list report and define the summary values  and take another list  inside the list ( Unlock the Order ID ( just for example only) , there drag the list and required data items. Define the masterdetail relationship between two list reports.
Note: Both lists ( Query's )should have one common data item to define the masterdetail relationship.