July SSRS Guru - SathyanarrayananS brings us "Multi Font Color / Multi Font Size within a Single Field / Textbox"
It's time for another July TechNet Guru winner!
SathyanarrayananS is our SSRS/SSIS TechNet Guru for July! See the TechNet Guru Contributions for July 2013.
Sathya's SQL Server Blog: https://www.allaboutmssql.com/p/about-me.html
Here is the gold medal article:
SSRS: Multi Font Color / Multi Font Size within a Single Field / Textbox
Now let's look at the winning articles:
SQL Server Reporting Services, Power View, & SQL Server Integration Services Technical Guru - July 2013 |
|
SathyanarrayananS | SSRS - Multi Font Color / Multi Font Size within Single Field / Textbox | Peter Laker: "Most useful of the two for me." Ed Price: "Very common scenario. The code and comments help walk us through it. Good job!" |
|
Shanky_621 | How to Transfer Records from SQL Server to Postgres | Peter Laker: "Excellent article. Very close second." Ed Price: "Another useful article! Good detail." |
Two great articles for this category, and hopefully something for us to build on. Thanks to both entrants, keep the articles coming!
And here's an excerpt from the article:
Consider below sample code is my dataset query:
DECLARE @UnitsOfMeasurement ``TABLE (Measurement ``VARCHAR`` (50),Units ``VARCHAR`` (20))
INSERT @UnitsOfMeasurement ``SELECT'Area'``,``'m2'
INSERT @UnitsOfMeasurement ``SELECT'Volume'``,``'m3'
INSERT @UnitsOfMeasurement ``SELECT'Luminance'``,``'cd/m2'
INSERT @UnitsOfMeasurement ``SELECT'Time'``,``'s'
INSERT @UnitsOfMeasurement ``SELECT'Electric current'``,``'A'
SELECT * ``FROM@UnitsOfMeasurement
I have added single column on the report as shown in below screenshot:
The expression for the UnitsOfMeasurement column is as follows:
= Fields!Measurement.Value + ``" - "+ Fields!Units.Value
===================================
Read the rest here:
SSRS: Multi Font Color / Multi Font Size within a Single Field / Textbox
Thanks to SathyanarrayananS for your great contribution to the TechNet Guru contest! You can read about all the July winners here: TechNet Guru Awards - July 2013
Also, for the August Guru competition, see TechNet Guru Contributions - August 2013.
Please join me in congratulating SathyanarrayananS on his win!
Are you a Wiki Ninja? https://technet.com/wiki
- Ninja Ed