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!

Linking to a subreport command

Status
Not open for further replies.

kskid

Technical User
Mar 21, 2003
1,767
US
How can I link a main report field to a subreport command field?

Thanks in advance

-lw
 
It's been a while. Forgot to post environment

Crystal XI, SP 2
Oracle 8i with ODBC connectivity,
 
For Crystal 10, it is Edit > Subreport Links. You have to find something in the subreport to link it to, a field of the same type. This will also automatically add a selection rule for the subreport. You can then remove the selection rule if you don't want it.

Once the link is made, the main report field is available to the subreport, with a prefix of Pm-

If you need to pass anything back, use a Shared Variable.

[yinyang] Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10 [yinyang]
 
MADAWC,

I think I solved it.

I created a formula in the main report, @person_ID which is MASTER.PERSON_ID field. I created the the same parameter name, person_id in my Add Command.

From the main report, when I linked the subreport, I chose ?person_id from the subreport and it works so far.

-lw

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top