sp and query in the same report

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
 
D

Duane Hookom

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

Olga

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

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.
 
E

Edu07

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need a form for Customer Range - can I copy the one I used for dat 1
subreport not displaying data 1
Limit Records Shown Per Report 5
printing reports 14
Apparently Bogus "could refer to more than one. 9
Report using union query 2
Showing two 'counts' on the same row 4
Report based on SP w/ Parameter (Where does not work) 1

Top