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 Def1Sorry about the misalignment in spaci开发者_JAVA技巧ng. 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.
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.
精彩评论