sp and query in the same report

  • Thread starter Thread starter Edu07
  • Start date Start date
E

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
 
I report has a single record source. I don't have a clue what you expect with
"share the same report".
 
Duane,
The main report uses data from sp and has a subreport which data comes from
a query.
Thanks.
Edu.
 
You might want to tell us something about the fields in the main and
subreports as well as the Link Master/Child properties.
 
Ok, found the problem. I added the sub-report in the header of customer_id
instead its footer.
Thank you.
 
Back
Top