Comparison to the previous cell in a SSRS table

IIF(Fields!Cell.Value <> Previous(Fields!Cell.Value),"Solid","None")

SSRS Format

Date format :

format(Fields!Timestmp.Value,"dd/MM/yyyy HH:mm")

Number format:

FormatNumber(First(Fields!CastingActualAvgSlabWeight.Value),3) 

SSRS 'If' statement syntax

iif(conditionm, if_true, if_false)

Reporting Execution Log

SELECT * 

FROM [ReportServer].[dbo].[ExecutionLog2] 

ORDER BY TimeStart desc

http://blogs.msdn.com/b/robertbruckner/archive/2009/01/05/executionlog2-view.aspx

SSRS - Expression-based Connection Strings

="data source=" & Parameters!ServerName.Value & ";initial catalog=AdventureWorks

Specify connection strings parameters as a report parameter.

Expression-based connection strings are evaluated at run time.

http://msdn.microsoft.com/en-us/library/ms156450.aspx#Expressions

Data Warehouse Process

Source DB --> SSIS --> SSAS --> SSRS

• Application Database (Source DB).

• Definition of needs and requirements
• Design the Data Warehouse
• Construction of dimensions
• Construction of fact tables
• ETL
• Extract relevant data.
• Transform data to DWH format.
• Load data into DWH.
• Relational Data Warehouse Management.

• DATA Analysis
• Dimensions and cubes in an Analysis Services solution.

• Data Presentation – Reports.

SQL Server 2008 Data Warehousing
http://www.microsoft.com/sqlserver/2008/en/us/data-warehousing.aspx
Best Practices for Data Warehousing with SQL Server 2008
http://msdn.microsoft.com/en-us/library/cc719165(v=sql.100).aspx
An introduction to SQL Server data warehousing concepts (presentation)
http://searchsqlserver.techtarget.com/video/An-introduction-to-SQL-Server-data-warehousing-concepts
SQL Server Data Warehouse Cribsheet
http://www.simple-talk.com/sql/learn-sql-server/sql-server-data-warehouse-cribsheet/