I have generated a custom table with the following (clunky) SQL script:
SELECT
Nodes.NodeID AS [Node ID], Volumes.VolumeID AS [Volume ID], Nodes.Caption AS [Node Name], Volumes.VolumeDescription AS [Volume Description], Volumes.VolumeTypeIcon AS [Volume Type Icon], Volumes.VolumeSize AS [Volume Size], 100-NullIf(VolumePercentUsed,-2) AS [Volume Percent Available], Volumes.VolumeSpaceUsed AS [Volume Space Used], (NullIf(VolumeSize,-2)-NullIf(VolumeSpaceUsed,-2)) AS [Volume Space Available]
FROM
Nodes INNER JOIN Volumes ON (Nodes.NodeID = Volumes.NodeID)
WHERE
(
(Nodes.Caption LIKE '%NUF-%') AND
(Nodes.Vendor = 'windows')
)
It runs fine when you run the report. But, when I run it as a scheduled report it doesn't send as an excel/csv. When I run it as a PDF I get 'export to pdf' but nothing happens. I tried to copy the link, but I get a '#' as a result. Oddly, when I send it to my colleague, they do not receive ANY export to PDF/excel.
having a read at some other people that have had this problem in the past, I wonder if there's something within this query that cannot be exported into excel. Can anyone confirm this is the case?
I also ran it through the report writer application, but still get the same issues.
Does anyone have a fix on this?
