SSRS - How to - Conditional Color the Fields, rows in a Report using Expressions

Excellent Post on SQL Reporting "How to" - Conditional Color 1/4: The Basics. Report Expressions & Custom Code.

http://blogs.msdn.com/b/davidlean/archive/2009/02/17/sql-reporting-how-to-conditional-color-1-4-the-basics-report-expressions-custom-code.aspx



Happy  Reporting!!!

Repeating Tablix Column Headers with SSRS 2008

Repeating Tablix Column Headers with SSRS 2008

 

There seems to be an issue with repeating column headers using SQL Server 2008 Reporting Services. Typically you would highlight the row, right-click and select properties then you would be able to set the property for RepeatOnNewPage to True. I tried it and it does not work for SSRS 2008 R2.

Work Around:

Click on Black Arrow, at Right Side In your grouping pane, select advanced mode, then select your outermost static row; Click F4 or open Properties Window. You should then see the "RepeatOnNewPage" property and KeepwithGroup.

Set KeepwithGroup as --- After (None, Before and After)

RepeatOnNewPage ---True

 

Happy Reporting!!!

Add Page break to Row group in a table

To add a page break to a row group in a table, matrix, or list

1. Create a Parent Group and select Group By Filed.
2. In the Grouping pane, right-click a row group, and then click Group Properties.
3. On the Page Breaks tab, select Between each instance of a group to add a page break between each instance of a group in the table.
4. Optionally, select Also at the start of a group or Also at the end of a group to specify that a page break be added when a group starts or ends in the table. 
5. Click on the Column and go to visibility option and "Hide" the column.

SQL Server 2008 Arithmetic Calculations

Today I small arithmetic calculations in SQL Server 2008 Please find the below.

SQL Server arithmetic calculation Add, Subtract, Multiple and Divide

select 0+0 as test1, (0/cast((0+0) as decimal(5,1))*100) as test2

Access Denied error while trying to Preview TFS Added SSRS Report

Access Denied error while trying to Preview SSRS Repor

You might get a message "An error occurred during local report processing. Access Denied. (Exception from HRESULT: 0x80030005 (STG_E_ACCESSDENIED))" while you try to preview a report you developed under VS 2008 and which has been added to TFS or any source control.

The reason for this is due to the .data file associated to the report which is read only state. You can resolve this issue by either checking out the .data file or un-checking the read-only attribute of the file under local folder.

Here is a nice article post by about the issue

http://ddkonline.blogspot.com/2009/07/fix-sql-reporting-services-2008-error.html