Cognitive Information

Custom Chart Palettes in SSRS

This article is a follow up to the Cognos article on creating a custom color palette.  Custom palettes are pretty common when companies start to standardize their corporate image across all company communications. Make a copy of your report template. Name it ‘MyCorp Chart Report’ In the report area, add a chart Right-Click the chart […]

Bulk Update SSRS Subscription Information

Some tips for bulk updating subscriptions in SQL Server Reporting Services 2008 R2.

SSRS Adding “Image Not Available” as Alternate Image

I just had a requirement to build a report which had images stored in the database and show a ‘not available’ image when data was not available. This method uses stacked image objects and the visibility properties.

Using SQL to Build MDX parameters

I had a client report which needed a parameter list to default to the previous closed financial period date. The SSAS cube includes reporting periods into the future which have data entries even if the month has not been ‘closed’ by accounting department. Without a ‘Month Closed’ flag in the cube, the only way to […]

Business Intelligence & Data Warehouse Consulting

%d bloggers like this: