14 Oct 2013
By Allen
0 Comments
Custom Chart Palettes in SSRS

Custom Chart Palettes in SSRS

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 object and choose Properties For Palette, choose 'Custom' In the properties window, not find the custom palette settings. A dialog box appears that allows you to select each color to include in the custom palette.   Below I have set the first color in the palette…
Read More
14 Oct 2013
By Allen
0 Comments
Customized SSRS reporting template.

Customized SSRS reporting template.

SSRS,
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. These are lessons learned while developing a reporting library for GE Oil & Gas, a company with very specific rules for their corporate image.  We created one template for Portrait reports, one for Landscape and one for charts  shown above (with corporate colors).   GE even has their own company font.  As a multi-national corporation, they normally need different logos displayed depending on the country where the report is rendered.   That…
Read More
31 Aug 2013
By Allen
0 Comments
Sharing SQL 2012 data in SharePoint 2013

Sharing SQL 2012 data in SharePoint 2013

SharePoint, , , , ,
I enjoyed presenting at SQL Saturday #223 in Oklahoma City last week.  If you attended, you will find the presentation and Data Solution files below.  The session recording is available at UserGroupTV, thanks to Sean. Session Description: Microsoft SharePoint is a collaboration software that provides a web based portal for business intelligence, content management and document sharing. In this session get an overview of the basics of sharing a SQL table as a 'List' using Sharepoint and SSIS. Next we move on to fun stuff of integrating SQL Server Reporting Services integration. Finally we look at how to give users…
Read More
22 Aug 2013
By Allen
0 Comments
How to configure Reporting Services 2012 for SharePoint 2013 integrated mode

How to configure Reporting Services 2012 for SharePoint 2013 integrated mode

SharePoint, SSRS, , ,
These are my installation notes because I did not find a clear tutorial for configuring SQL Server Reporting Services 2012 on a SharePoint 2013 server in Integrated Mode.  I found lots of SharePoint 2010 articles, but SharePoint has changed and now Reporting Services is actual a Service Application within the SharePoint farm. This post is aimed at setting up a single server development environment.  It assumes you have already installed the following: SharePoint 2013 SQL Server 2012 SP1 (Enterprise or Developer) SQL Server 2012 Reporting Services for SharePoint 1. Install the SSRS Service in SharePoint.  This is best done through…
Read More
10 Apr 2013
By Allen
0 Comments
Getting SQL data into SharePoint

Getting SQL data into SharePoint

BI/DW Projects, Microsoft SQL Server, , , , ,
In March, I was invited to speak at the OKC SQL Users Group and I never got the slide deck posted. So here it is to help get you started. Sharing SQL data in SharePoint from Allen Smith Session Level:  Beginner SQL and Beginner SharePoint Session Abstract:  Microsoft SharePoint is a collaboration software that provides a web based portal for business intelligence, content management and document sharing. In this session we will start with the basics of sharing a SQL table as a 'List' in Sharepoint. Next we move on to fun stuff of integrating SQL Server Reporting Services integration.…
Read More
13 Jul 2012
By Allen
0 Comments

Bulk Update SSRS Subscription Information

Microsoft SQL Server, SSRS, ,
I have a current client who needed to update information in every SSRS Subscription on their production server. The main reason was they were moving domains.  This meant updating user names and pointing the subscriptions to a new file share server where it saves reports. This is a standalone instance of SQL Server 2008 R2 Reporting Services, not in SharePoint integrated mode. It finally dawned on me that there is no bulk management tool for SSRS reports or subscriptions. So until I get time to learn VB.net and build a tool we needed a quick way to view and edit…
Read More
05 Jun 2012
By Allen
0 Comments
SQL Rally 2012 BI Track Highlights

SQL Rally 2012 BI Track Highlights

SQL Server, SSAS, SSIS, SSRS, , , , , , , ,
When I got back from SQL Rally 2012 a few weeks ago in Dallas, I shoved the notes into my laptop bag and took off for vacation.   I still want to share a few of the highlights of my trip.  These were some excellent speakers and I hope to see them again at future events. Sessions: Tuning Analysis Services Performance by John Welch Presentation John did an excellent job of explaining the basics of the processing options in SSAS. What was interesting was his experience splitting up jobs to increase performance.  Process Full will process all the dimensions and facts…
Read More
09 Dec 2011
By Allen
0 Comments

SSRS Data Driven Subscription Troubleshooting

SSRS, , , , , ,
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. You must have SSRS configured to run with an 'Execution Account' Data Sources must not have your Data Sources folder hidden with the option 'Hide in tile view'.  If you check that box, you will be unable to select a data for…
Read More
02 Aug 2011
By Allen
0 Comments
SSRS Adding “Image Not Available” as Alternate Image

SSRS Adding “Image Not Available” as Alternate Image

Microsoft SQL Server, SSRS, , , ,
I just had a requirement to build a report which had images stored in the database. SSRS handles that fine by just setting the image object to 'database' and then selecting the field. The challenge was adding an alternate image or text when there was no image stored in the database. SSRS makes it difficult because there is no method to dynamically change the image type on the image container itself, such as changing from 'database' to 'external' image on a web server. OPTIONS: Store the 'Not Available' image in the table and write a query which pulled only that…
Read More
01 Jul 2011
By Allen
0 Comments

Using SQL to Build MDX parameters

SSAS, SSRS, , , , , ,
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 build the parameter list was by querying the date dimension database table. When adding a date parameter to the report dataset, SSRS will automatically build a hidden dataset which pulls the list of available dates from the cube. For this example, I left that data…
Read More