CODEWITHSUNDEEP
reporting-servicesdatasetssrs-2008filtering
jhorton
jhorton

Reputation: 1059

How to filter an SSRS Dataset to return single record to be used in Textbox properties

I'm a total newbie when it comes to SSRS, so please excuse any use of wrong terminology. But I have been given a task to create a report that will have have a dataset that will contain records that will be used to set Textbox's font size and weight, underlined, justification, and text values. Something like this...

Size Bold Underlined Text Identifier
10 Y N My Title Title
10 N N Some Def Def1

Sorry about the misalignment in spacing. Not sure how to do a table here. But basically, I'm wondering if there is a way to write an expression that would allow me to get the record with the Identifier of "Title" and use the other fields in the textbox properties. Something like the where clause of Inline Linq. But I'm at a total lose and would greatly appreciate some help on this. Thanks again.

Upvotes: 0

Views: 2033

Answers (1)

PaulStock
PaulStock

Reputation: 11283

You should be able to do this. In the TextBox properties, select the FontSize property and click on <Expression..>. Then in the expression box, pick the correct Dataset and field which will contain the font size.

Then repeat this process for the other attributes.

enter image description here

enter image description here

Upvotes: 2

Related Questions