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

How to go to sub reports from main report...

Status
Not open for further replies.

mpsudheer

Programmer
Sep 22, 2003
4
IN
Hi there,

I have a main report in which there are a list of members. Now i need sub reports for each members in the main. Can i have a link on member name, by clicking which i can go to his detailed sub report. Currently what i get is a seperate link which is the subreport name. which i don't need.. Is it possible to have a link on the member name itself, on clicking which i can go to the sub report... Please any body help me..

Thanks
Sudheer
 
Create the subreport as an on-demand subreport, grouping in both main and subreport on the name field, and then using the name field as the link and placing the subreport in the group header or footer of the main report.

Then in preview, select the subreport, right click and choose format subreport->subreport tab->x+2 area for "on-demand subreport caption" and enter your name field, e.g., {table.name}. The link will now show the member name and you can use this instead of the group (member) name in the main report.

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top