hi everyone,
Two things:
1) I am trying to use "database scripts" to created a report. I can get the report create, and the results show just fine. However, when I go into Report Builder and edit the report, the windows in Report Builder are all blank. I cannot see the SQL code. Any hints? here is the code I am entering into "database scripts"
CREATE VIEW dbo.AAA_IS_AVG_Installed
AS
Select Top 100 Percent dbo.tblComputers.Computername As Computer,
dbo.tblOperatingsystem.Description, dbo.tblSoftware.softwareName As Software,
dbo.tblSoftware.softwareVersion As Version,
dbo.tblSoftware.Lastchanged
From dbo.tblSoftware
Inner Join dbo.tblComputers On dbo.tblSoftware.ComputerName = dbo.tblComputers.Computername
Inner Join dbo.tblOperatingsystem On dbo.tblComputers.Computername = dbo.tblOperatingsystem.Computername
Where dbo.tblSoftware.softwareName Like '%AVG%'
Order By dbo.tblComputers.Computername
GO
INSERT INTO [tsysreports] ([Reportquery],[Reporttitle]) VALUES ('AAA_IS_AVG_Installed','AAA_IS_AVG_Installed')
GO
2) How can I get this report added directly to Dashboard via "database scripts"?
Thanks
