Field with space in name

[Ryan]

I am trying to use a field with a space in its name (eg:"State ID") for the value of a textbox, but I cannot figure out the correct syntax to do this in the design view.

When I open up the expression editor nothing shows up when I select fields. How can I do this? The field is from an SqlDataSource.

[Chavdar]

Hi,

You should use square brackets ('[', ']') to surround the name of the column if it contains a space character. For example: ="Fields.[State ID]".

The expression editor shows the fields only when the data item (Report, Table, Graph) has a valid data source assigned to its DataSource property. Verify whether the SqlDataSource is assigned to the DataSource property of the report and then try again.

Kind regards,
Chavdar
the Telerik team

[Ryan]

Thank you, the brackets worked.

[Will]

This didn't work for me. I have = Fields.[Provider Name] and I get an error:

Missing operator before 'Name' operand.

[Will]

Never mind, I'm getting this error no matter what. It's really strange.

[Will]

It was specific to the data sorting that we do in our Object Data Source, no worries :).