
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-30-2014 05:14 PM
Hello,
I would like to ask. We have a custom report but I don't know how to change the link on computer to clickable. It is really messy report but It is working fine if we don't touch it very much:) Don't you know please how to change it? Here it is:
Thank you very much!
I would like to ask. We have a custom report but I don't know how to change the link on computer to clickable. It is really messy report but It is working fine if we don't touch it very much:) Don't you know please how to change it? Here it is:
Select Top 1000000 c.Computer,
w4name.Compimage As icon,
ccus.Custom2 As øada,
w4states.Statename As Stav,
c.Username As Uživatel,
ccus.Location As UmÃstìnÃ,
ccus.Custom3 As Poznámka,
cpu.Name As Procesor,
mb.Product As [Zákl. deska],
w4mem.Memory As Paměť,
Case When sw.SoftwareID Is Not Null Then 'programatorske' Else Null
End As image,
ccus.Custom4 As Projekt,
ccus.PurchaseDate,
ccus.Custom1,
c.Computername As pocitac
From upgrade_tblComputers c
Left Outer Join upgrade_web40CorrectMemory w4mem On w4mem.Computername =
c.Computername
Left Outer Join upgrade_Web40OSName w4name On w4name.Computername =
c.Computername
Left Outer Join upgrade_tblCompCustom ccus On c.Computername =
ccus.Computername
Inner Join tblstate On tblstate.State = ccus.State
Left Outer Join upgrade_tblBaseBoard mb On c.Computername = mb.Computername
Left Outer Join upgrade_tblPROCESSOR cpu On c.Computername = cpu.Computername
Inner Join upgrade_web40allcompstates w4states On w4states.Computername =
c.Computername
Inner Join upgrade_tblComputersystem
On c.Computername = upgrade_tblComputersystem.Computername
Left Outer Join upgrade_tblSoftware sw On c.Computername = sw.ComputerName And
sw.softwareName = 'Microsoft Visual Studio 2008 Professional Edition - ENU'
Where upgrade_tblComputersystem.Domainrole < '2'
Order By c.Computer
Thank you very much!
Solved! Go to Solution.
Labels:
- Labels:
-
Report Center
1 ACCEPTED SOLUTION

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-02-2014 11:44 AM
Please try with the following report:
Select Top 1000000 c.Computer as assetname,
c.Computername As assetid,
w4name.Compimage As icon,
ccus.Custom2 As øada,
w4states.Statename As Stav,
c.Username As Uživatel,
ccus.Location As UmÃstìnÃ,
ccus.Custom3 As Poznámka,
cpu.Name As Procesor,
mb.Product As [Zákl. deska],
w4mem.Memory As Paměť,
Case When sw.SoftwareID Is Not Null Then 'programatorske' Else Null
End As image,
ccus.Custom4 As Projekt,
ccus.PurchaseDate,
ccus.Custom1
From upgrade_tblComputers c
Left Outer Join upgrade_web40CorrectMemory w4mem On w4mem.Computername =
c.Computername
Left Outer Join upgrade_Web40OSName w4name On w4name.Computername =
c.Computername
Left Outer Join upgrade_tblCompCustom ccus On c.Computername =
ccus.Computername
Inner Join tblstate On tblstate.State = ccus.State
Left Outer Join upgrade_tblBaseBoard mb On c.Computername = mb.Computername
Left Outer Join upgrade_tblPROCESSOR cpu On c.Computername = cpu.Computername
Inner Join upgrade_web40allcompstates w4states On w4states.Computername =
c.Computername
Inner Join upgrade_tblComputersystem
On c.Computername = upgrade_tblComputersystem.Computername
Left Outer Join upgrade_tblSoftware sw On c.Computername = sw.ComputerName And
sw.softwareName = 'Microsoft Visual Studio 2008 Professional Edition - ENU'
Where upgrade_tblComputersystem.Domainrole < '2'
Order By c.Computer
Select Top 1000000 c.Computer as assetname,
c.Computername As assetid,
w4name.Compimage As icon,
ccus.Custom2 As øada,
w4states.Statename As Stav,
c.Username As Uživatel,
ccus.Location As UmÃstìnÃ,
ccus.Custom3 As Poznámka,
cpu.Name As Procesor,
mb.Product As [Zákl. deska],
w4mem.Memory As Paměť,
Case When sw.SoftwareID Is Not Null Then 'programatorske' Else Null
End As image,
ccus.Custom4 As Projekt,
ccus.PurchaseDate,
ccus.Custom1
From upgrade_tblComputers c
Left Outer Join upgrade_web40CorrectMemory w4mem On w4mem.Computername =
c.Computername
Left Outer Join upgrade_Web40OSName w4name On w4name.Computername =
c.Computername
Left Outer Join upgrade_tblCompCustom ccus On c.Computername =
ccus.Computername
Inner Join tblstate On tblstate.State = ccus.State
Left Outer Join upgrade_tblBaseBoard mb On c.Computername = mb.Computername
Left Outer Join upgrade_tblPROCESSOR cpu On c.Computername = cpu.Computername
Inner Join upgrade_web40allcompstates w4states On w4states.Computername =
c.Computername
Inner Join upgrade_tblComputersystem
On c.Computername = upgrade_tblComputersystem.Computername
Left Outer Join upgrade_tblSoftware sw On c.Computername = sw.ComputerName And
sw.softwareName = 'Microsoft Visual Studio 2008 Professional Edition - ENU'
Where upgrade_tblComputersystem.Domainrole < '2'
Order By c.Computer
2 REPLIES 2

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-02-2014 12:08 PM
That did the trick! Thank you very much!

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-02-2014 11:44 AM
Please try with the following report:
Select Top 1000000 c.Computer as assetname,
c.Computername As assetid,
w4name.Compimage As icon,
ccus.Custom2 As øada,
w4states.Statename As Stav,
c.Username As Uživatel,
ccus.Location As UmÃstìnÃ,
ccus.Custom3 As Poznámka,
cpu.Name As Procesor,
mb.Product As [Zákl. deska],
w4mem.Memory As Paměť,
Case When sw.SoftwareID Is Not Null Then 'programatorske' Else Null
End As image,
ccus.Custom4 As Projekt,
ccus.PurchaseDate,
ccus.Custom1
From upgrade_tblComputers c
Left Outer Join upgrade_web40CorrectMemory w4mem On w4mem.Computername =
c.Computername
Left Outer Join upgrade_Web40OSName w4name On w4name.Computername =
c.Computername
Left Outer Join upgrade_tblCompCustom ccus On c.Computername =
ccus.Computername
Inner Join tblstate On tblstate.State = ccus.State
Left Outer Join upgrade_tblBaseBoard mb On c.Computername = mb.Computername
Left Outer Join upgrade_tblPROCESSOR cpu On c.Computername = cpu.Computername
Inner Join upgrade_web40allcompstates w4states On w4states.Computername =
c.Computername
Inner Join upgrade_tblComputersystem
On c.Computername = upgrade_tblComputersystem.Computername
Left Outer Join upgrade_tblSoftware sw On c.Computername = sw.ComputerName And
sw.softwareName = 'Microsoft Visual Studio 2008 Professional Edition - ENU'
Where upgrade_tblComputersystem.Domainrole < '2'
Order By c.Computer
Select Top 1000000 c.Computer as assetname,
c.Computername As assetid,
w4name.Compimage As icon,
ccus.Custom2 As øada,
w4states.Statename As Stav,
c.Username As Uživatel,
ccus.Location As UmÃstìnÃ,
ccus.Custom3 As Poznámka,
cpu.Name As Procesor,
mb.Product As [Zákl. deska],
w4mem.Memory As Paměť,
Case When sw.SoftwareID Is Not Null Then 'programatorske' Else Null
End As image,
ccus.Custom4 As Projekt,
ccus.PurchaseDate,
ccus.Custom1
From upgrade_tblComputers c
Left Outer Join upgrade_web40CorrectMemory w4mem On w4mem.Computername =
c.Computername
Left Outer Join upgrade_Web40OSName w4name On w4name.Computername =
c.Computername
Left Outer Join upgrade_tblCompCustom ccus On c.Computername =
ccus.Computername
Inner Join tblstate On tblstate.State = ccus.State
Left Outer Join upgrade_tblBaseBoard mb On c.Computername = mb.Computername
Left Outer Join upgrade_tblPROCESSOR cpu On c.Computername = cpu.Computername
Inner Join upgrade_web40allcompstates w4states On w4states.Computername =
c.Computername
Inner Join upgrade_tblComputersystem
On c.Computername = upgrade_tblComputersystem.Computername
Left Outer Join upgrade_tblSoftware sw On c.Computername = sw.ComputerName And
sw.softwareName = 'Microsoft Visual Studio 2008 Professional Edition - ENU'
Where upgrade_tblComputersystem.Domainrole < '2'
Order By c.Computer
