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 MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
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 MVPhttp://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 |
|
|
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 unsupportedhttp://technet.microsoft.com/en-us/library/cc281020(v=sql.105).aspx------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
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 unsupportedhttp://technet.microsoft.com/en-us/library/cc281020(v=sql.105).aspx------------------------------------------------------------------------------------------------------SQL Server MVPhttp://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? |
|
|
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 unsupportedhttp://technet.microsoft.com/en-us/library/cc281020(v=sql.105).aspx------------------------------------------------------------------------------------------------------SQL Server MVPhttp://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 MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
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 MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
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 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-12-03 : 02:36:27
|
cool------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|