Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Report Builder button does not appear in SSRS

Author  Topic 

ChuckIT
Starting Member

7 Posts

Posted - 2013-11-26 : 22:44:11
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

52326 Posts

Posted - 2013-11-27 : 04:37:23
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 - 2013-11-27 : 08:56:08
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

52326 Posts

Posted - 2013-11-27 : 10:28:08
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 - 2013-11-27 : 13:29:31
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

52326 Posts

Posted - 2013-11-28 : 06:01:26
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

52326 Posts

Posted - 2013-11-28 : 06:06:55
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 - 2013-12-02 : 10:49:42
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

52326 Posts

Posted - 2013-12-03 : 02:36:27
cool

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

- Advertisement -