After installing SSRS! You can’t manage Reports site

March 31, 2010

It’s just a quick tip after you’ve successfully installed SQL Server Reporting Services on Windows Vista or Windows 7, you go to http://{Server-Name}/reports which redirects you to http://{Server-Name}/reports/Pages/Folder.aspx you find out that you can’t control anything and the site looks like this

Don’t worry what you should do is to, right click on Internet Explorer or your favorite browser then run as administrator and retype your SSRS Reports site URL http://{Server-Name}/reports you’ll find you can manage everything as you see

To not open your browser as administrator everytime you manage your Reports you should add your current user as Content Manager or as you wish. From Properties-> New Role Assignment -> Type the username of current user -> Select role -> OK

Open it without run as administrator it will look like as you want.


Deploying Reports in Reporting Services Programmatically

October 18, 2009

May be it’s my bad luck may be something else, but I didn’t find a complete post how to deploy Reports, and Data Sources in Reporting Services in away like BIDS.

First it’s a tool I developed to automate the deployment of BI solution (Creating Data warehouse, installing SSIS packages, creating Jobs, create Cubes and installing reports on Reporting Services Server).

If you don’t have time to read and just need to download the tool, here you’re
Source Code

Herein, I’ll talk about the last thing which is deploying reports.

P.S: It’s my way in designing such task (Installing reports on Reporting Services Server) and it’s not standard or anything else just (follow your heart :))

Read the rest of this entry »

Reporting from Analysis Services Cubes Using Excel 2007

September 8, 2009

Session #14: Reporting from Analysis Services Cubes Using Excel 2007 (Peter Myers)

Event: 24 Hours of PASS

Presenter: Peter Myers


SSRSSSAS1 Read the rest of this entry »

All about Microsoft SQL Server 2008 R2

August 16, 2009

Download SQL Server 2008 R2:

What’s new in SQL Server Integration Services: No new features they just fixed some bugs:

What’s new in SQL Server Analysis Services: I didn’t find any information about that!! if you know please drop a link.

What’s new in SQL Server Reporting Services:

Microsoft Gemini: or to know about Microsoft Gemini

A small stand-alone MSI for Report Builder 3.0, August CTP, is now available for download here:

Download packages for SQL Server 2008 R2 August CTP are available here:


Reporting and Business Intelligence in Microsoft Dynamics AX 2009

May 16, 2009

Reporting and Business Intelligence in Microsoft Dynamics AX 2009

FREE From Microsoft E-Learning

About this Course
This two-day instructor-led course provides students with the knowledge and skills to leverage the extended Reporting and Business Intelligence (RBI) features of Microsoft Dynamics AX 2009. The training course covers installation of pre-requisites and supporting technology, creating and deploying reports using SQL Server Reporting Services, creating, adjusting and deploying business intelligence projects using SQL Server Analysis Services, and integrating all these features together in the Rich client, Enterprise Portal or Role Centers, for the end-user.

Audience Profile
The course is intended for developers or those individuals who will be creating and deploying reports and business intelligence projects.

At Course Completion
After completing this course, students will be able to:
– Differentiate between Microsoft Dynamics AX 2009 reporting features, SQL Server Reporting Services and SQL Server Analysis Services.
– Appreciate the benefits of leveraging SQL Server Reporting Services and SQL Server Analysis Services with Microsoft Dynamics AX 2009.
– Explain what the Role Center in Microsoft Dynamics AX 2009 is used for.
– List the system requirements for Reporting and Business Intelligence for Microsoft Dynamics AX 2009.
– Step through the procedures for installing SQL Server Reporting Services and the integration components for Microsoft Dynamics AX 2009.
– Design reports in Report Builder and Visual Studio using Microsoft Dynamics AX 2009 data sources.
– Integrate SQL Server Reports with Microsoft Dynamics AX 2009 Client, Enterprise Portal and Role Centers.
– Step through the procedures for installing SQL Server Analysis Services and the integration components for Microsoft Dynamics AX 2009.
– Become familiar with SQL Server Business Intelligence Studio.
– Navigate the multi-dimensional space of OLAP cubes.
– Import cubes from Microsoft Dynamics AX 2009.
– Fix broken cubes.
– Create new cubes from Microsoft Dynamics AX 2009.
– Deploy and process cubes.
– Read and write MDX expressions in KPIs.
– Step through the procedures for installing Role Centers for Microsoft Dynamics AX 2009.
– Modify existing Role Centers.
– Create new Role Centers.

To add this course to your Microsoft learning or start it right now; here you’re:

Building ASP.NET Reporting OLAP-Based Application Part-3

April 20, 2009

In the previous two posts building the Cube and building the Report, we discovered how BIDS helps in developing BI applications in robust, managed and organized way. I believe if you have few BI concepts you can do this walkthrough in 10 minutes.
Let’s come to the last layer which I see it’s the presentation layer. One question may come to your mind why I build ASP.NET application over Reporting Service? Why I don’t give the end user Reporting Service Server URL. Because of security? NO. Reporting Service Server can manage different types of security which doesn’t put headache on your development team but what if your end user need UI layer say in Silverlight? How can you embed in the Reporting Service. We have ReportViewer Windows\Web control which provides a very rich of functionality to View Reporting Service (Local and Server) Reports. In our walkthrough we use Server Report.
Let’s open our previous solution and add a new ASP.NET web application project: InternetSalesWebsite
Default.aspx page open in source view, switch to Design view. 


Read the rest of this entry »

Building ASP.NET Reporting OLAP-Based Application Part-2

April 19, 2009

In the previous post we learned how to build simple cube using BIDS, and if you’re follower I’ve forgot something important is deployment the cube on the Analysis Services.
1- We just need to add some attributes to the dimensions(DimPromotion, DimProduct) as each of which pure (contains just the key) for some reasons we need to show the user the name of product, or the promotion because it very hard to make human treat with numbers contrary to machines which prefer them. We shall add some attributes to the dimensions to make it meaningful.

2- Double click on DimPromotion; the dimension design window opened you find Data Source View, Hierarchies and Attributes; simply drag EnglishPromotionName from the Data Source View table to Attributes.
3- Repeat the previous step with the DimProduct to add EnglishProductName

Read the rest of this entry »