Skip to Content
0
R S
Aug 14, 2023 at 08:50 AM

Highlight a Column in Query

37 Views Last edit Aug 14, 2023 at 09:17 AM 2 rev

Hi

Is it possible to color a column in query. I want if value is > 5000 then its color should get red. I have below query

(SELECT 'A/C Bal.' 'Type',cast(getdate() as date) [Posting Date],'' [Document No],'' [Voucher No.],'' Line_ID,'ABC Bank Ltd' + ' ' +'('+' '+'Closing Bal.'+' '+'='+' '+cast(cast(ISNULL(SUM(S.Debit)-SUM(s.Credit),0.00) +(select sum(debit)-sum(Credit) from jdt1 where jdt1.refdate<cast(DATEADD(day, DATEDIFF(day, 0, GETDATE()), 0) as date) ) as numeric(19,2)) as nvarchar(max))+')' 'Particulars',null [Debit(LC)]

,null[Credit(LC)],null [Debit(FC)]

,null[Credit(FC)]

FROM JDT1 S left join oact d on d.AcctCode=s.ShortName

WHERE S.RefDate=cast(DATEADD(day, DATEDIFF(day, 0, GETDATE()), 0) as date) )

Thanks