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

Susan Geller sgeller at cce.umn.edu
Wed Jul 16 10:51:26 CDT 2003


The procedure for the subreport accepts the same parameters as the
procedure for the main report.  I'm not sure how I would pass a
parameter that is the value for the group footer, although that does
seem like what I need to do.

Arthur, a view doesn't work b/c I need to be able to pass parameters.

--Susan


-----Original Message-----
From: Djabarov, Robert [mailto:Robert.Djabarov at usaa.com] 
Sent: Wednesday, July 16, 2003 9:45 AM
To: dba-sqlserver at databaseadvisors.com
Subject: RE: [dba-SQLServer]Subreport not recognizing parent/child link


Sorry for the trivial question, but does the procedure for the group
footer accept the key from the group as one of the parameters?  If yes,
then see if you can enforce an exact value to be passed rather than
having a default value for the parameter (e.g. create proc test (@key
int = null) as...)

Robert Djabarov
Senior SQL Server DBA
USAA IT/DBMS
? (210) 913-3148 - phone
? (210) 753-3148 - pager


 -----Original Message-----
From: 	Susan Geller [mailto:sgeller at cce.umn.edu] 
Sent:	Wednesday, July 16, 2003 9: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


Susan B. Geller
Office of Information Systems
College of Continuing Education
University of Minnesota
306 Wesbrook Hall
77 Pleasant Street SE
Minneapolis, MN 55455
Phone:  612-626-4785
Fax:  612-625-2568


_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com



_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com



More information about the dba-SQLServer mailing list