[AccessD] Best Reporting Tool

Darryl Collins darryl at whittleconsulting.com.au
Thu Mar 22 21:45:17 CDT 2012


Hehehe, Yeah, at least the version I use it is. That is part of the reason I use SQL Server Express on some projects, to get around the 2GB limit of Access.



-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence
Sent: Friday, 23 March 2012 1:18 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Best Reporting Tool

You are probably right; never checked. ;-)

Jim

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Darryl Collins
Sent: Thursday, March 22, 2012 4:51 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Best Reporting Tool

Isn't the limit for SQL Server Express 10 GB?

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence
Sent: Friday, 23 March 2012 3:14 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Best Reporting Tool

Hi Gustav:

Well that could work as long as the data pulled is less than 2 GB. It would be an interesting exercise but I wonder about the speed. 

There is a host of Open Source reporting tools out there but I have no idea as to their quality and of course there is commercial products like Navicat software delivered at a reasonable price...all targeted directly towards PostgreSQL.

Jim 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: Thursday, March 22, 2012 8:59 AM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Best Reporting Tool

Hi Jim

I know, but I guess (well, I'm sure) it won't host Reporting Services to feed the Report Viewer of Visual Studio.

My point is that you could set up a main database engine of any kind (like
PostgreSQL) and let SQL Server Express pull or import data from the main engine to create the reports.

/gustav


>>> accessd at shaw.ca 22-03-2012 16:25 >>>
Hi Gustav:

PostgreSQL is one of the most powerful enterprise relational database servers available, at any price.

Cost = 0.

Jim 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: Wednesday, March 21, 2012 2:15 AM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Best Reporting Tool

Hi Darren

You could run one or more instances of SQL Server Express ...
It can link to external databases.

Cost = 0.

/gustav


>>> darren at activebilling.com.au 20-03-2012 23:09 >>>
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



--
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





More information about the AccessD mailing list