SSRS Guru – 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: http://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.

 

 

Are you a Wiki Ninja? http://technet.com/wiki

    – User Ed

 

 

Comments (7)

  1. Thanks Ed !! .. Just a feedback & suggestion .. It is easier to post on technet Wiki than on technet gallery .

    In MSDN  forumns , if we are asking any question while typing the title for the post we will get list of related posts , in similar way if we get on technet wiki and gallery , we can avoid duplicate posts 🙂

  2. Ed,

    Also under Technet wiki contest , why don't we have separate category for SQL Server XML and powershell !!!

  3. User Ed says:

    That is a good idea. Did you add it to our list of feature requests? You can add it to the Wiki section and the Gallery section: social.technet.microsoft.com/…/4703.feature-requests-for-technet-and-msdn-profiles-and-social-platform-tools.aspx

  4. User Ed says:

    I am proposing a PowerShell category for September (see the comments): social.technet.microsoft.com/…/19494.technet-guru-contributions-for-september-2013.aspx

    And because of your comment, I'm asking the community if they want a SQL XML category in the TechNet Guru contest: social.msdn.microsoft.com/…/do-you-want-a-sql-xml-category-for-the-technet-guru-contest

  5. SSSamal says:

    Hi Sathya,I have small requirement that is bugging me couple of weeks ago.Searched every where no result.I have a column that gives the list of regions under the divisions.I have drill down action on these tablix which gives region sales details in same report.but i want to select  multiple regions and see the details.the basic ideas is to keep old value and pass new value in the parameter.Could you please help me with these?

  6. User Ed says:

    SSamal, please ask in the SSRS (or appropriate) forum on MSDN/TechNet!

    Thanks!

  7. Computers Today (part 1 of 6)

    blogs.msdn.com/…/computers-today.aspx

    …..

    CS SPOTLIGHT: Girls in computer programming… why it matters!!!

    blogs.msdn.com/…/cs-spotlight-girls-in-computer-programming-why-it-matters.aspx

    Computational Thinking – Videos & Papers by Jeannette Wing

    blogs.msdn.com/…/computational-thinking-videos-amp-papers-by-jeannette-wing.aspx