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.

 

SathyanarrayananS's avatar 

  

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:

 

Guru Award  SQL Server Reporting Services, Power View, & SQL Server Integration Services Technical Guru - July 2013  

Gold Award Winner

 

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!"

Silver Award Winner

 

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