Access Report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to base my Report on a recordset returned by running SQL stored
procedure.I get the recordset, but I am not able to populate fields in
Report.
Pl. help.
 
Gundi said:
I want to base my Report on a recordset returned by running SQL stored
procedure.I get the recordset, but I am not able to populate fields in
Report.
Click to expand...

If your database is an MDB/MDE, try creating a Passthrough Query to run the
Stored Procedure, and use the Passthrough Query as the RecordSource of the
Report.

If your database is an ADP/ADE, someone else will have to answer -- I've
never tried reporting, but never successfully used a "disconnected
recordset" as RecordSource for any object (then, again, I never did ADP in
the most recent versions of Access).

Larry Linson
Microsoft Access MVP
 
You must log in or register to reply here.

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

Trouble cloning a reports recordset 1
>> ADO Updateable recordset 3
How do you set a recordset's bookmark? 5
Creating subroutine with Function using sql recordsets 1
Access 2000 to Excel 1
Loop thru recordset to populate report 1
SQL for Opening Recordset 2
Do TEMP tables in Stored Procedures not work with ADO Recordsets? 1

Back
Top