This is another thing you can do.

You say your MS Access query is working. In the design view of the query copy the SQL and compare with the SQL Query...

Follow this link. It is comprehensive and to the point.

http://hodentek.blogspot.com/2012/04/installing-sql-server-express-2012-and.html

Installing SQL Server Express 2012 and managing the LocalDB

This article discusses in detail with a number of screen...

Here is an article that describes the process in detail:

http://hodentek.blogspot.com/2012/04/installing-sql-server-express-2012-and.html

"Installing SQL Server Express 2012 and managing the LocalDB"

This article discusses in detail with a number of screen...

The details you have provided are not sufficient. What kind of a database is it? Are the tables going to be related in any way?

Very Strange! Both OR and Union All should work.;-)

Which group is this? Who is running this?

I would like to volunteer to give some help on SQL, SSIS and SSRS

Jayaram Krishnaswamy

http://hodentek.blogspot.com

I think matrix report is for displaying aggregate values

I have come across the same type of problems linking to EnterpriseDB. My first impression is that the combination of MSDASQL and the ODBC driver I am using are not...

Anything is possible. That is scary.I am having a long standing argument with software makers including MS

I have the right kind of book for you which I highly recommend.

"Learning SQL Server Reporting Services 2008" by Packt Publishing, UK.

This book has over 50 hands-on exercises that will...

From the error message I get a feeling that you are not specifying the Report Server / Report Manager ports correctly.

The other reason for this not working for you is...

You are using MSDASQL which is Microsoft OLE DB Provider for ODBC. Are you accessing a linked server. Have you set up the linked server correctly. Have you tested whether...

IN Report Builder 2.0 click on Insert menu item on the 'Ribbon' and choose to insert a 'Header'

Do yourself a favor. Check out my book at:

http://hodentek.blogspot.com ...

Check out my book, "Learn SQL Server Reporting Services 2008". This book will show you the basics of using the SSRS 2008 but not building a complete asp.net web site...

Reports created using a Windows/ASP.NET application are published to the intranet server which in the case of a web server in a computer box is generally termed localhost and they...