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