sub report does not sync with parent.

The SP is a cursor that walkes through data to verify information, builds a temp table, Adds more info, then selects the temp table.  The Parameters passed to the sp are @beginTS, @endTS @AgentID.

"then specify stored procedure's parameters based on the fields in the parent report"

The report is grouped by person.  The subreport is showing records for all the people in the report and not just the person for this part of the report.

I temporarily hardcorded the dates to see if that would work. Nope.  Then I got rid of the SP and copied the SQL into the recordsource.  I had to hard code the Input parameters, and it worked.

What about my SP does the report not like?  I still need to use input parameters for the subreport, How do i How that?

It's very hard to say without the specifics of your reports and your stored procedures. Also you said that subreport is showing all records rather than the group section, so it's not obvious how they could be linked to begin with.

Maybe you could somehow separate your report and subreport into a separate adp and upload it here, with the script for your stored procedure and involved table(s).

Normally you specify stored procedure's parameters as Input Parameters of the form or report:

s.p:
create procedure mysp(@parm1 int, @parm2 int)

subreport: input parameters property:

@parm1 int = reports!MyParentReport!field1,@parm2 int = reports!MyParentReport!field2

There's also another, undocumented, method: if the parameters in the s.p. are named exactly like the fields in the parent form or report, i.e. in the above example not @parm1 and @parm2 but @field1 and @field2, then they are taken automatically, even without being specified in Input Parameters.

I have overly simplified this so that i can figureout what is the problem.

I created a blank report.  in the record source I put:

SELECT * FROM Activity WHERE (TimeStamp BETWEEN @BeginTS AND CONVERT(DATETIME, '2008-11-30 00:00:00', 102))

Now the Input Parameters property shows: "?  = BeginTS"  I tried to change this to @BeginTS DateTime = '11/1/2008' but it reverts back.  how do i set the input parameters?

make it

SELECT * FROM Activity WHERE (TimeStamp BETWEEN ? AND CONVERT(DATETIME, '2008-11-30 00:00:00', 102))

input parameters:
? = forms!form1!mydate

where mydate is a field on form1.

If this is subreport of report1, then you can also refer a field in report1:
? = reports!report1!mydate

Ok, the report runs by itself now. But when it runs as a subreport i get "Syntax error or access violation".  I dont know why that is happening.  Is there a way to see the calls to the SQL server from Access so that we can see what access is sending?

Here is the recordsource:
SELECT  Agent.AgentName, Activity.AgentID, ActType.ActType, Activity.TypeID, dbo.DateOnly(Activity.TimeStamp) AS theDate1, dbo.DateFormats(Activity.TimeStamp, 'hour') AS thehour, 
               COUNT(*) AS qty
FROM     Activity INNER JOIN
               Agent ON Activity.AgentID = Agent.ID INNER JOIN
               ActType ON Activity.TypeID = ActType.ID
WHERE  (Activity.TimeStamp BETWEEN ? AND ?)
GROUP BY Activity.AgentID, Agent.AgentName, dbo.DateOnly(Activity.TimeStamp), dbo.DateFormats(Activity.TimeStamp, 'hour'), Activity.TypeID, ActType.ActType, 
               CAST(Activity.AgentID AS Varchar(20)) + ' ' + CONVERT(Varchar(20), Activity.TimeStamp, 101)
 
And here are the Input parameters:  #11/1/2008#, #11/30/2008#
                                              

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:

also, The error disappears if i delete the Master/Child field links.

If there are master/child links, then Access is trying to inject additional WHERE basing on those links. Remove them. You provide the link by those parameters already.

ok, so now I changed the recordsource to accept 3 parameters.  The subreport works if i remove all of the grouping in the subreport. But if i leave the subreport alone, I get this error:

Column (theDate) was used in a calc expression but is not defined in the rowset.

Why is the main report stopping the subreport from grouping?

I changed it again and now i get:
Ambigous Column name (theDate2) was used in a CALC Expression.

Now i Changed the recordsource to an SP, used full inputparmeter details and now the grouping works.

Wow that was a PITA!!

Thanks for your help.