ReportBuilder custom fields (Custom information)

[Johan_wauters29]

Hi,

Can somone help me with the ReportBuilder? I try to show the current "state" of a computer and the "comment field" and the "Location". I only get values like 0 or 1 and no text.

Thx!

Johan

[Johan_wauters29]

Is it posible to give every line a color based on the statename?

example:
active = green
broken = red
non active = gray

thx

[Hemoco]

Johan.wauters29834 wrote:
Is it posible to give every line a color based on the statename?

example:
active = green
broken = red
non active = gray

thx

Technically yes if you inject html code into the query but I won't recommend it.

[Johan_wauters29]

OK perfect, THX!

[Johan_wauters29]

Nice thx! ! !
but, only 24 computers are showing of the 130. Not all computers has a comment but should be in de list.

[Hemoco]

Johan.wauters29834 wrote:
Nice thx! ! !
but, only 24 computers are showing of the 130. Not all computers has a comment but should be in de list.

try this:

Select Top 1000000 dbo.tblComputers.Computername, dbo.tblComputers.Username,
  dbo.tblComputerSystemProduct.Name, dbo.tblComputerSystemProduct.Vendor,
  tblComputerSystemProduct.IdentifyingNumber, dbo.tblComputers.Lastseen,
  tblCompCustom.Location, tblCompCustom.Custom1, tblCompCustom.Comments,
  tblstate.Statename
From dbo.tblComputers Left Outer Join
  dbo.tblComputerSystemProduct On dbo.tblComputers.Computername =
    dbo.tblComputerSystemProduct.Computername Left Join
  tblCompCustom On tblCompCustom.Computername = dbo.tblComputers.Computername
  Left Join
  tblstate On tblstate.State = tblCompCustom.State

[Hemoco]

Try this:

Select Top 1000000 dbo.tblComputers.Computername, dbo.tblComputers.Username,
  dbo.tblComputerSystemProduct.Name, dbo.tblComputerSystemProduct.Vendor,
  tblComputerSystemProduct.IdentifyingNumber, dbo.tblComputers.Lastseen,
  tblCompCustom.Location, tblCompCustom.Custom1, tblCompCustom.Comments,
  tblstate.Statename
From dbo.tblComputers Left Outer Join
  dbo.tblComputerSystemProduct On dbo.tblComputers.Computername =
    dbo.tblComputerSystemProduct.Computername Left Join
  tblCompCustom On tblCompCustom.Computername = dbo.tblComputers.Computername
  Inner Join
  tblstate On tblstate.State = tblCompCustom.State

[Johan_wauters29]

Select Top 100 Percent dbo.tblComputers.Computername As Computer,
dbo.tblComputers.Username, dbo.tblComputerSystemProduct.Name,
dbo.tblComputerSystemProduct.Vendor,
tblComputerSystemProduct1.IdentifyingNumber, dbo.tblComputers.Lastseen,
tblCompCustom.Location, tblCompCustom.State, tblCompCustom.Custom1,
tblCompCustom.Comments
From dbo.tblComputers Left Outer Join
dbo.tblComputerSystemProduct On dbo.tblComputers.Computername =
dbo.tblComputerSystemProduct.Computername Inner Join
tblComputerSystemProduct tblComputerSystemProduct1 On
dbo.tblComputers.Computername = tblComputerSystemProduct1.Computername,
tblCompCustom
Group By dbo.tblComputers.Computername, dbo.tblComputers.Username,
dbo.tblComputerSystemProduct.Name, dbo.tblComputerSystemProduct.Vendor,
tblComputerSystemProduct1.IdentifyingNumber, dbo.tblComputers.Lastseen,
tblCompCustom.Location, tblCompCustom.State, tblCompCustom.Custom1,
tblCompCustom.Comments
Order By dbo.tblComputers.Computername

[Hemoco]

Could you post your sql query (or a screenshot)

[Johan_wauters29]

I found them but the value is no text. I don't have much experience with commands 😞