In the example below, I want to group on StateProvinceName, City and ResellerName. What I also want to do is have the Value display the State Code along with the StateProvinceName. Here is what I did to produce the desired results. 1. First you can see from the image below that I am grouping on 3 of my columns. 2. Here is what it looks like in my table now: 3. Remember, I want to display the StateProvinceName and StateProvinceCode. What I want do from here is Right Click on the StateProvinceName...
Read More
Today in my reporting services class, I was asked how to get the Snap to Grid dots to appear in the designer. Here are some of the areas I checked to see if I could get them to appear: 1. I went to Tools / Options / HTML Designer and from there I chose Ruler and Grid. I changed the Line Style to Dots and altered the spacing to 10 and I didn’t see them appear. 2. I also went to Windows Forms Designer / General and changed the LayoutMode to SnapToGrid. ShowGrid and SnapToGrid is set to True and I ...
A long time ago, Microsoft added a great feature to their Excel product. It allowed the capabilities to rotate text. Regrettably, this has been a long time waiting for reporting tools such as SQL Server Reporting Services. Another great addition to the SSRS 2008 R2 release gave us this same ability. We can now Rotate text. With that being said, here is a before look at the placement of our text value: What I want to do is take the text for Fiscal Year and rotate it for Vertical alignment. Here a...
Today I gave a presentation on how to create some awesome reports using the Sparkline, Map and Data Bar (all R2 features). I also discussed some of the different areas you could use expressions and showed some different examples. I am really excited that I had so many people join us today for Training on the T’s. First I want to share the TSQL script that I used for the my Sparkline report as well as the expressions used for that specific report. Queries (AdventureWorksDW2008R2): USE [AdventureW...