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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Can a subreport be linked like MS Access?

Status
Not open for further replies.

teknogeek9

Programmer
Jan 6, 2001
47
US
I have a main report that has a number of subreports. Each subreport is linked to the main report via a common key. Each subreport has more detail than is required for the main report. However, I only want to pass a couple of selected fields from the subreport to the main report, but to retain the detail so that the user can drilldown. In Access, this could be accomplished simply by creating a main report field that is linked to the selected field in the subreport.
Can this be done?
 
Sounds like you need to pass specific values from a subreport to the main report. The only way this can be achieved is via SHARED VARIABLES. You declare the same shared variable in the main & subreport and once the subreport is processed, you have access to it (in a section below) in the main report.

Cheers,
- Ido CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top