Display first record occurance in textbox in RB

Dear Anyone,

I would like to display the first occurance of a record as a text box outside that of the report. I would like to do this in Report Builder. Is this possible?

Thanks,
Joseph

Try:

Use an expression like

= First(Fields!FieldName.Value, "DataSet1")

where field name = the mane of your record field; and DataSet1 is your dataset name.|||

It doesnt seem to work. I'm using this on a new textbox in RB. Am I doing it wrong?

|||Heres the error that gets displayed:

The Value expression for the textbox ‘textbox’ has a scope parameter that is not valid for an aggregate function. The scope parameter must be set to a string constant that is equal to either the name of a containing group, the name of a containing data region, or the name of a data set. (rsInvalidAggregateScope)|||If you just want the dataset scope, leave out the second parameter:

= First(Fields!FieldName.Value)

RB doesn't expose the RDL field names directly, so you'll have to guess that part. It's usually equal to or a predictable variant of the text in the column header.