Querying SharePoint List from Reporting Services returns only “not null” columns

Links (12/13/2007) « Steve Pietrek’s SharePoint Stuff

Links (12/13/2007) « Steve Pietrek’s SharePoint Stuff — Fri, 14 Dec 2007 04:46:20 GMT

PingBack from http://stevepietrekweblog.wordpress.com/2007/12/13/links-12132007/

re: Querying SharePoint List from Reporting Services returns only “not null” columns

cneiger — Wed, 25 Mar 2009 23:40:38 GMT

Has anyone figured out how to specify columns that have a space in the column name? I've tried using underscore instead of space, wrapping the field in single quotes, wrapping the field in double quotes, wrapping the field in square brackets...all to no avail.

re: Querying SharePoint List from Reporting Services returns only “not null” columns

MichealHunt — Fri, 29 May 2009 20:35:04 GMT

cneiger,

have you tried using _x0020_ in place of the space?

re: Querying SharePoint List from Reporting Services returns only “not null” columns

rakesh.micro — Tue, 18 Aug 2009 13:08:40 GMT

Hi I am Querying over Infopath forms Library, I am not able to get any data for the columns present in Form.

Iam able to get the data when the column is in List.

Please suggest how to do for SSRS Sharepoint over Infopath Forms..

Thanks in advance