Stored procedure in an adp report

V

Veerle

Hi,

In our SQL server database, we made a copy of certain views, tables
and stored procedures. This copy contains some adjustments to the
code.

There are rather long list of reports in an adp that uses the SQL
server database. These report were written by someone else who is on
holiday at the moment. Now I have modify them all so that they use the
new version of the views, tables and stored procedures. But I'm kind
of new to this...

Is it so that I only have the check the record source of the report,
or are there other possibilities to use a view, table or stored
procedure in a report? If so, how can I check that?

Thanks in advance,
Veerle
 

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

Trying to create a report that will list unmatched records by Ticket Primary Key 0
Can't create persistent ## tables with ADP call to a stored procedure(!?) 2
Access 2000 ADP and SQL Server 2005 2
Access can't find stored procedure after scripting on sql server 2
Stored procedure as row source for a combo box 4
Accessing Stored Procedure via VBA 4
The stored procedure executed successfully but did not return any records 4
adp report does not recognize fields from stored procedure 3

Top