Retrieving Linked Reports Programatically?

How do you get the properties for a linked report? Is it not possible
to do this by the linked report name? I only see 4 methods for linked
servers:
CreateLinkedReport
GetReportLink
ListLinkedReports
SetReportLink
None of which I see do any property retreiving. Am I missing
something here?
Any help is appreciated,
FrankGetProperties(), GetReportParameters() as well as some other methods should
work with linked reports.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Stoma_Kalos" <fzuma@.yahoo.com> wrote in message
news:e876e3c8.0409030923.60765863@.posting.google.com...
> How do you get the properties for a linked report? Is it not possible
> to do this by the linked report name? I only see 4 methods for linked
> servers:
> CreateLinkedReport
> GetReportLink
> ListLinkedReports
> SetReportLink
> None of which I see do any property retreiving. Am I missing
> something here?
> Any help is appreciated,
> Frank|||I guess my question is more on the side of Creating Linked Reports
programatically. Using CreateLinkedReport works fine, but for reports
with parameters there does not seem to be a way to connect them to the
Linked Report with its own defaults. Currently, I am playing with
SetReportParameters, but it is awkward and I'm not sure this is the
way to do it.
Basically, for creating a new linked report I am pulling up the report
parameters using GetReportParameters using the Linked Report path.
Then when I call SetReportParameters using the future path of the
Linked Report I am creating.
Does this sound correct or am I on the wrong path? It doesn't seem
that many people are playing around with Linked Reports through code.
Frank
"Lev Semenets [MSFT]" <levs@.microsoft.com> wrote in message news:<#nhcjBfkEHA.536@.TK2MSFTNGP11.phx.gbl>...
> GetProperties(), GetReportParameters() as well as some other methods should
> work with linked reports.
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.

Retrieving Indexes and SQL Relationships programatically

Hi All,
I have been able to retrieve the tables within a database automatically via
an sql query. Is there a way that I can retrieve the indexes (with the field
names they are indexing) and relationships (Fields plus tables they are
referencing).
What I am trying to achieve is this.
In VB.Net you have datasets. I would like to populate this dataset based on
the tables of the intended database progromatically and setup the
relationships and indexes rather than having to hardcode it in a class
everytime.
I also need to do this to ensure that when an update is sent out and there
have been database design changes that I can compare the structures,indexes
and relationships to what is needed and alter accordingly
Thanks in advance
Mark Hollander
Look at the code of sp_helpindex, sp_fkeys and other related system stored
procedures. You could do this using sp_helptext, as in:
USE master
GO
EXEC sp_helptext sp_helpindex
GO
This will give you an idea of where the required information is stored in
the system tables.
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Mark Hollander" <mark.hollander@.softris.co.za> wrote in message
news:OLDH96d3FHA.128@.tk2msftngp13.phx.gbl...
Hi All,
I have been able to retrieve the tables within a database automatically via
an sql query. Is there a way that I can retrieve the indexes (with the field
names they are indexing) and relationships (Fields plus tables they are
referencing).
What I am trying to achieve is this.
In VB.Net you have datasets. I would like to populate this dataset based on
the tables of the intended database progromatically and setup the
relationships and indexes rather than having to hardcode it in a class
everytime.
I also need to do this to ensure that when an update is sent out and there
have been database design changes that I can compare the structures,indexes
and relationships to what is needed and alter accordingly
Thanks in advance
Mark Hollander