Can Access report be populated with stored procedure

[Shals]

Hi,

I wanted to know the method of populating the MS Access report with the stored procedure written in SQL server. Is this possible, if yes, how? Any help would be appreciated.

Thanks,

[sierra7]

Hi

I'm just subscribing so I can read the answer!

I'm thinking along the lines of creating a temporary table in Access then basing the report on that but will await the response of someone who knows more about SQL Server.

S7

[NeoPa]

Hi,

I wanted to know the method of populating the MS Access report with the stored procedure written in SQL server. Is this possible, if yes, how? Any help would be appreciated.

Thanks,

I assume the Stored Procedure returns a SQL Cursor (dataset in Access).
If so, then a PassThru query can be set up in Access to get its data from the SQL Stored Procedure. This query can then be used (as other queries) as a Record Source for reports.

[NeoPa]

It may also be possible to link a table to a Stored Procedure but I'm not sure about that one. I know you can to SQL Server Views, but I think probably not for a Stored Procedure. Maybe worth trying though, for interest's sake.