Hi,
I have created a report with the Orion report writer and the output is fine in design mode.
If I run the same report in the web the report is empty
Any sugestion why and how to fix this as I need to be able to scheduled it.
//Jan
SELECT TOP 10000 CONVERT(DateTime,
LTRIM(MONTH(DateTime)) + '/01/' + LTRIM(YEAR(DateTime)),
101) AS SummaryMonth,
Nodes.NodeID AS NodeID,
Nodes.Caption AS NodeName,
Interfaces.InterfaceID AS InterfaceID,
Nodes.VendorIcon AS Vendor_Icon,
Interfaces.Caption AS Interface_Caption,
Interfaces.InterfaceIcon AS Interface_Icon,
AVG(InterfaceTraffic.In_Averagebps) AS AVERAGE_of_Average_Receive_bps,
MAX(InterfaceTraffic.In_Maxbps) AS MAX_of_Peak_Receive_bps,
AVG(InterfaceTraffic.Out_Averagebps) AS AVERAGE_of_Average_Transmit_bps,
MAX(InterfaceTraffic.Out_Maxbps) AS MAX_of_Peak_Transmit_bps,
Interfaces.InterfaceSpeed AS Interface_Speed
FROM
(Nodes INNER JOIN Interfaces ON (Nodes.NodeID = Interfaces.NodeID)) INNER JOIN InterfaceTraffic ON (Interfaces.InterfaceID = InterfaceTraffic.InterfaceID AND InterfaceTraffic.NodeID = Nodes.NodeID)
WHERE
( DateTime BETWEEN 42093 AND 42122.9999884259 )
AND
(
(DATEPART(weekday, DateTime) <> 7) AND
(DATEPART(weekday, DateTime) <> 1) AND
(Convert(Char,DateTime,108) >= '06:30') AND
(Convert(Char,DateTime,108) <= '17:30') AND
(Nodes.Division = 'Systems') AND
(Interfaces.InterfaceAlias LIKE '%PE%')
)
GROUP BY CONVERT(DateTime, LTRIM(MONTH(DateTime)) + '/01/' + LTRIM(YEAR(DateTime)), 101),
Nodes.NodeID, Nodes.Caption, Interfaces.InterfaceID, Nodes.VendorIcon, Interfaces.Caption, Interfaces.InterfaceIcon, Interfaces.InterfaceSpeed
ORDER BY SummaryMonth ASC, 6 ASC
