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
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.
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.