O'Reilly logo

Microsoft® Access Projects with Microsoft SQL Server™ by Natascha Nicol, Ralf Albrecht

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Creating Reports

Reports can be based on tables, views, SELECT queries, or stored procedures. If you are using a wizard to create a new report, you can select only tables or views as data sources in Microsoft Access 2000. Reports based on a stored procedure can be created in Design view, because that is the only place where you can select a stored procedure as the Record Source.

In Microsoft Access 2002, you can also use wizards to select a stored procedure as the Record Source.

The next few sections describe innovations as well as errors and inconsistencies that occur when using reports in Access projects.

New Properties for Reports

Two new properties were added to reports in Access projects: Server Filter and InputParameter. We discussed ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required