Cognitive Information

Archive for SSRS

Tulsa TechFest Presentations

Thank you to all who attended my sessions at Tulsa TechFest. Downloads of each presentation are available.

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 […]

Customized SSRS reporting template.

Large reporting projects can be simplified with a good template as a starting point. Design templates can store the company header with logo, company color palette, font preference and layout.

How to configure Reporting Services 2012 for SharePoint 2013 integrated mode

A tutorial for configuring SQL Server Reporting Services 2012 on a SharePoint 2013 server in Integrated Mode on a single server.

What’s New in SQL Server Reporting Services (SSRS) 2012

This is a short summary of new features found in SQL Server 2012 Reporting Services.

Syncronize Reports across SSRS Servers

Well, this article is one of those “I should have said…” but I hope this helps better address the issue of synchronizing reports across multiple Microsoft SQL Server Reporting Servers.

Bulk Update SSRS Subscription Information

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

SQL Rally 2012 BI Track Highlights

PASS SQL Rally in Dallas, TX had some great speakers. Here is my list of some great sessions on the business intelligence track of the conference.

SSRS Data Driven Subscription Troubleshooting

Microsoft SQL Server Reporting Services (SSRS) 2008 R2 will only allow data driven subscriptions under certain conditions, including data source security and server configuration options. SSRS Subscriptions always work great and easy in the demos and training classes. The following is the list of requirements to actually get them to work with in a data driven environment.

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.

Business Intelligence & Data Warehouse Consulting

%d bloggers like this: