add color and table to the license report

[Eran_Stark]

Hello,
i would like when i generate the report for the license to add color to the result and that the report will be inside of a organize table:

Select Top 1000000 tblLicenses.softwareName As License,
tblLicenses.Priceperlicense,
tblLicenses.LicenseExpiration
From tblLicenses
Where tblLicenses.LicenseExpiration < GetDate() + 30 And
tblLicenses.LicenseContract = 1
Order By License

is it possible?
thanks

[Eran_Stark]

thanks for the help
much appreciate

[Andy_Sismey]

Hi,

I'm no expert on Lansweeper but I don't "think" the coloured formatting can be carried through to emails, at the moment, but I may be wrong ?

Cheers

A

[Eran_Stark]

Hi, thanks for the reply and it help but now the question when i create this in the email alerts report i would like it to send in the same view it shows the report with the color and columns
is it possible?

[Andy_Sismey]

Is this what you are after ?

Select Top 1000000 tblLicenses.softwareName As License,
  tblLicenses.Priceperlicense,
  Case
    When tblLicenses.LicenseExpiration < DateAdd(dd, 0, GetDate()) Then
      '#ffcccc'
    When tblLicenses.LicenseExpiration < DateAdd(mm, 1, GetDate()) Then
      '#ffff00'
    Else '#bced91'
  End As backgroundcolor,
  tblLicenses.LicenseExpiration,
  Case
    When tblLicenses.LicenseExpiration < DateAdd(dd, 0, GetDate()) Then
      'License Expired'
    When tblLicenses.LicenseExpiration < DateAdd(mm, 1, GetDate()) Then
      'License Ending Soon'
    Else 'OK'
  End As Status
From tblLicenses
Where tblLicenses.LicenseExpiration < GetDate() + 30 And
  tblLicenses.LicenseContract = 1
Order By License