→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
almor
Engaged Sweeper II
Hello,

i'm trying to create a custom report in FF
So, i open a report builder and paste my query at the bottom of the page.
In the middle of a page i see a message "Query is changed, need to be updated"

But the table on the top not appeared and when i try to save it, i get an error:

"Error during saving: "ExecuteReader: CommandText property has not been initialized""

Here is my query:

Select Top 1000000 dbo.tblAssets.AssetID,
dbo.tblAssets.AssetUnique,
dbo.tblAssets.Domain,
dbo.tsysOS.OSname,
dbo.tsysOS.Image As icon,
tblFileVersions.FilePathfull,
tblFileVersions.FileVersion
From tblAssets
Left Outer Join tblFileVersions On tblAssets.AssetID = tblFileVersions.AssetID,
Inner Join tblFileVersions On tblAssets.AssetID = tblFileVersions.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Where tblFileVersions.FilePathfull Like '%acrobat.exe' And
tblFileVersions.Found like 'True'
Order By tblFileVersions.Lastchanged Desc



Also, when delete an existing report, i've get an error, but report is deleted successfully :

Erreur du serveur dans l'application '/'.
La ressource est introuvable.
Description : HTTP 404. La ressource recherchée (ou l'une de ses dépendances) a peut-être été supprimée ou renommée ou bien elle n'est plus disponible temporairement. Vérifiez l'URL ci-après et assurez-vous qu'elle est correcte.
URL demandée: /report.aspx



I'm using FF 18, IE9 and last Lansweeper 5039
1 REPLY 1
Hemoco
Lansweeper Alumni
Could you please contact support@lansweeper.com regarding this issue and include a link to this forum thread in your email.