Archive

Archive for the ‘SSRS’ Category

Power Pivot and Power View now available in Excel 2013.

August 1, 2012 1 comment

In Excel 2013, much of that functionality, including the infrastructure that supports it, is built directly into the Data Model in Excel. Without installing a separate add-in, PowerPivot and Power View add-ins are installed by default. But they are not automatically enabled.  You have to do some menu/dialog box acrobatics to turn them on, but it’s a one-time set-and-forget requirement.

If you’d like to try it yourself, click through File|Options|Add-Ins|Manage COM Add-Ins|Go… and then enable the add-ins by checking them off and clicking OK.

Read more…

SQL Azure Reporting.

SQL Azure Reporting
SQL Azure Reporting enables developers to enhance their applications by embedding cloud based reports on information stored in a SQL Azure database.  Developers can author reports using familiar SQL Server Reporting Services tools and then use these reports in their applications which may be on-premises or in the cloud.

Change the Look & Feel of the Report Manager.

Why we need to change the Look & Feel of the Report Manager?

Ans- If we have different environments to deploy the reports like QA, DEV, PROD. that time User/Developer can get the more idea once open the Report Manager. Read more…

User Account Control (UAC) and SSRS

May 21, 2012 3 comments

In SQL Server 2008 R2 Reporting Services people are facing error as “User ‘DomainName\UserName’ does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed”. I have seen people struggling with this Issue. Here is more light on how to fix this & get your SQL Reporting Services Report Server URL working. Read more…

Convert Number Value Into Words using SSRS

May 21, 2012 1 comment

For Display Amount Value into Words with SQL Reporting Services 2008, we can implement the same with following two ways.

· Database Function

· Custom Assembly Read more…

SSRS Expressions

January 18, 2011 Leave a comment

Very practical expressions, when you create SSRS Reports in your day to day development.

1. Lets start with the easiest of the expressions i.e. To get Today’s date

=Today Read more…