Who is online?  0 guests and 0 members
Home  »  Blogs  »  kylewalker: March 2011

Communifire Blogs

Blogs RSS Feed

kylewalker :March 2011 postings

kylewalker

Action Packed Maps in Your Reports

3/31/2011 by kylewalker  -  Comments: 4  -  Views: [2783]

A couple weeks ago I went over some tips for customizing your maps in Reporting Services 2008 R2. This week I'm going to stay on the same topic, but instead of customizing your legend ranges , I thought I'd go over a pretty cool interactive option that is available. Now, the action I'm talking about is just like any other action that you can set to any object within your report, but the reason I like this so much is that you can apply the action to a spatial representation of your data. The firs...

Read More

kylewalker

Custom Distributions for Map Legends in SSRS

3/16/2011 by kylewalker  -  Comments: 1  -  Views: [7669]

If you haven't experimented with maps in Reporting Services 2008 R2, I strongly encourage you to find some sample data and play around with the map options that are available. Nowadays, most shops deal with some sort of geographic or spatial data, whether it's power usage by county, sales by state, or even something like social networking activity by country. And the fact of the matter is, a plain tablix can be pretty bland. Adding even the simplest of maps could liven up your report and grab th...

Read More

kylewalker

Cleaning and Separating Data Using an SSIS Script Component

3/7/2011 by kylewalker  -  Comments: 2  -  Views: [7347]

A couple weeks ago we received a forum post here on BIDN about a messy column coming out of a flat file source. The example of the value given looked like this, "1a2bb3ccc4ds5fsdf6ter", and the desired output was all of the letters in one column and all of the numbers in a different column. So "abbcccdsfsdfter" in Column1 and "123456" in Column2. The most straight forward method I could think of was to accomplish this was by using a Script Component. And here are the steps to do it. First of all...

Read More

Page 1 of 1 (3 items)