Properties Pane Help (was Re: Many to Many Relationships ... AS200

Thanks a lot.
A last question (honest!) - Is there anywhere I can get the documentation on
what all of the properties in the properties pane do? At the moment hitting
F1 just tells me how to set the associated property in C# but not what the
purpose of the property is. I wonder if there are some features I'm missing
or some understanding I don't quite have because there are properties I don'
t
fully understand.As we get closer to RTM books-online will be providing more and more
information about the various properties.
--
Dave Wickert [MSFT]
dwickert@.online.microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Richard Corfield" <RichardCorfield@.discussions.microsoft.com> wrote in
message news:C4782D0F-58AD-4C3B-8A56-A05EB7614919@.microsoft.com...
> Thanks a lot.
> A last question (honest!) - Is there anywhere I can get the documentation
on
> what all of the properties in the properties pane do? At the moment
hitting
> F1 just tells me how to set the associated property in C# but not what the
> purpose of the property is. I wonder if there are some features I'm
missing
> or some understanding I don't quite have because there are properties I
don't
> fully understand.

Programmatically generating a reporting model?

Is there documentation/examples on how to programmatically generate a report model (.smdl XML file)? The situation I'm in would make generating the model manually via Visual Studios difficult (would have to hire lots of people).

Any ideas or suggestions would be greatly appreciated.

One option is to download the XSD here and generate an object model from it:

http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/SemanticModeling.xsd

Programmatically Adding ADO.NET Connections

I can't find any documentation on the connection string for creating ADO.NET connections.

I am displaying a report in a viewer. It is connected to a wrapper DLL through an ADO.NET connection using the properties:
File Path
Class Name
Dataset Names

I'm having trouble accessing these to change them at runtime.

I've tried something like:
rpt.database:Tables(1):ConnectionProperties("File Path") = "c:\..."

No luck. Crystal doesn't have much documentation on this method. Any takers?Nevermind. Got it.

I was able to override the path of my DLL at runtime using the syntax:

report.database.tables(1).ConnectionProperties("File Path").Value = "c:\blah"

seems to be working.

Programatically create replication publication?

Is it possible to create a publication entirely from within my application?
If so, are there some samples or documentation anyone can point me to?
Thanks in advance,
Terry
Terry,
please have a look at the SQLDMO and ActiveX scripts on this page:
http://www.replicationanswers.com/Scripts.asp.
Also, you might want to investigate creating a replication setup in a test
environment, having enterprise amnager script out the setup, modifying it
then using this as a starting point for your setup. This would achieve the
same ends, but be entirely in TSQL.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Hello Terry,
If you are using SQL 2005, you may need to consider RMO
Programming with Replication Management Objects
http://msdn2.microsoft.com/en-us/library/ms146869.aspx
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
--
>From: "Paul Ibison" <Paul.Ibison@.Pygmalion.Com>
>References: <OXitg7E9FHA.3020@.TK2MSFTNGP09.phx.gbl>
>Subject: Re: Programatically create replication publication?
>Date: Mon, 28 Nov 2005 19:31:30 -0000
>Lines: 13
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
>X-RFC2646: Format=Flowed; Response
>Message-ID: <uT77YJF9FHA.3880@.TK2MSFTNGP12.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.replication
>NNTP-Posting-Host: 82-43-215-101.cable.ubr10.newm.blueyonder.co.uk
82.43.215.101
>Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFT NGP12.phx.gbl
>Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.replication:67037
>X-Tomcat-NG: microsoft.public.sqlserver.replication
>Terry,
>please have a look at the SQLDMO and ActiveX scripts on this page:
>http://www.replicationanswers.com/Scripts.asp.
>Also, you might want to investigate creating a replication setup in a test
>environment, having enterprise amnager script out the setup, modifying it
>then using this as a starting point for your setup. This would achieve the
>same ends, but be entirely in TSQL.
>Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
>
|||Thanks guys ...
Your suggestions look like my answers.
Tery
"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
news:HNKee6K9FHA.4000@.TK2MSFTNGXA02.phx.gbl...
> Hello Terry,
> If you are using SQL 2005, you may need to consider RMO
> Programming with Replication Management Objects
> http://msdn2.microsoft.com/en-us/library/ms146869.aspx
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ================================================== ===
>
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> --
> 82.43.215.101
>
|||Hello Terry,
My pleasure! :-)
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
--
>From: "Tery" <justme@.noemail.noemail>
>References: <OXitg7E9FHA.3020@.TK2MSFTNGP09.phx.gbl>
<uT77YJF9FHA.3880@.TK2MSFTNGP12.phx.gbl>
<HNKee6K9FHA.4000@.TK2MSFTNGXA02.phx.gbl>
>Subject: Re: Programatically create replication publication?
>Date: Tue, 29 Nov 2005 08:55:11 -0600
>Lines: 68
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
>X-RFC2646: Format=Flowed; Original
>Message-ID: <uh0JjTP9FHA.2192@.TK2MSFTNGP14.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.replication
>NNTP-Posting-Host: dsl-201-155-245-16.prod-empresarial.com.mx
201.155.245.16[vbcol=seagreen]
>Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFT NGP14.phx.gbl
>Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.replication:67058
>X-Tomcat-NG: microsoft.public.sqlserver.replication
>Thanks guys ...
>Your suggestions look like my answers.
>Tery
>"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
>news:HNKee6K9FHA.4000@.TK2MSFTNGXA02.phx.gbl...
test[vbcol=seagreen]
the
>
>