Archive for the ‘SSRS’ Category
The Story of Precision, Scale, and Length in SQL Server
Hi guys, Did you ever faced issues with BIG mathematical figures – related to either overflow or any other arithmetic errors. This may be applicable to SQL arithmetic operations or arithmetic operations you do with SQL table in SSIS etc. Well, check 1 more time, if you have any issues in your database design related [...]
January 28, 2013
· 
Khilitchandra Prajapati · 
No Comments
Tags: Arithmetic Overflow, Business Intelligence, Error, General, SQL Server, SSIS · Posted in: Business Intelligence, Free, General, Interview QA, Quick Fix, Quick Tips, Script, SQL Server, SQL Server 2012, SQLServerPedia, SSAS, SSIS, SSRS, T-SQL, Tutorial
MSSQL: Find total records of each Table in given Database
hi guys, i wanted to do a quick post on how you can find total number of records in each table of the database. here is the script you can use: USE <Your Database Name> GO ;WITH CTE_DATABASETABLESIZE (DATABASENAME, SCHEMANAME, TABLENAME, TOTALROWS) AS ( SELECT Â DB_NAME(), SCHEMA_NAME(SO.UID), SO.NAME, SI.ROWS FROM Â SYSOBJECTS SO Â INNER JOIN SYSINDEXES [...]
January 23, 2013
· Khilitchandra Prajapati · One Comment
Tags: SQL Server, SSIS · Posted in: Business Intelligence, General, Interview QA, SQL Server, SQL Server 2012, SQLServerPedia, SSAS, SSIS, SSRS
User ‘Domain\User’ does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed.
Hi guys, its seems like this issue have been faced by many prople. i have checked the solutions on web and found that not all answers contains the complete solution. so decided to put 1 complete solution here. in most of the places, you will find answers like… Run IE as Administrator -> Open Report [...]
January 16, 2013
· Khilitchandra Prajapati · No Comments
Tags: Business Intelligence, Microsoft, SQL Server, SSRS, UAC, Windows · Posted in: Business Intelligence, General, Interview QA, Quick Fix, SQL Server, SQL Server 2012, SSRS
E-Book Gallery for Microsoft Technologies
Hi guys, good morning !!! here is the list of cool FREE E-Books from Microsoft Press.
September 7, 2012
· Khilitchandra Prajapati · No Comments
Tags: ASP.Net, Career, E-Book, Free, Microsoft, Microsoft Press, Office, SharePoint, SQL Server, Visual Studio, Windows, Windows Azure, Windows Phone, Windows Server · Posted in: Business Intelligence, E-Book, Free, General, Interview QA, New Features, Quick Tips, SharePoint, SQL Azure, SQL Server, SQL Server 2012, SSIS, SSRS, Training, Tutorial, Windows
SSRS Chart – Displaying % sign on Y axis + Displaying % sign on Data Labels
Hi guys, Today i would like to show you the little trick for your SSRS graphs. Issue: I am displaying values (percentage values) in my bar charts as “Data Labels”. But the “Y” axis of my bar char still displays value without the “%” sign. What I need: The bar chart should display the “%” [...]
August 4, 2012
· Khilitchandra Prajapati · 6 Comments
Tags: Business Intelligence, Charts, Data Label, SQL Server, SSRS, Tricks · Posted in: Business Intelligence, Quick Fix, Quick Tips, SQL Server, SQL Server 2012, SSRS, Suggestion, Tutorial
SSRS Report is asking for Username and Password while executing
Hi all, I want to bring to your focus a very minor detail which could eat-up your time when it happens. This is the case when your SSRS report is deployed on ReportServer and you are accessing thru any application or interface e.g. SharePoint. Your SSRS report is using Integrated Security and hence no need [...]
June 21, 2012
· Khilitchandra Prajapati · No Comments
Tags: Asking for Username and Password, Execution, Fix, Report, SQL Server, SQL Server Reporting Services, SSRS, Tip · Posted in: Business Intelligence, Quick Fix, Quick Tips, SQL Server, SSRS, Suggestion, Tutorial
Quick-Fix: Report parameter with space in SSRS
Hi guys, One of the most common practices and a wise recommendation is to display selected report parameter(s) in report … may be in header or body of SSRS report. It’s a good reference when you export the SSRS report into available formats (Excel, PDF, Word etc.) Because if you don’t include/show selected parameter(s) in [...]
May 13, 2012
· Khilitchandra Prajapati · 3 Comments
Tags: Business Intelligence, Quick Fix, SQL Server, SSRS · Posted in: Business Intelligence, Interview QA, Quick Fix, SQL Server, SSRS
Spot/Highlight Minimum and Maximum value(s) in each row in Matrix report in SSRS :)
Hi all, How are you doing? Today I would show you; how you can highlight minimum and maximum values in an each row of matrix report in SSRS. Again, “there are lots of ways“, but that depends on what is your solution framework. If you are using standard T-SQL queries for reporting, then it’s easier [...]
April 26, 2012
· Khilitchandra Prajapati · 8 Comments
Tags: Business Intelligence, MDX, SSAS, SSRS · Posted in: Business Intelligence, MDX, Quick Tips, SQL Server, SSAS, SSRS, Tutorial
Line chart + Bar chart in SSRS Report
Hi All, “Language is the key for communication“. Having said that “Language” could be anything with a clear meaning of message/information to be delivered. Over the generations, we have one language which is never changed for communication among humans i.e. audio-visual communication. Developing charts for an organization for getting to know “how it’s team or [...]
March 12, 2012
· Khilitchandra Prajapati · 4 Comments
Tags: Bar Chart, Line Chart, SQL Server 2008 R2, SSRS · Posted in: SQL Server, SSRS, Tutorial
Dazzle your SSRS Report with SparkLines
Hi All, “SparkLines” is a new feature introduced in SQL Server Reporting Services 2008 R2. Fast Facts about SparkLines: •   It is the simplest way to make your data/values intelligent by showing them in visual way. •   Because it’s a tiny-chart representation, makes report elegant, meaningful and non-messy. •   Report users can choose to dig [...]
March 8, 2012
· Khilitchandra Prajapati · 2 Comments
Tags: SparkLines, SQL Server 2012, SSRS · Posted in: SparkLines, SQL Server, SSRS
