Jim Lawrence
accessd at shaw.ca
Fri Apr 16 13:41:46 CDT 2010
Hi Brad: You can always use Access linking to SQL as a the report writer. We have a sample report code at DBA which might help: http://www.databaseadvisors.com/newsletters/newsletter112003/0311UnboundRepo rts.asp The sample only uses an MDB as it is not easy have a version of MS SQL which can just be run directly from an unzipped ZIP file. I am not sure of what level of MS SQL you are using. If it is a full blown version MS SQL, 2005 and later, you also have access to Reporting features but it is an extra module that can be downloaded and installed: http://www.microsoft.com/sqlserver/2005/en/us/reporting-services-features.as px (Note: feature not available for MS SQL express for designing but it can use reports created in full version) HTH Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks Sent: Friday, April 16, 2010 10:37 AM To: AccessD at databaseadvisors.com Subject: [AccessD] Access 2007 Reporting Versus Crystal Reports Recently the topic of Crystal Reports was brought up. We are a small firm with a small IT budget. Our data lives in SQL Server, Access 2007, Excel, and in a purchased package's Pervasive Database which we can access nicely via ODBC. We currently do not have Crystal Reports, or any other report writer other than the reporting features that are integrated into Access 2007. I took a stand and said that I believe that Access 2007 will be able to handle our reporting needs. We currently have very few reports and it appears that our reporting needs are quite basic. The bulk of our data lives in SQL Server, but we do not have SQL Server Reporting Services available. Are there issues that I should be aware of when starting to use Access 2007 Reporting against SQL Server? So far, our initial experiments have worked nicely, but we have only started to scratch the surface. If we are heading down the wrong path, I would like to know sooner rather than later. Thanks in advance for your advice and insights. Brad -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com