Tuesday, October 25, 2011

'SQL Server Denali' No More: SQL Server 2012 Announced.

Wish you Happy Diwali and New Year to all of my friends & there family.

Now some important announced of SQL Server.

Microsoft VP Ted Kummert announced the official name of the next version of the SQL Server – SQL Server 2012. The version of the SQL Server will be 11. The release date is estimated in the first half of the year 2012.

Microsoft also announced that the new BI self-service reporting tool, codename “Crescent”, (Get more details of Crescent in my previous blog post) will be given the official name Power View. Power View (Crescent) is a highly interactive data exploration tool and a preview is already available with the CTP3 of Denali.

SQL Server 2012 Power View (Crescent) is one of the new tools that will be released with the next version of SQL Server. Currently it is available in the SQL Server Denali CTP, the beta version of the next SQL Server, SQL Server 2012.

The business user will start the application by opening an existing Crescent report or choosing a BISM – Business Intelligence Semantic Model (Get more details of BISM in my previous blog post) to start from. This BI Semantic Model is also a new feature in the Denali release. As the name says, it is a semantic model/layer on top of your data warehouse. Using this model abstracts the data warehouse complexity for a business user, and enables him/her to create reports with Crescent.

Posted by - SUHAS R. KUDEKAR (MCTS - Microsoft Business Intelligence)
Learning Office 2010 + SharePoint 2010 + SQL Server 2008 R2

Monday, October 3, 2011

Change the Look & Fill of the Report Manager.

In Previous Blog Architecture Diagram of SSRS  post we were getting the completed diagrammatic overview of SSRS Architecture. In that a Web-based report access and management tool is available named as Report Manager.

Definition - Report Manager is a Web-based report access and management tool that we use to administer a single report server instance from a remote location over an HTTP connection. we can also use Report Manager for its report viewer and navigation features.

Different type of Report Manager Properties Available on clicking on diffrent available Tab.
·         Site Settings Properties
On the Site Settings page, we have General Properties, Security and Schedule
Report Manager – Data Source Properties with the exception of Dependent Items. Dependent Items page will list all items (reports, data sets) that use this particular Data Source.

·         Search Properties
We can now search in SSRS Report Manager! Type in our keyword, and a way we go! It will find your report, your data set, your folder, or even your report part.

·         Report Contextual Dropdown Properties
When we hover over a report item and click on the down arrow, we will be able to move, delete, edit in Report Builder 3.0, and explore other properties, to name a few.

·         Report Properties
We have links for : properties, data sources, shared data sets, subscriptions, processing options, cache refresh options, report history, snapshot, and security.

·        Shared Data Set Properties
Share data sets among diffrent reports.

·         Shared Data Set Caching Properties
Cache these shared data sets.

We can use Report Manager to browse the report server folders or search for specific reports. we can view a report, its general properties, and past copies of the report that are captured in report history. Depending on your permissions, we might also be able to subscribe to reports for delivery to an e-mail inbox or a shared folder on the file system.

How we can Start Report Manager

ü  To start Report Manager from a browser Open Microsoft Internet Explore

ü  In the address bar of the Web browser, type the Report Manager URL.
By default, the URL is http://<ComputerName>/reports.

ü  The report server might be configured to use a specific port. For example,
http:// <ComputerName>:80/reports or
http:// <ComputerName>:8080/reports.

Change Bascic look & fill of Report Manager 
To change the top area color in Report Manager, please refer to the following steps to achieve this:

1.      Navigate to ReportingServices.css file.
Path: <Drive:> \Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportManager\Styles
2.      If want backup the ReportingServices.css file before you modify it, open it with notepad format.
3.      Change the following portion in ReportingServices.css file:

Original Available - table.msrs-header { background-color:#fff; }

After Changed - table.msrs-header { background-color: #f00; }

This way we can change the Look & Fill of the Report Manager.

Posted by - SUHAS R. KUDEKAR (MCTS - Microsoft Business Intelligence)
Learning Office 2010 + SharePoint 2010 + SQL Server 2008 R2