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

Robocopy used to move, copy files from one server to other server

Reference:
http://technet.microsoft.com/en-us/library/cc733145.aspx


:begin
@echo off

@set SourcePath=\\<<Server Name>>\<<Folder Name>>
@set DestinationPath=\\<<Server Name>>\<<Folder Name>>

echo --- Moving Files from one Server to Another Server  ---
ROBOCOPY %SourcePath% %DestinationPath% /mov


if errorlevel == 0 goto :success

echo ### Error in Moving Files from %SourcePath% to %DestinationPath%
echo .
goto end

:success
echo Successfully Moved Files from %SourcePath% to %DestinationPath%
echo .
goto end

:end