SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Report Builder button does not appear in SSRS
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

ChuckIT
Starting Member

7 Posts

Posted - 11/26/2013 :  22:44:11  Show Profile  Reply with Quote
I have installed SQL Server Express 2008 R2 Express version and have created various tables and stored procedures.
I start Reporting Services Configuration Manager, connect to my report server instance, click on Report Manager URL and get my SQL Server Reporting Services Home page. I have the “New folder, New Data Source, Folder and Upload buttons, but I do not have a Report Builder button. Can someone tell me what the problem is? Everything else seems to be working except the most important piece, the ability to create a report.

Chuck

visakh16
Very Important crosS Applying yaK Herder

India
52325 Posts

Posted - 11/27/2013 :  04:37:23  Show Profile  Reply with Quote
Ad hoc reporting through semantic models and Report Builder is not supported in Express

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

ChuckIT
Starting Member

7 Posts

Posted - 11/27/2013 :  08:56:08  Show Profile  Reply with Quote
quote:
Originally posted by visakh16

Ad hoc reporting through semantic models and Report Builder is not supported in Express

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs




If you install SQL Server Express wtih Advanced Services it is supported. See this Microsoft link.
http://technet.microsoft.com/en-us/library/ms365166(v=sql.105).aspx
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52325 Posts

Posted - 11/27/2013 :  10:28:08  Show Profile  Reply with Quote
see link in that which speaks about supported features. it clearly suggests report builder is unsupported

http://technet.microsoft.com/en-us/library/cc281020(v=sql.105).aspx

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

ChuckIT
Starting Member

7 Posts

Posted - 11/27/2013 :  13:29:31  Show Profile  Reply with Quote
quote:
Originally posted by visakh16

see link in that which speaks about supported features. it clearly suggests report builder is unsupported

http://technet.microsoft.com/en-us/library/cc281020(v=sql.105).aspx

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs




Ok, now I see. 2008 R2 support Reporting Services but according to your link "Ad hoc reporting through semantic models and Report Builder is not supported."

It does appear to support report building through "BI Development Studio. This provides an integrated report creation and design environment to create reports."

Would you know if BIDS as it is called, works that same as Report Builder?
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52325 Posts

Posted - 11/28/2013 :  06:01:26  Show Profile  Reply with Quote
quote:
Originally posted by ChuckIT

quote:
Originally posted by visakh16

see link in that which speaks about supported features. it clearly suggests report builder is unsupported

http://technet.microsoft.com/en-us/library/cc281020(v=sql.105).aspx

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs




Ok, now I see. 2008 R2 support Reporting Services but according to your link "Ad hoc reporting through semantic models and Report Builder is not supported."

It does appear to support report building through "BI Development Studio. This provides an integrated report creation and design environment to create reports."

Would you know if BIDS as it is called, works that same as Report Builder?


BIDS doesnt work same way as report builder. BIDS is much more enhanced tool than report builder.
Report builder needs a deployed report model for you to consume and create reports out of it.
BIDS doesnt need a deployed model. It can create the metadata by using a defined database connection and dataset which will have query/procedure to get required data. So its much more flexible than report builder.


------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52325 Posts

Posted - 11/28/2013 :  06:06:55  Show Profile  Reply with Quote
And just in case you need to start using report server model just like in report builder you've a connection type called Report Server Model available within BIDS which you can make use of



------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

ChuckIT
Starting Member

7 Posts

Posted - 12/02/2013 :  10:49:42  Show Profile  Reply with Quote
Thanks for all your help. I've got BIDS running and created my first quick and dirty report.

Chuck
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52325 Posts

Posted - 12/03/2013 :  02:36:27  Show Profile  Reply with Quote
cool

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.27 seconds. Powered By: Snitz Forums 2000