Post reply

Column name with spaces is not working

  • October 17, 2014 at 10:57 pm

    #297668

    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?

  • October 18, 2014 at 1:38 am

    #1753298

    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