can you paste your query in here so we can see it?
another option (haven't tested in web report but worked in writer) is to create stored procedure with your SQL that works and just call it from the SW report.
This is a good idea. Gonna post my query anyway because I'm really wondering why it's not working in the web but working in report writer.
with VOLweekly as
'Name' = al.ObjectName,
'Date' = cast(al.LogDateTime as date),
'Day' = DateName(dw,al.LogDateTime),
'Time' = Right(al.LogDateTime, len(al.logdatetime)-11),
from solarwindsorion.dbo.AlertLog al
'AlertID' = case
when charindex('1',Alertname) > 0 then 'Vol 1'
when charindex('2',Alertname) > 0 then 'Vol 2'
when charindex('3',Alertname) > 0 then 'Vol 3'
charindex('Volume Utilization',Alertname) > 0
on ad.AlertDefID = al.AlertDefID
charindex('Alert Triggered',al.Message) > 0
and charindex('Email',al.Message) = 0
from VOLweekly rpt
where not exists
select 1 from VOLweekly chk
chk.Name = rpt.name
and chk.AlertID > rpt.AlertID
and Date > dateadd(dd,-8,(cast(getdate() as date)))
order by date
I'm impressed it worked in writer...I came up w/ the stored procedure thing b/c I couldn't get case to work in writer...that might be why it doesn't work in web...not sure.