CODEWITHSUNDEEP
sqlms-accessstored-proceduresreport
raj
raj

Reputation: 143

Create dynamic report in Access 2003 from SQL Stored Procedure

I have to create a report in MS Access 2003 that shows data from sql stored procedure. Stored procedure returns data in table matrix. This report will create columns at the run time as column names are not predefined. How can I

  1. Call this stored procedure from the MS Access report?
  2. Create columns in the report at run time?

Thank you.

Upvotes: 1

Views: 73

Answers (1)

Andre
Andre

Reputation: 27634

  1. Create a Pass-Through query that calls the SP, and use that as record source for the report.
  2. The usual way is to create enough columns in the report, and then show/hide them as you need (.Visible property).

Upvotes: 2

Related Questions