> '
ELSE ''
END + Prsn.[Name] AS [Person]
,Prsn.[Phone1] AS [Phone]
,Prsn.[PrimaryEmailId] AS [Email]
,Convert(nvarchar(40), Sssn.[LoginOn], 120) AS [SessionStart]
FROM
[PDXpertDB].[dbo].[UserSession_View] Sssn
INNER JOIN [dbo].[PDXpertUser_View] Usr ON Usr.Id=Sssn.PDXpertUser
INNER JOIN [dbo].[Person_View] Prsn ON Prsn.Id=Usr.Person
WHERE
LogoutOn Is Null
ORDER BY
[Name]
]]>
2in
2in
2in
1.5in
0.25in
true
true
Person name
DimGray
1pt
2pt
2pt
2pt
2pt
true
true
Contact phone
DimGray
1pt
2pt
2pt
2pt
2pt
true
true
Email address
DimGray
1pt
2pt
2pt
2pt
2pt
true
true
Start time (UTC)
DimGray
2pt
2pt
2pt
2pt
0.25in
true
true
=Fields!Person.Value
2pt
2pt
2pt
2pt
true
true
=Fields!Phone.Value
2pt
2pt
2pt
2pt
true
true
=Fields!Email.Value
2pt
2pt
2pt
2pt
true
true
=Fields!SessionStart.Value
2pt
2pt
2pt
2pt
After
true
true
DataSet1
0.5in
7.5in
0.53in
7.5in
0.7in
true
true
0.65in
0in
7.5in
2pt
true
true
All Logged-In Users
0.25in
3.25in
1
2pt
2pt
2pt
2pt
true
true
PDXpert Product Lifecycle Manager
4in
0.25in
3.5in
2
2pt
2pt
2pt
2pt
true
true
=Globals!ExecutionTime
0.31944in
4in
0.20833in
3.5in
3
2pt
2pt
2pt
2pt
0.42708in
true
true
0.04167in
0in
7.5in
2pt
true
true
Page
=Globals!PageNumber
of
=Globals!TotalPages
0.16667in
4in
0.20833in
3.5in
1
2pt
2pt
2pt
2pt
0.5in
0.5in
0.5in
0.5in
0
System.Data.DataSet
/* Local Connection */
DataSet1
/* Local Query */
Person
Email
SessionStart
Phone
Report2