[AccessD] Access 2007 Reports vs SQL Server Reporting Services

Hey Brad.
We use RepServices here at the office (SQL2005 Back ends)
Generally speaking - it's a pretty good tool, though there are display
issues on the browser display of final reports if you are not using IE
(Something to do with frames inside frames)
A real PITA
Anyway back to the designer - If I tell the design tool (Vis Studio)  I want
a new DataSource I get 7 'types' out of the box.
This includes SQL Server (Of course) and an OLE DB option , ODBC, XML and
ORACLE (These are out of the box nothing else installed)
We only ever connect our reports sitting over SQL but I'm sure you could do
more with it, from that point of view, than we are - 
Also the learning curve is bugger all if you already know VB and VBA syntax.
Good Luck

Darren


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks
Sent: Tuesday, 15 November 2011 6:46 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] Access 2007 Reports vs SQL Server Reporting Services

Over the past two years, I have used Access 2007 to create a variety of
reports.

The data for these reports comes from a variety of data sources (Access,
Excel, flat files, SQL Server, Pervasive Database, Firebird Database, etc).

I REALLY like the report writer that is built into Access 2007.

Recently the topic of SQL Server Reporting Services has come up.  Even
though I can access data from SQL Server (outside provider), I currently do
not have access to SQL Server Reporting Services.  

I am curious if anyone here on the AccessD forum has worked with this
facility.

How does SS Reporting Services stack up against Access 2007 Reports?

Is it possible to pull data from various sources into SS Reporting Services,
like we can do with Access?

Thanks,
Brad

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com