Call Us Today! 1-800-895-3254
[email protected]
Logo
Microsoft Project Services
Integent has specialized consulting and training services to handle all your project and resource management needs.
VIEW APPLICATIONS
Microsoft Training
Integent offers a comprehensive portfolio of training services, with an ideal fit for every organization. Ranging from general training courses to custom solutions, we have you covered.
See Full list of Courses
Learn About Training For
Microsoft Consulting
Integent provides consulting services for a variety of Microsoft applications including Microsoft Project, Project Online, Project for the Web, Dynamics 365, and Microsoft SharePoint.
Learn About Consulting For
Microsoft Support
Microsoft technologies set the standard for project portfolio management, business applications, collaboration, and more. Integent has flexible solutions to support every customer.
Learn About Support For
Microsoft Project
Integent has the knowledge and experience to help design and deploy a solution to help your organization manage projects and resources more effectively
Learn About Microsoft Project
Microsoft Dyamics 365
Integent can help you nsure business continuity with a custom cloud solution that connects sales, service, finance, and operations teams to deliver results.
Learn About Microsoft Dyamics 365
Microsoft SharePoint
SharePoint is Microsoft’s collaboration platform that is a place where team members can communicate, exchange data, share files and much more.
Learn About Microsoft SharePoint
Microsoft Power Platform
Consisting of Power BI, Power Apps, Power Automate and Power Virtual Agents, the Microsoft Power Platform helps streamline and improve business functions.
Learn About Microsoft Power Platform
About Integent
Integent was founded in 2009 on the principles of building long-lasting relationships with customers, exceeding expectations, and providing outstanding customer service. 

We’re dedicated to providing a customized solution backed by our knowledgeable team of Microsoft experts.
Discover What Makes Us Different
GSA Schedule
Integent is GSA Schedule Contract holder. A GSA schedule helps simplify selling our services to government customers.
Read More Here
News
Stay informed on Integent’s latest company updates and other important industry information. Our passion is customer success.
Read The Latest News
Videos
Learning new software doesn’t have to be difficult with our library of dozens of free training videos. Our video training always has something new.
Browse Our Training Video Library
Blog
Our industry experts share best practices and common pitfalls to avoid, in order to get the most out of your technology solutions.
Discover More

August 13, 2012

Display Project Server multi-value field in single column in SSRS report

Hi There,

A client of ours recently asked that a Project Server multi-value field be displayed in a single column in an SSRS report.  Though I am sure there are several ways to do this, I chose the method below.  It basically requires creating a function, that is passed the EntityUID of the multi-value field, then then returns all the selected values in a single cell using a COALESCE function.  I only went so far as sharing the SQL below, applying this to an SSRS report should be very easy for those familiar with SSRS.

Happy coding!

End Result

clip_image002

 

 

Function code, as well as sample code leveraging function

image

 

Actual text (for copy/paste)

-- Sample Function that takes an EntityUID as a parameter and returns item(s) in single column
ALTER FUNCTION [dbo].[GetMultipleValues]
(     @EntityUID      varchar(255)
)
RETURNS varchar(max)
AS
BEGIN
declare @output varchar(max)
Select @output = COALESCE(@output + ', ', '') + MemberValue
from MSPLT_Multiple_Userview mmu
inner join MSPCFPRJ_multiple_AssociationView mmuv on (mmu.LookupMemberUID = mmuv.LookupMemberUID)
inner join MSP_EpmProject_UserView mep on (mmuv.EntityUID = mep.ProjectUID)
where mmuv.EntityUID = @EntityUID
return @output
END

GO

 

-- Example code using function created above
select distinct projectname, mmuv.EntityUID, dbo.GetMultipleValues(mmuv.EntityUID) as MultipleValues
from msp_epmproject_userview mep
inner join MSPCFPRJ_multiple_AssociationView mmuv on (mep.ProjectUID = mmuv.EntityUID)

© Copyright 2022 | Integent.com | All Rights Reserved
linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram