[dba-SQLServer]Subreport not recognizing parent/child link

Arthur Fuller artful at rogers.com
Wed Jul 16 10:39:04 CDT 2003


If you can, switch the subreport's recordsource to a view, leaving the main
recordsource as your first sproc.

Hth,
Arthur

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Susan
Geller
Sent: July 16, 2003 10:06 AM
To: dba-SQLServer at databaseadvisors.com
Subject: [dba-SQLServer]Subreport not recognizing parent/child link


A2K ADP.  I have a report with a subreport in a group footer.  The
recordsource for each is a sproc and I have input parameters in the
properties of each report.  Problem is that the subreport that's in the
group footer  displays ALL data, not just the data for that value being
grouped on.  So, on the report, I get the same data in every group footer.
I do have the parent and child fields identified in the properties of the
subreport object on the main report.  This does not happen when I use views
as the recordsource for the main and subreports. What am I doing wrong?

Thanks!

--Susan




More information about the dba-SQLServer mailing list