sp and query in the same report

[Edu07]

Hi,
Using a combo in a form, I'm passing on the customer_ID to a storage
procedure to populate a report. The latter has also a query which is binding
to the report through customer_ID. The storage procedure is passing on the
data but not the query.
Am I doing some wrong? Can a query and a storage procedure share the same
report?
TIA
Eduard

 

[Duane Hookom]

I report has a single record source. I don't have a clue what you expect with
"share the same report".

 

[Olga]

Duane,
The main report uses data from sp and has a subreport which data comes from
a query.
Thanks.
Edu.

 

[Duane Hookom]

You might want to tell us something about the fields in the main and
subreports as well as the Link Master/Child properties.

 

[Edu07]

Ok, found the problem. I added the sub-report in the header of customer_id
instead its footer.
Thank you.