Brad Marks
BradM at blackforestltd.com
Wed Mar 21 06:25:35 CDT 2012
Darren, I wrote earlier how we are using Access 2007 for all of our reporting needs against data that lives in SQL-Server, Pervasive, and Firebird databases (all via ODBC). Our reports are either run "on demand" via a form in an Access application or they are part of a group of reports that are run automatically each night. When a report is run "on demand", the user has an option to save the report. Reports are saved in PDF format in a collection of folders. All "automated" reports are also saved in PDF format in this same collection of folders. All of the saved reports are available internally via our Intranet. Currently, no reports are visible via the internet but I believe that they could be incorporated into the internet if we wanted to do so. The one piece that we don't have is the ability to initiate a report from our Intranet. I am not sure if this info will be useful or not, but I thought that if you just need to "view" reports (and not initiate them), then our technique may be of some help to you. Brad -----Original Message----- From: accessd-bounces at databaseadvisors.com on behalf of Darren Sent: Tue 3/20/2012 6:40 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Best Reporting Tool Thanks for the replies so far I'm very sorry - I should have mentioned this (very important) fact The reports must be browser visible for our clients and or their clients to access via URLS as RepServices reports are. Sorry about that little omission :-) Thanks in advance DD -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Darren Sent: Wednesday, 21 March 2012 9:10 AM To: AccessD Subject: [AccessD] Best Reporting Tool Hi Team Brains Trust Question: We will soon be moving away from SQL Server. We will most likely be moving to PostgreSQL At the moment we are using MS Reporting Services for our reporting platform. We will be starting to look at other reporting tools soon. So, to that end, what does the group recommend for reporting tools? Cost is a factor Thanks in advance DD -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean.