→ The Lansweeper Customer Excellence Awards 2024 - Submit Your Project Now! Learn More & Enter Here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Eran_Stark
Engaged Sweeper
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
4 REPLIES 4
Eran_Stark
Engaged Sweeper
thanks for the help
much appreciate
Andy_Sismey
Champion Sweeper III
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
Engaged Sweeper
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
Champion Sweeper III
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