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
Display first record occurance in textbox in RB
Hot Topic
- user defined function in a select
- SQL Server 2005 Remote Connection Problem... Big Time.
- HOW to pull merge subscriptions in SQL server 2000 using stored procedures ??? (URGENT)
- Another Stored Procedure Question...
- SQL 2000 and 2005 on same server
- Read only or hidden report parameters in Reporting Services
- Paging large result sets
- SQL Server Destination [733] Error
- Basic VS Advanced Integration Services
- SecurityFilters in Report Model
SQL Server
- Is this method possible?
- Loooonnngggg delay in loading due to "pre-validation". Can it be turned OFF?
- Instalation SQL 2005
- sql server management studio nov ctp
- Migrating SSIS Packages to Production and Job Scheduling
- Error when trying to create "datasources"
- Report Builder - Editing existing report
- Which Replication Topology?
- HTTP access for standard Analysis Services Edition of SQL Server 2000 issue
- Diagram to Image
Display first record occurance in textbox in RB
JPaulraj
Use an expression like
= First(Fields!FieldName.Value, "DataSet1")
where field name = the mane of your record field; and DataSet1 is your dataset name.
maruthi.vj.
It doesnt seem to work. I'm using this on a new textbox in RB. Am I doing it wrong
WorldChoice
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)
Joe A
= 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.