Link Sub Reports

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have been driving myself crazy with this, but is there a way to set the
links for a master and child report when opening the report? I have a master
report whose unique ID is "AcctLogID". The record source is a SQL 2000
stored procedure. The sub report's record source is also a stored procedure.
Both the master and sub reports have a date parameter that I supply in the
"InputParameter" of the reports. In the master report, I have set the master
and child link to AcctLogID and the sub report is inserted in the AcctLogID
footer of the master report. When I run the master report, it does not link
the AcctLogID and I wind up with the records I want on the master report but
for the sub report, I get all records. Can someone tell me how to set the
link for these reports? Your help is GREATLY appreciated! TGIF!!
 
I also forgot to mention, when I open the report, I still get the Date
parameter prompt every time I move from one page to the next. My input
parameter looks like this "@Date=forms!frmCAcctReports!txtEndDate" on both
master and sub reports.
 
Back
Top