Report Builder

[PaulVa214]

Hi,

Need assistance building a report and exporting it to excel.. Need to report specific software for licensing. For example nned ot find number of installations for Visio, project, etc. Need to include the workstation name, software version and user name if possible. Have made several attempts in Report builder (have the latest 3.5.2.6) but the reports come up blank. I watched the video and have attepted to use the concepts but have not had success. I don't use access or sql much so am a little lost.

The sql comes up
Select Top 100 Percent tblSoftware.softwareName, tblSoftware.SoftwarePublisher,
tblComputers.Computername, tblSoftware.softwareVersion
From tblComputers Inner Join
tblSoftware On tblComputers.Computername = tblSoftware.ComputerName
Where tblSoftware.softwareName Like 'Visio'


Thanks for your help

Paul

[Hemoco]

I think this would be a good place to start : http://msdn.microsoft.com/en-us/library/ms190659%28SQL.90%29.aspx

[PaulVa214]

Thanks again,, Could not see in there unti I rebooted the machine. Then the reports I created were visible. Also fyi, was loosing the "results" tab in report builder. Back after the reboot.

Do you have a list of "expressions" and syntax (or where to locate that info) to use n the were statements.. Figured out the "like" and "Not Like" plus using a "and" . Not sure if there are any more.

Thanks for all your help

[Hemoco]

In the configuration utility you can change which reports are seen in the dashboards (dropdown list)

[PaulVa214]

Ok,

great, that worked. Thanks

Now I need/want to be able to access these reports from within LanSweeper itself. So these reports don't seem to show up anywhere else other than report builder. Is there a method for them to show up Where they could be used on the LanSweeper Web interface?? It would be nice for others to be able to run them or for me to put them on the dashboard etc.

Paul

[Hemoco]

Is the software name 'visio'?
Most likely you will need to use wildcards. (%)

try:
Where tblSoftware.softwareName Like 'Visio%'