Menu
I am getting this error in the expression editor for a chart control.
Category - Fields
Item -
'Fields selection frame' is where I see the error
The chart IS linked to a dataset though and it works too; how else would the chart be populated with meangingful data when I run it? :)
Does anyone know why this occurs?
[pic not supplied due to corp firewall]
331
You have to add the dataset for the rdlc report. In report design you can configure the dataset fields. If you have already added the dataset for this, there is other case that you have to refresh the dataset if you modify it. Save this answer.
A dataset contains the information that is needed to retrieve a specific set of data from a data source. There are two types of datasets: embedded and shared. An embedded dataset is defined in a report and used only by that report.
In the Report Data pane, right-click the name of the data source, and then click Add Dataset. The Query page of the Dataset Properties dialog box opens. In Name, type a name for the dataset or accept the default name. The dataset name is used internally within the report.
To edit a query field or a dataset field In the Report Data pane, right-click the field, and then click Field Properties. In the Fields page of the Dataset Properties dialog box, click an existing field to select the row. Change the name of the field or the value of the field. Select OK.
Looks like a bug in SSRS i.e. the fact that it works anyway but displays an error in the expression editor
106
It only works when you remove the filter. Its broke, if you put a filter in you get the erroneous error message and no data in your chart. If you remove the filter you get your chart but of course not filtered the way you want. I'm using 2008.
38
In case anyone else stumbles upon this I can confirm that this still occurs in SQL Server 2008 SP2 (Microsoft SQL Server Reporting Services Designers Version 10.0.4000.0) and also if the report is opened in Report Builder 3.0 (2008 R2).
44
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
