Monday 8 October 2012

Change the font style based on parameter in SSRS

How to change font style in SSRS 2008, SSRS 2012


               Like

               "Bold", "Normal", "Thin", ExtraLight", "Light", "Medium",
               "SemiBold", "Bold", "ExtraBold", "Heavy"



If your Parameter ShowSummary  = True than  change the Font Style to  "Normal" otherwise "Bold"

Step 1)

Create Parameter ShowSummary
Data type : Boolean
Default Values, Click Add and type True (Defining default Value = True)


Create New Parameter as ShowSummary, data type Boolean


Set default value as False so by default summary value will be False


Right click on your textbox, Select Textbox Properties, Select Font, Click on the Fx button besides Bold


as per the parameter value, show font type

Now run the reports, you can see that when you select show summary = true your text box font type appears "Normal" or it will show in "Bold "

Thanks




1 comment:


  1. You can subscribe for video clips update on Online trainng related to topics Micorsoft Axapta ERP, Microsoft Power BI ,SQL Administration and Online Training clips etc

    https://www.youtube.com/user/sksingh1980

    ReplyDelete