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

Create subreport

Status
Not open for further replies.

maha12

Programmer
Sep 8, 2002
79
LK
Hello All,

I am using CR8.
There is a field called PRNo in my main report (rptPRSummery). I want to show a subreport(rptPR) when clicking on the PRNo of main report.

Pls explain how?

Tks,
Maha.
 
Go to insert->subreport->create or choose a subreport->check "On demand subreport". Then place the subreport where {table.PRNo} would be located (probably the group header for a group based on this field. Right click on the subreport->format subreport->subreport->on-demand subreport caption->x+2 and enter:

totext({table.PRNo},0,"")//remove the totext(,0,"") if already a string

Now the field will be displayed and will be a link to the subreport if clicked.

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top