This is a migrated thread and some comments may be shown as answers.

Field with space in name

5 Answers 332 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Ryan
Top achievements
Rank 1
Ryan asked on 15 Apr 2013, 01:02 PM
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.

5 Answers, 1 is accepted

Sort by
0
Accepted
Chavdar
Telerik team
answered on 18 Apr 2013, 10:31 AM
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

Have you tried the new visualization options in Telerik Reporting Q1 2013? You can get them from your account.

0
Ryan
Top achievements
Rank 1
answered on 18 Apr 2013, 06:19 PM
Thank you, the brackets worked.
0
Will
Top achievements
Rank 1
answered on 25 Jan 2017, 04:16 PM

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

Missing operator before 'Name' operand.

0
Will
Top achievements
Rank 1
answered on 25 Jan 2017, 04:23 PM
Never mind, I'm getting this error no matter what. It's really strange.
0
Will
Top achievements
Rank 1
answered on 25 Jan 2017, 04:30 PM
It was specific to the data sorting that we do in our Object Data Source, no worries :).
Tags
General Discussions
Asked by
Ryan
Top achievements
Rank 1
Answers by
Chavdar
Telerik team
Ryan
Top achievements
Rank 1
Will
Top achievements
Rank 1
Share this question
or