SSRS (Reporting Services) Action Link Opened In New Window _Blank

Add to the action report expression

="javascript:void(window.open('"+ Fields!ReferURL.Value + "','_blank'))"
or to a url
="javascript:void(window.open('http://www.google.com','_blank'))"

Sort Outlook Tasks By Subject

Outlook 2007+ cannot sort by task subject field

Outlook 2003 can do this but for some reason it was changed in 2007 (2010?)
When you try this you get the error “You cannot sort by this field”

To resolve if you need to remove Task Subject from the view and replace it with Subject.

1.  Right click on the column heading
2. Select customise current view
3. Click on fields
4. Add subject, remove task subject
5. Now it you will be able to sort by the subject field

CLUSTER NAME, VIRTUAL RESOURCE NAME, PHYSICAL SERVER NAME(S)

IF (SELECT CONVERT(bit, SERVERPROPERTY('IsClustered'))) = 1

      BEGIN

            DECLARE @ClusterName VarChar(1000)       

            EXEC master..xp_regread @rootkey='HKEY_LOCAL_MACHINE', @key='Cluster', @value_name='ClusterName', @value=@ClusterName OUTPUT

           

            SELECT

            Upper(NodeName) as PhysicalServerName

            ,Upper(CONVERT(varchar(100), SERVERPROPERTY('MachineName'))) as [VirtualPhysicalName]

            ,Upper(@ClusterName) as ClusterName

            FROM sys.dm_os_cluster_nodes 

      END

      ELSE

      BEGIN

            SELECT

            Upper(CONVERT(varchar(100), SERVERPROPERTY('MachineName'))) as [PhysicalServerName]

            ,Upper(CONVERT(varchar(100), SERVERPROPERTY('MachineName'))) as [VirtualPhysicalName]

            ,NULL as ClusterName

      END