Set FontFamily Runtime

Hey Guyes,

I'm developing SSRS 2005 Reports in multi languages (i.e. regional language like hindi, marathi)

here i'm sending font name from database field with the help of expression in FontFamily Property of textbox as follows

FontFamily =IIF(Fields!DistrictNameRegional.Value<>Nothing,CStr(Fields!FontName.Value),"Tahoma")

It don't work.

But when i'm Writting like this

FontFamily =IIF(Fields!DistrictNameRegional.Value<>Nothing,"Shivaji01","Tahoma")

It works.

Plz tell me where I'm wrong with this.

[950 byte] By [SandipShinde] at [2008-1-1]
# 1

It should work for any value in the true part of your IIf condition because it will take the default font. It works for me for all cases.

Make sure your FontName field returns the correct value "Shivaji01"

Shyam

ShyamSundar at 2007-9-7 > top of Msdn Tech,SQL Server,SQL Server Reporting Services...
# 2

Thanx Shyam,

there was problem with there is Trim Function missing :(

it is working now

SandipShinde at 2007-9-7 > top of Msdn Tech,SQL Server,SQL Server Reporting Services...
# 3
Can you mark my post as answer?
ShyamSundar at 2007-9-7 > top of Msdn Tech,SQL Server,SQL Server Reporting Services...

SQL Server

Site Classified