Software report

Hello guys!

I was wondering if any of you could give me a hand... I've been
struggling with this one basic report that I can't get to work. I need
a report that is really similar to this one, but I need to tell in
advanced what are the softwares I want to get listed. The normal
report is this:

Select DISTINCT
SYS.Netbios_Name0,SYS.Resource_Domain_OR_Workgr0,SP.CompanyName,
SP.ProductName, SP.ProductVersion
FROM v_GS_SoftwareProduct SP
JOIN v_R_System SYS ON SP.ResourceID=SYS.ResourceID
Where SYS.Netbios_Name0 Like @variable
ORDER By SP.CompanyName, SP.ProductName, SP.ProductVersion

This lists all the software in a certain computer (which is prompted),
but how can I ask for certain program, lets say %adobe%, %Cisco% and
so on... And the computer name need to be a variable so that it only
lists that computer...

All the help appreciated!!

.

Relevant Pages

  • RE: Should be simple but...
    ... Staff directory- I need it to list last name, first name, phone location ... I did as you suggested and created a subreport. ... Used the wizard to link the srpt to the main report. ... I have one location that lists 6 staff ...
    (microsoft.public.access.reports)
  • Re: I need a form to select the items to be presented in the repor
    ... Dim strCriteria As String ... change "ReportName" to the name of your report. ... In the report query remove the "Where" clause. ... Instead of a query asking for a site, I want a form which lists all the ...
    (microsoft.public.access.formscoding)
  • RE: create any report
    ... "Duane Hookom" wrote: ... sign/operator, and criteria. ... fields they want to display in a published report. ... Lists ...
    (microsoft.public.access.reports)
  • RE: Weird Problem with a Subreport
    ... If you don't want to show the header on the first group, ... Open the report in design view. ... I have a header of shutdown in front of the whole list but the two lists ... The Subreport will only show as many rows as will fit in the area I delegated ...
    (microsoft.public.access.reports)
  • GOP congressman asks GAO for a list of issues facing federal agencies so he can ask Obamas appointee
    ... A 150-Page List of Bush Administration Screwups ... Want to know just what Obama has to look forward to when he steps into ... When Sen. George Voinovich requested a report from the ... you know of any lists out there, ...
    (misc.news.internet.discuss)
Loading