Set Text Box FontSize property dynamically with DataSet value

• Possinator

  Hall of Fame

  Points: 3422

  More actions

  November 17, 2011 at 1:16 pm

  #252099

  This is my first question posted. I've scoured the interwebs and haven't seen a similar topic with a valid answer.

  Source database version: 10.50.1765.0

  Report Builder 3.0 (10.50.1600.1)

  I have limited permissions on the db

  Following the methods described by Barry King in this article:

  http://www.simple-talk.com/content/print.aspx?article=722

  I created a set of tables to store values for report elements and inserted appropriate values. (I don't know if the tables are relevant to the question, but the definitions are attached if needed). A dataset imbedded in the RDL returns one row with many columns for the report style. The text is on the attached, under --STORED PROCEDURE TO RETURN STYLE DATA.

  The style expressions are added like: =First(Fields!rptHeaderTitleFontSize.Value, "ReportStyles").

  This works just super for every property except FontSize. I thought maybe because the value is stored as a varchar(80), so I tried : =CInt(First(Fields!rptHeaderTitleFontSize.Value, "ReportStyles")). Didn't help. The font size renders (in report builder) with the default value (10pt). Same when exported to excel or pdf.

  Any idea how to make the FontSize property accept (and use) a dynamic value?

  Thanks in advance for any thoughts.

  Love you guys! [gender applied neutrally]

  ~ Cyndi

  [font="Courier New"]Looking for a Deadlock Victim Support Group..[/font]

• Possinator

  Hall of Fame

  Points: 3422

  More actions

  November 17, 2011 at 6:18 pm

  #1409655

  Agrrrrhhhh. I'm an idjit.

  Need to pass 10pt, not just 10.

  Derp.

  [font="Courier New"]Looking for a Deadlock Victim Support Group..[/font]