Sharepoint list dataset - is there any way to use display names?
SQL Server 2008 R2 Reporting Services, against a SharePoint 2007 list. Is there any way to run the query by display name instead of internal name or ID? I have to manage these reports from Dev to QA to Production, and each list has different internal names, but the columns have the same display names. I also cannot connect BIDS to the QA or Production servers to build the data sets, so I'm having to enter internal names by hand. Please tell me I'm missing an easy way to do this? PhiloPhilo Janus, MCP Author: Pro InfoPath 2007 Pro PerformancePoint 2007 Pro SQL Server Analysis Services 2008 Building Integrated Business Intelligence Solutions with SQL Server 2008 R2 & Office 2010 Blog @ http://philo.typepad.com/with-all-due-respect/
May 16th, 2011 11:03am

Hi Philoj, Based on my reading some SharePoint document about the difference between Display name and Internel name, I get your meaning. You want to query the display name instead of the internel name. If I misunderstand you please feel free to let me know. By generally, sharepoint list query internal name rather than display name, when you click Query Designer, it will return all the Internal name in XML query. You could also click dataset's fields tab to change the display name in report level. If you have any question about changing the display name or internal name in sharepoint, it will be better if you could post your issue at SharePoint forum to get a specify support. Thanks, Challen Fu Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Free Windows Admin Tool Kit Click here and download it now
May 16th, 2011 11:34pm

Circling back around on this project... No, that's not what I mean. I am connecting an SSRS report to a SharePoint list. The list has a column with the display name "Employee" but the internal name "733B4C69-14C6-438F-9E1C-D8A783ACE744". And since I can't connect directly to SharePoint from my dev box, to get that name I had to jump through some interesting hoops. When I write code against SharePoint, I have a standard utility that fetches the internal name using the display name because display names are very easy to coordinate between servers, while internal names ... make me invoke language unsuitable for professional company. These routines never fail, because I manage the lists and teach users not to have duplicate column names. Problem solved. I wish the SSRS SharePoint connector had the same option - to create a dataset using display names, because internal names don't belong outside the Sharepoint server. But in looking around, I guess it's not possible without writing a custom data provider. [sigh]Philo Janus, MCP Author: Pro InfoPath 2007 Pro PerformancePoint 2007 Pro SQL Server Analysis Services 2008 Building Integrated Business Intelligence Solutions with SQL Server 2008 R2 & Office 2010 Blog @ http://philo.typepad.com/with-all-due-respect/
June 8th, 2011 9:41am

Circling back around on this project... No, that's not what I mean. I am connecting an SSRS report to a SharePoint list. The list has a column with the display name "Employee" but the internal name "733B4C69-14C6-438F-9E1C-D8A783ACE744". And since I can't connect directly to SharePoint from my dev box, to get that name I had to jump through some interesting hoops. When I write code against SharePoint, I have a standard utility that fetches the internal name using the display name because display names are very easy to coordinate between servers, while internal names ... make me invoke language unsuitable for professional company. These routines never fail, because I manage the lists and teach users not to have duplicate column names. Problem solved. I wish the SSRS SharePoint connector had the same option - to create a dataset using display names, because internal names don't belong outside the Sharepoint server. But in looking around, I guess it's not possible without writing a custom data provider. [sigh]Philo Janus, MCP Author: Pro InfoPath 2007 Pro PerformancePoint 2007 Pro SQL Server Analysis Services 2008 Building Integrated Business Intelligence Solutions with SQL Server 2008 R2 & Office 2010 Blog @ http://philo.typepad.com/with-all-due-respect/
Free Windows Admin Tool Kit Click here and download it now
June 8th, 2011 9:41am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics