SMS SDK - Reports.create

I'm trying to create three web reports using the SMS SDK based on these
three queries below. I want to have each query drill through to the next
with last one drill through to Computer details.



None of the examples within the SDK show how to create a drill through
report.



Query 1

Select Manufacturer0, count(Manufacturer0) from v_GS_COMPUTER_SYSTEM group
by Manufacturer0



Query 2

SELECT v_GS_COMPUTER_SYSTEM.Name0 AS 'Name',
v_GS_COMPUTER_SYSTEM.Manufacturer0 AS 'Manufacturer',
v_GS_COMPUTER_SYSTEM.Model0 AS 'Model'

FROM v_GS_COMPUTER_SYSTEM v_GS_COMPUTER_SYSTEM

WHERE (v_GS_COMPUTER_SYSTEM.Manufacturer0='Microsoft Corporation')



Query 3

SELECT v_GS_COMPUTER_SYSTEM.Name0 AS 'Name', v_GS_COMPUTER_SYSTEM.Domain0 AS
'Domain', v_GS_COMPUTER_SYSTEM.Manufacturer0 AS 'Manufacturer',
v_GS_COMPUTER_SYSTEM.Model0 AS 'Model',
v_GS_COMPUTER_SYSTEM.PrimaryOwnerName0 AS 'Owner',
v_GS_COMPUTER_SYSTEM.UserName0 AS 'User Name'

FROM v_GS_COMPUTER_SYSTEM v_GS_COMPUTER_SYSTEM

WHERE (v_GS_COMPUTER_SYSTEM.Name0='Computer Name')





This section of code produces no errors when compiled however when debugged
it will produce a "Generic Failure" when the "oReport3.Save()" line is
executed.



Dim oProvider As New SMSProvider(m_sSiteServer, m_sUsername, m_sPassword, "
Setup Prog")

Dim oReport3 As SMSReport = oProvider.Reports.Create("Manufacturer ",
"Company", "SELECT v_GS_COMPUTER_SYSTEM.Name0 AS 'Name',
v_GS_COMPUTER_SYSTEM.Domain0 AS 'Domain', v_GS_COMPUTER_SYSTEM.Manufacturer0
AS 'Manufacturer', v_GS_COMPUTER_SYSTEM.Model0 AS 'Model',
v_GS_COMPUTER_SYSTEM.PrimaryOwnerName0 AS 'Owner',
v_GS_COMPUTER_SYSTEM.UserName0 AS 'User Name'

FROM v_GS_COMPUTER_SYSTEM v_GS_COMPUTER_SYSTEM

WHERE (v_GS_COMPUTER_SYSTEM.Name0='Computer Name')")

oReport3.DisplayInComputerDetails = True

oReport3.ComputerNameColumn = 1

oReport3.LinkType = ReportLinkTypes.LinkToComputerDetails

oReport3.Save()

i = oReport3.ReportID



The SDK is very light on details as to which options need to be set in order
to allow drill throughs to work correctly.





My questions are?

1) Does anyone have any good examples on how to create drill through
reports?

2) Does anyone have an update to the SDK that list which options are
need to allow drill through to work correctly?

3) Does anyone know what I'm doing wrong?




.

Relevant Pages

  • RE: SMS SDK - Reports.create
    ... I would assume that the other parts of your query that ... The Microsoft SMS 2003 SDK is a reference for a "Software" Development Kit. ... creation of a report using VBS or some sort of other scripting method. ... I want to have each query drill through to the next ...
    (microsoft.public.sms.misc)
  • Re: SMS SDK - Reports.create
    ... What I am trying to do is use the SDK and VB.NET 2k5 to create reports as part of a setup vs telling poeple to importing the web report MOF then link each report to it's parent report. ... I would assume that the other parts of your query that ... I want to have each query drill through to the next ...
    (microsoft.public.sms.misc)
  • Re: DBRW link to frontpage form
    ... choose FIND on right...then drill down and u will see the ... Notice the removed full stop between Query and String. ... "Stefan B Rusynko" wrote: ... - you need to pass the link as a parameter to the final form as a std ...
    (microsoft.public.frontpage.programming)
  • Re: Query with lookup table
    ... really fed up with these bleeping lookup ... Would you please open the drill table and change ... I tried the query the way you wrote it and I get a data mismatch ... As soon as you see the query design grid, ...
    (microsoft.public.access.queries)
  • Re: limits of SQL Server???
    ... I obviously don't know much about SQL Server. ... > post the DDL and actual query so we can see what we are dealing with? ... I would but what is a DDL? ... Because the site already has the "drill down" feature and it's a pain in the ...
    (microsoft.public.sqlserver.setup)