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
 
Back
Top