D J Horton Consulting Ltd

Personal reference to useful tips and tricks for SQL Server, SQL Server Reporting Services and Crystal Reports.

My alternative to scraps of paper lying about.

Thursday, 29 September 2011

A3 Landscape dashboard layout - SSRS

For A3 Landscape dashboard style settings:

Report Properties:
Grid Spacing  0.2cm

    Width  42cm
    Height  0cm

Margin all 0.5cm

    Width  42cm
    Height  29.7cm

Body Properties:
    Width  41cm
    Height  28.7cm

Monday, 5 September 2011

Resolving Common Connectivity Issues

Useful link to resolving common connectivity issues. Applies to SSAS but also proves to be of use with IIS, SSRS & SQL Server.