Groups | Blog | Home
all groups > sql server reporting services > october 2004 >

sql server reporting services : The expression referenced a non-existing field in the fields collection


Bruce Johnson [MSFT]
10/4/2004 2:49:44 PM
This sounds like you referenced a field from textbox without placing it
inside of an aggregate function. In this particular case the textbox is not
a member of a data region.

You can only place field expression in these type of textboxes when they are
contained in an aggregate function (common ones are First() and Count()).
Additionally the aggregate function call should specify the dataset.

What I think you placed inside of the textbox:
=Fields!SomeFieldName.Value. When this report is built or previewed the
following error is raised:
The value expression for the textbox 'Region' contains an error: The
expression referenced a non-existing field in the fields collection.

A sample solution: =First(Fields!SomeFieldName.Value, "DataSetName")


--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services

This posting is provided "AS IS" with no warranties, and confers no rights.


[quoted text, click to view]

Ponnurangam
10/4/2004 7:41:11 PM
Hi,

I have two datasets im my report

I am trying to connect one of the field of a dataset to a textbox value, I
get the following error:

The expression referenced a non-existing field in the fields collection

Any help is appreciated

AddThis Social Bookmark Button