Tuesday, September 25, 2012

Grouping in SQL RS

One issue we recently had was that grouping wasn't filtering properly on the report.  If you are having issues grouping and filtering items in Reporting Services, make sure the detail row is not deleted.  If you have to, set the Row Visibility to hidden, but don't delete the detail.

This solved our filtering issue.

Wednesday, September 12, 2012

Database documentation tool - Elsasoft SqlSpec

Documentation is probably something that many people dread.  This tool automates the process of generating documentation across many platforms, including Analysis Services, Teradata and Oracle.

Database documentation tool - Elsasoft SqlSpec:

'via Blog this'