Column name with spaces is not working

  • Hi

    I have a table in which one column has space(like "First Name"). Using SSRS I m passing columns to fetch the records of that particular column. But my problem is that if I pass column with spaces(First Name), in preview it is saying that "'First' column does not exists". I tried keeping square brackets ([]) around the columns([First Name]), it is saying parser error. How can I resolve this issue?

  • Quick suggestion, create a view with compliant names, i.e. replace spaces with underscores, then specify the proper field name in the report. There is a three year old Connect entry on this, Allow any character in SSRS Dataset Field Names, wouldn't hold my breath on this one.

    😎

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply