SSRS Express 2014 Report Creation

Mark01
Mark01 used Ask the Experts™
on
I recently installed SQL Server Express 2014 with Advanced Services. Does it have a built in tool to create reports?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Russell FoxDatabase Developer
Top Expert 2014

Commented:
You'll need SQL Server Express 2014 With Advanced Services (SQLEXPRADV).

Author

Commented:
I installed SQL Server Express 2014 With Advanced Services. During installation, there were options about reporting services configuration.
Database Developer
Top Expert 2014
Commented:
Sorry, you'll also need SQL Server Data Tools (SSDT, formerly BIDS). This is the development environment for creating reports. You'll also need to set up your report server if you haven't already.
Should you be charging more for IT Services?

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Author

Commented:
I read a posting on a web site last night that SSDT is not compatible with Visual Studio Express 2013. Can you confirm this?

I just read that SSDT is included in Visual Studio Express 2013 as in the link shown below. Do you agree?
http://msdn.microsoft.com/en-us/hh297027.aspx
Russell FoxDatabase Developer
Top Expert 2014

Commented:
If you already have VS2013, you can just get the BI templates here:
http://www.microsoft.com/en-us/download/details.aspx?id=42313

I believe that SSDT, like BIDS before it, is a "slimmed down" version of VS that's just for business intelligence projects.

Author

Commented:
I do not have VS2013. I'll download Visual Studio Express 2013 and find out if it includes SSDT.

Author

Commented:
I installed Visual Studio Express 2013 and it did not include SSDT. When I tried to install SSDT I got the errors shown below. I then installed Report Builder without any errors. Thank you, Russell.
First ErrorSecond Error

Author

Commented:
I just tested Report Builder and it works with SQL Server Express 2014 .

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial