Publishing subreports

One of my reports uses a subreport. I use a script that runs under RS.EXE to
publish the reports, with the result that the subreport appears in the list
view where the user may be tempted to go in and try to run it, even though
it's not intended for stand-alone use.
I can hide it by going to Properties/General and checking off "Hide in list
view", but I would prefer to make the setup completely automatic.
Is there any way to set "Hide in list view" directly from the script?
Thanks,
PeterSure. Have a look at the scripts generated by Reporting Services Scripter
for a hidden report
http://www.sqldbatips.com/showarticle.asp?ID=62
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"jpstewart" <jpeterstewart@.hotmail.com.nospam> wrote in message
news:399E98E6-3543-4204-A9F6-484A1C527D99@.microsoft.com...
> One of my reports uses a subreport. I use a script that runs under RS.EXE
> to
> publish the reports, with the result that the subreport appears in the
> list
> view where the user may be tempted to go in and try to run it, even though
> it's not intended for stand-alone use.
> I can hide it by going to Properties/General and checking off "Hide in
> list
> view", but I would prefer to make the setup completely automatic.
> Is there any way to set "Hide in list view" directly from the script?
> Thanks,
> Peter
>|||Did you get an idea of how to access Hide in List view property programatically?. I am also strugling with the same problem. Please send me the reply to my gmail
From http://www.developmentnow.com/g/115_2005_8_0_0_574025/Publishing-subreports.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.com

publishing sql report in a web portal

Hi All,
How do I publish SQL report in a web portal. Please help me if anyone has
done it.
Thanks.,
AdarshYou may call a reporting services report from a URL, to make the report
available anywhere else you simply have to create a link to the proper
URL...
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
(Please respond only to the newsgroup.)
I support the Professional Association for SQL Server ( PASS) and it's
community of SQL Professionals.
"Adarsh" <Adarsh@.discussions.microsoft.com> wrote in message
news:26CCE2C4-1EFD-4A93-B54C-15247C3391F9@.microsoft.com...
> Hi All,
> How do I publish SQL report in a web portal. Please help me if anyone has
> done it.
> Thanks.,
> Adarsh
>

publishing sql 2005

Hi all,
I need to publish my SQL2005 cluster in ISA 2004 for access to my DMZ Web
servers. But I need to know which TCP port to publish. When I check SQL
Config Manager it says dynamic ports?
TIA!
Hello param@.community.nospam,
Start with 1433, and make sure you use the SAC to enable TCP/IP.
Thanks,
Kent Tegels
http://staff.develop.com/ktegels/

publishing sql 2005

Hi all,
I need to publish my SQL2005 cluster in ISA 2004 for access to my DMZ Web
servers. But I need to know which TCP port to publish. When I check SQL
Config Manager it says dynamic ports?
TIA!Hello param@.community.nospam,
Start with 1433, and make sure you use the SAC to enable TCP/IP.
Thanks,
Kent Tegels
http://staff.develop.com/ktegels/

publishing sql 2005

Hi all,
I need to publish my SQL2005 cluster in ISA 2004 for access to my DMZ Web
servers. But I need to know which TCP port to publish. When I check SQL
Config Manager it says dynamic ports?
TIA!Hello param@.community.nospam,
Start with 1433, and make sure you use the SAC to enable TCP/IP.
Thanks,
Kent Tegels
http://staff.develop.com/ktegels

Publishing reports to different versions

I have Visual Studio 2005 and Reporting Services 2005 on my client development machine.

I want to publish the reports to an SQL Server 2000 with Reporting Services 2000 server, is this possible?

I get the following error message:

The report definition is not valid. Please verify that the report definition uses the current report definition namespace (i.e. ‘http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition’). (rsNotACurrentReportDefinition) Get Online Help

Thanks.

Bruce

Unfortunately, you will not be able to use the 2005 report designer to publish directly to a 2000 report server. This is due to the fact that the RDL's (Report Definitions) created are different between Report Server versions. You can however use the 2000 report designer to publish to a 2005 server, as it support auto-upgrade of the reports.

Thanks, Jon

Publishing problem ...

Hello,
I have a problem when trying to publish articles for merge
replication. During execution of the snapshot agent I
receive the following error "The process could not bulk
copy out of table '[dbo].[table_name]'. Can anyone help
me with this problem?
Any help at all would be greatly appreciated!
Thanks in advance
Jim S.
Basically it means the snapshot agent locked up, timed out, was blocked, or
somehow deadlocked. What you do is stop and restart the snapshot agent. If
you are dealing with a large table, you may need to manually transfer it to
the subscriber. There are cases where the size of the table becomes nearly
impossible to get a snapshot to complete.
Mike
Principal Mentor
Solid Quality Learning
"More than just Training"
SQL Server MVP
http://www.solidqualitylearning.com
http://www.mssqlserver.com
|||Do I:
1. Just let the snapshot agent run until it fails
during the bcp process
2. Transfer all tables to the subscriber via dts
3. Create subscription using the 'do not create schema
and data option'

>--Original Message--
>Basically it means the snapshot agent locked up, timed
out, was blocked, or
>somehow deadlocked. What you do is stop and restart the
snapshot agent. If
>you are dealing with a large table, you may need to
manually transfer it to
>the subscriber. There are cases where the size of the
table becomes nearly
>impossible to get a snapshot to complete.
>--
>Mike
>Principal Mentor
>Solid Quality Learning
>"More than just Training"
>SQL Server MVP
>http://www.solidqualitylearning.com
>http://www.mssqlserver.com
>
>.
>
|||If it continues to fail, what I normally do is to separate out the table
that are failing into a separate publication. The ones separated out I use
the "do not create..." option and use DTS to manually transfer everything
over. It's ugly and full of trial and error, but it works. There aren't
any other good options at this point, because a snapshot has to complete in
order for transactions to start flowing. The interesting thing you will
find is that DTS will generally transfer the data in about 1/10 the amount
of time that the snapshot takes.
Mike
Principal Mentor
Solid Quality Learning
"More than just Training"
SQL Server MVP
http://www.solidqualitylearning.com
http://www.mssqlserver.com

Publishing OLAP based Pivotables from Excel

Hi

I want to publish an OLAP based pivottables from Excel to a HTML file using Office web componets.

I have a server with SQL Analysis Services 2005 cubes and I can browse the cube from my desktop in Excel 2003 Pivottables.

When I publish the Pivottable with Pivottable interactivity I get an error in the browser:

The query could not be processed

- An error was encountered in the transport layer

- The peer prematurely closed the connection

In the Pivottable I have set 'Save password' in properties.

Any suggestions ?

Thomas Black

I'm having the same error msg and problem to access SSAS 2005 cube over http at client machine.

This doesn't happen if you work in server (with Sql Server 2005 and web server installed).

|||Hello

did you manage to get around this error? I get this when I try to display a pivottable for data on a remote (but in LAN) server, connect goes through ...

Thanks for any help

Regards
Klaus Wiesel
|||

I used this link:

http://www.microsoft.com/downloads/details.aspx?FamilyID=38be67a5-2056-46a1-84b1-337ffb549c5c&DisplayLang=en

That enables Pivottables and charts in Sharepoint. Very easy to use. Useful for designing dashboards.

Regard

Thomas

|||

I also encountered this problem ,need any solutions!

thanks a lot!

|||

Hello

I solved this for me.

The following is done by my app:

1) Connect to the server to access the existing AS databases and their cubes

2) make a connectionstring that is later on passed to the pivottable control (named opData here):

.opData.ConnectionString = sConnString
.opData.DataMember = .coCUBE_NAME
When building the sConnString you have to use a named user (in the format domain\username) with his password to be able to display the data of the remote machine

Regards

Klaus

Publishing OLAP based Pivotables from Excel

Hi

I want to publish an OLAP based pivottables from Excel to a HTML file using Office web componets.

I have a server with SQL Analysis Services 2005 cubes and I can browse the cube from my desktop in Excel 2003 Pivottables.

When I publish the Pivottable with Pivottable interactivity I get an error in the browser:

The query could not be processed

- An error was encountered in the transport layer

- The peer prematurely closed the connection

In the Pivottable I have set 'Save password' in properties.

Any suggestions ?

Thomas Black

I'm having the same error msg and problem to access SSAS 2005 cube over http at client machine.

This doesn't happen if you work in server (with Sql Server 2005 and web server installed).

|||Hello

did you manage to get around this error? I get this when I try to display a pivottable for data on a remote (but in LAN) server, connect goes through ...

Thanks for any help

Regards
Klaus Wiesel
|||

I used this link:

http://www.microsoft.com/downloads/details.aspx?FamilyID=38be67a5-2056-46a1-84b1-337ffb549c5c&DisplayLang=en

That enables Pivottables and charts in Sharepoint. Very easy to use. Useful for designing dashboards.

Regard

Thomas

|||

I also encountered this problem ,need any solutions!

thanks a lot!

|||

Hello

I solved this for me.

The following is done by my app:

1) Connect to the server to access the existing AS databases and their cubes

2) make a connectionstring that is later on passed to the pivottable control (named opData here):

.opData.ConnectionString = sConnString
.opData.DataMember = .coCUBE_NAME
When building the sConnString you have to use a named user (in the format domain\username) with his password to be able to display the data of the remote machine

Regards

Klaus

Publishing initial snapshot through IIS like SSCE...

Hi,
Just for curiosity, is it possible in SQL Server 2000 to publish the initial
snapshot through IIS the same way that uses SQL Server CE for accessing it?
Thanks in advance
Faustino Dina
If my email address starts with two 'f'
drop the first 'f' when mailing me.
yes, if you configure ftp to listen on port 80. No, if you insist on using
the http protocol.
"faustino Dina" <ffdina@.matusa.com.mx> wrote in message
news:u8C3oNckEHA.1656@.TK2MSFTNGP09.phx.gbl...
> Hi,
> Just for curiosity, is it possible in SQL Server 2000 to publish the
initial
> snapshot through IIS the same way that uses SQL Server CE for accessing
it?
> Thanks in advance
> --
> Faustino Dina
> If my email address starts with two 'f'
> drop the first 'f' when mailing me.
>

publishing downloading report model

Hi friends

is it possible download a report model (.smdl) from a report server?

and also how to publish a report model?

i know how to do this from report manager page but i need to do this programmatically (from C#).

any ideas please. Thanks.

any ideas dudes ?

Thanks for ur help.

|||

publish model using SOAP method CreateModel, then bind it to a data source using SetItemDataSources

|||

Thank you very much Lev.i'll use that method to upload.

BTW i cant find any method to download a model mate ?

any ideas?

Thanks for ur help again.

|||GetModelDefinition|||

Thanks for that Lev. thats what am looking for.

BTW is there any sample code on these methods ?

|||Hi Lev
thanks for that . i finally able to upload a report model using "createModel" but after uploading i still need to set its data source manually from report manager page to get it work!

as you know "createModel" has parameter called "property[]" ,can i use it to set data source ? if so how can i please ?

or you said i could use "setItemDatasources" but i cant figure out how to use this one ?

can you help ?
Thanks
|||BTW Lev
how can i overwrite the report model if already exists?
at the moment am getting following exception

System.Web.Services.Protocols.SoapException: The item '/Models/copyofORM' already exists.

Thanks.|||

Here is some sample code that may give you some ideas:

http://www.sqldbatips.com/samples/code/RSScripter/readme.htm#_script_model

|||

prk wrote:

how can i overwrite the report model if already exists?
at the moment am getting following exception

System.Web.Services.Protocols.SoapException: The item '/Models/copyofORM' already exists.

It is not possible to override model with different model. You have to delete existing model first (note, that this will break all reports using that model)

|||

Lev Semenets - MSFT wrote:

It is not possible to override model with different model. You have to delete existing model first (note, that this will break all reports using that model)

Lev

actually am not overwriting with different model. first i download what already there ,make few changes and re upload the model.

when we upload a model from report manager page ,as you know, there is an option to overwrite , i wonder if we can do same thing programmatically ?

|||

Lev Semenets - MSFT wrote:

Here is some sample code that may give you some ideas:

http://www.sqldbatips.com/samples/code/RSScripter/readme.htm#_script_model

Thats wonderful Lev.

will go thru all examples here. Thanks for ur time and help :)

publishing downloading report model

Hi friends

is it possible download a report model (.smdl) from a report server?

and also how to publish a report model?

i know how to do this from report manager page but i need to do this programmatically (from C#).

any ideas please. Thanks.

any ideas dudes ?

Thanks for ur help.

|||

publish model using SOAP method CreateModel, then bind it to a data source using SetItemDataSources

|||

Thank you very much Lev.i'll use that method to upload.

BTW i cant find any method to download a model mate ?

any ideas?

Thanks for ur help again.

|||GetModelDefinition|||

Thanks for that Lev. thats what am looking for.

BTW is there any sample code on these methods ?

|||Hi Lev
thanks for that . i finally able to upload a report model using "createModel" but after uploading i still need to set its data source manually from report manager page to get it work!

as you know "createModel" has parameter called "property[]" ,can i use it to set data source ? if so how can i please ?

or you said i could use "setItemDatasources" but i cant figure out how to use this one ?

can you help ?
Thanks
|||BTW Lev
how can i overwrite the report model if already exists?
at the moment am getting following exception

System.Web.Services.Protocols.SoapException: The item '/Models/copyofORM' already exists.

Thanks.|||

Here is some sample code that may give you some ideas:

http://www.sqldbatips.com/samples/code/RSScripter/readme.htm#_script_model

|||

prk wrote:

how can i overwrite the report model if already exists?
at the moment am getting following exception

System.Web.Services.Protocols.SoapException: The item '/Models/copyofORM' already exists.

It is not possible to override model with different model. You have to delete existing model first (note, that this will break all reports using that model)

|||

Lev Semenets - MSFT wrote:

It is not possible to override model with different model. You have to delete existing model first (note, that this will break all reports using that model)

Lev

actually am not overwriting with different model. first i download what already there ,make few changes and re upload the model.

when we upload a model from report manager page ,as you know, there is an option to overwrite , i wonder if we can do same thing programmatically ?

|||

Lev Semenets - MSFT wrote:

Here is some sample code that may give you some ideas:

http://www.sqldbatips.com/samples/code/RSScripter/readme.htm#_script_model

Thats wonderful Lev.

will go thru all examples here. Thanks for ur time and help :)

Publishing data while using same server as distributor

Hi all,
I am trying to publish data making the same server as Distributor while
using the wizard it says i am using "sa" account and the server cannot be
used as a distributor if i use "sa" account,how do i go around this? do i
need to stop the server and start with a different account? and setup server
agent to use other account ?
Can anyone clear my doubts?
Thanks
Sudha
Does it say "Local System" or "sa" I have never heard of it having a problem
with the sa account but I have when it uses the local system account. Can
you ensure that your SQL Server service account is running under a domain
account? Make this change through enterprise manager.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"sudha" <sudha@.discussions.microsoft.com> wrote in message
news:9DA7173A-C32D-4953-9453-8AEE0656F752@.microsoft.com...
> Hi all,
> I am trying to publish data making the same server as Distributor while
> using the wizard it says i am using "sa" account and the server cannot be
> used as a distributor if i use "sa" account,how do i go around this? do i
> need to stop the server and start with a different account? and setup
server
> agent to use other account ?
> Can anyone clear my doubts?
> Thanks
> Sudha
|||Hi Hilary,
I appreciate your reply. Yes it says "SQL Server Agent on "servername" uses
System Account,which causes replication between servers to fail.
You suggested me to change,sql service account ,how do i change it and do i
need to stop and start the server after i make a change?
I will be thankful if i can get this answer.
Sudha
"Hilary Cotter" wrote:

> Does it say "Local System" or "sa" I have never heard of it having a problem
> with the sa account but I have when it uses the local system account. Can
> you ensure that your SQL Server service account is running under a domain
> account? Make this change through enterprise manager.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "sudha" <sudha@.discussions.microsoft.com> wrote in message
> news:9DA7173A-C32D-4953-9453-8AEE0656F752@.microsoft.com...
> server
>
>
|||Right click on EM, select Properties, click on the security tab and its at
the bottom - yes there will be a restart.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"sudha" <sudha@.discussions.microsoft.com> wrote in message
news:9B912EFE-BF61-4C57-B7A1-2F35F430B5D7@.microsoft.com...
> Hi Hilary,
> I appreciate your reply. Yes it says "SQL Server Agent on "servername"
uses
> System Account,which causes replication between servers to fail.
> You suggested me to change,sql service account ,how do i change it and do
i[vbcol=seagreen]
> need to stop and start the server after i make a change?
> I will be thankful if i can get this answer.
> Sudha
> "Hilary Cotter" wrote:
problem[vbcol=seagreen]
Can[vbcol=seagreen]
domain[vbcol=seagreen]
while[vbcol=seagreen]
cannot be[vbcol=seagreen]
do i[vbcol=seagreen]
|||Hi Hilary,
Thanks for your response again but in my EM in the Security Tab of database
properties the server agent account start up options frame is disabled,why is
it? and what do i do with it?
thanks
sudha
"Hilary Cotter" wrote:

> Right click on EM, select Properties, click on the security tab and its at
> the bottom - yes there will be a restart.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "sudha" <sudha@.discussions.microsoft.com> wrote in message
> news:9B912EFE-BF61-4C57-B7A1-2F35F430B5D7@.microsoft.com...
> uses
> i
> problem
> Can
> domain
> while
> cannot be
> do i
>
>
|||You need to set up a domain user account for your sql
server service and sql server agent. Editing the startup
properties in EM won't give you the option to browse AD,
so it's easiest to do this in Control Panel,
Administratove Tools, Services.
Have a look for MSSQLSERVER, SQLSERVERAGENT. For
replication purposes we are almost always just concerned
with the latter service. From the ideal DBA point of
view, you should change them both, however. To make
things simple, select the same domain user for both
services, and this account must be a local administrator.
If not, you'll end up editing permissions on various
registry keys, and you really don't want to have to do
this. After you've restarted, it should all be tickety-
boo.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

>--Original Message--
>Hi Hilary,
>Thanks for your response again but in my EM in the
Security Tab of database
>properties the server agent account start up options
frame is disabled,why is[vbcol=seagreen]
>it? and what do i do with it?
>thanks
>sudha
>"Hilary Cotter" wrote:
security tab and its at[vbcol=seagreen]
message[vbcol=seagreen]
2F35F430B5D7@.microsoft.com...[vbcol=seagreen]
Agent on "servername"[vbcol=seagreen]
servers to fail.[vbcol=seagreen]
do i change it and do[vbcol=seagreen]
change?[vbcol=seagreen]
heard of it having a[vbcol=seagreen]
local system account.[vbcol=seagreen]
running under a[vbcol=seagreen]
manager.[vbcol=seagreen]
message[vbcol=seagreen]
8AEE0656F752@.microsoft.com...[vbcol=seagreen]
server as Distributor[vbcol=seagreen]
account and the server[vbcol=seagreen]
do i go around this?[vbcol=seagreen]
different account? and setup
>.
>
|||Thanks Paul,
I will try out the things which you have suggested and let you know if i am
fine.
Great to know how things get fixed and from which places.The more we try to
dig the more we are ignorant.Thanks for giving me the information.
Sudha
"Paul Ibison" wrote:

> You need to set up a domain user account for your sql
> server service and sql server agent. Editing the startup
> properties in EM won't give you the option to browse AD,
> so it's easiest to do this in Control Panel,
> Administratove Tools, Services.
> Have a look for MSSQLSERVER, SQLSERVERAGENT. For
> replication purposes we are almost always just concerned
> with the latter service. From the ideal DBA point of
> view, you should change them both, however. To make
> things simple, select the same domain user for both
> services, and this account must be a local administrator.
> If not, you'll end up editing permissions on various
> registry keys, and you really don't want to have to do
> this. After you've restarted, it should all be tickety-
> boo.
> Rgds,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
>
> Security Tab of database
> frame is disabled,why is
> security tab and its at
> message
> 2F35F430B5D7@.microsoft.com...
> Agent on "servername"
> servers to fail.
> do i change it and do
> change?
> heard of it having a
> local system account.
> running under a
> manager.
> message
> 8AEE0656F752@.microsoft.com...
> server as Distributor
> account and the server
> do i go around this?
> different account? and setup
>

Publishing Crystal Reports in Web

Hi,

I'm using CR9. Planning to publish them in the web. Used ASP to publish them

But Is it necessary to instal CR 9 in the server.

My CreateObject("CrystalRuntime.Application.9") Failed because of Invalid ProgId Error.

Have any idea pls tell me,

ThanksI don't know anything about Crystal Reports for the Web, but I think Crystal Enterprise was created for that. Try a search on that for your answer.|||It's working. Installed crystal reports and its corresponding web components.

Anyway, thanks for your response

Publishing CR .rpt file into SSR

I have some crystal reports .rpt files that I'd like to publish to users via
the SSR menu. Is there anyway to do this?
THanks
--
DougThere is nothing built into the product to convert crystal reports to RS
reports. There is at least one consulting company that will convert reports
for you.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Doug Little" <littldo@.yahoo.com.(donotspam)> wrote in message
news:615C9F22-3E66-403B-A762-E3C8D08E4C43@.microsoft.com...
>I have some crystal reports .rpt files that I'd like to publish to users
>via
> the SSR menu. Is there anyway to do this?
> THanks
> --
> Doug

Publishing a subscriber...

Hello...
I am looking to see if it is possible to publish a subscriber... so i have
the following:
publisher -> distributor -> subscriber
What I want is
publisher -> distributor -> subscriber (now a publisher as well) ->
distributor -> new subscriber
Is this possible? Has anyone had experience with this? All servers are SQL
Server 2000.
Please advise...
Thanks,
Brett
Brett,
please have a look here:
http://www.replicationanswers.com/Republishing2005.asp
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
|||It is possible, and infact recommended when you are using merge replication.
However you should ensure that the remote distributor is clustered as this
introduces a single point of failure.
Remote distributors are more critical in high volume transactional
replication topologies. They are unnecessary in merge replication.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Brett Davis" <sqlsquirrel@.msn.com> wrote in message
news:efumTHWRHHA.3412@.TK2MSFTNGP02.phx.gbl...
> Hello...
> I am looking to see if it is possible to publish a subscriber... so i have
> the following:
> publisher -> distributor -> subscriber
> What I want is
> publisher -> distributor -> subscriber (now a publisher as well) ->
> distributor -> new subscriber
> Is this possible? Has anyone had experience with this? All servers are
> SQL Server 2000.
> Please advise...
> Thanks,
> Brett
>
|||On Jan 31, 12:01 pm, "Brett Davis" <sqlsquir...@.msn.com> wrote:
> Hello...
> I am looking to see if it is possible to publish a subscriber... so i have
> the following:
> publisher -> distributor -> subscriber
> What I want is
> publisher -> distributor -> subscriber (now a publisher as well) ->
> distributor -> new subscriber
> Is this possible? Has anyone had experience with this? All servers are SQL
> Server 2000.
> Please advise...
> Thanks,
> Brett
Brett;
I've got about 90 databases set up similar to this:
Publisher/Distributor -> Subscriber -> Distributor -> Subscriber
One thing that affected me is when setting up conflict resolution, I
had to select the decimal Priority figure before it would let me set
this up. This may just be because my publishers are using the desktop
version of MSSQL2K.
Another item that I am currently having trouble with is schema
changes. When I use the appropriate stored procedures to alter
tables, and then I restart the snapshot agent on the publishers, the
changes are propagated to the first subscriber, but they don't make it
to the second subscriber. I need to start another thread about
that. ;)
-Joseph

publishing a report with parameters

say if i have a report that takes 2 parameters, StartDate & EndDate. and i want to publish/deploy this report for other users to run. Will the user be prompted to enter the 2 dates when they attempt to run the report?

sorry for the "what if" type question. ive been asked to do a bit of research on SQL Reporting Services

Cheers,
Craig

This depends on the report setup and on the method of access.

By report setup I mean the parameter. You can configure these with defaults and hence the users won't need to select the values but will still have the option to change the defaults.

By method of access I mean whether you are using the report manager (or some equivalent method of URL access) or the ReportServerWebService.Render method. By using URL access you get the "out of the box" export toolbar and parameter toolbar. By using the web service you pass in the paramaeter values but do not get the mentioned toolbars.

Remember, parameter defaults can be query based so for dates this can be made to return a dynamic value such as the current date.

Publishing a report programmatically.

Hi!

I have a rdl file and would like to publish it programmatically? Is there any API or Web Service available for this.

Hello Vivekananda:

SQL Server 2005 Reporting Services (SSRS) provides a full-featured set of APIs that you can use to integrate Reporting Services with custom business applications and extend its functionality.

The Report Server Web service provides access to the full functionality of the report server.

A Report Server Web service is an Extensible Markup Language (XML) Web service with a Simple Object Access Protocol (SOAP) API. You can use the Web service to add the functionality of Reporting Services to your business applications.

For more information of the Report Server Web Service:

http://msdn2.microsoft.com/fr-fr/library/ms152787(SQL.90).aspx

ReportingService2005 Class contains the methods and properties that can be used to call the Microsoft SQL Server 2005 Reporting Services (SSRS) Web service.

You can use the method 'ReportingService2005.CreateReport' to create new report to the report server database.

Here is a code example for this:

Code Snippet

class Sample
{
public static void Main()
{
ReportingService2005 rs = new ReportingService2005();
rs.Credentials = System.Net.CredentialCache.DefaultCredentials;

Byte[] definition = null;
Warning[] warnings = null;
string name = "MyReport";

try
{
FileStream stream = File.OpenRead("MyReport.rdl");
definition = new Byte[stream.Length];
stream.Read(definition, 0, (int) stream.Length);
stream.Close();
}

catch(IOException e)
{
Console.WriteLine(e.Message);
}

try
{
warnings = rs.CreateReport(name, "/Samples", false, definition, null);

if (warnings != null)
{
foreach (Warning warning in warnings)
{
Console.WriteLine(warning.Message);
}
}

else
Console.WriteLine("Report: {0} created successfully with no warnings", name);
}

catch (SoapException e)
{
Console.WriteLine(e.Detail.InnerXml.ToString());
}

}
}

Hope this helps.

For more information:

Report Server Web Service Features

Report Server Namespace Management Methods

Good luck.

Publishing a report programmatically.

Hi!

I have a rdl file and would like to publish it programmatically? Is there any API or Web Service available for this.

Hello Vivekananda:

SQL Server 2005 Reporting Services (SSRS) provides a full-featured set of APIs that you can use to integrate Reporting Services with custom business applications and extend its functionality.

The Report Server Web service provides access to the full functionality of the report server.

A Report Server Web service is an Extensible Markup Language (XML) Web service with a Simple Object Access Protocol (SOAP) API. You can use the Web service to add the functionality of Reporting Services to your business applications.

For more information of the Report Server Web Service:

http://msdn2.microsoft.com/fr-fr/library/ms152787(SQL.90).aspx

ReportingService2005 Class contains the methods and properties that can be used to call the Microsoft SQL Server 2005 Reporting Services (SSRS) Web service.

You can use the method 'ReportingService2005.CreateReport' to create new report to the report server database.

Here is a code example for this:

Code Snippet

class Sample
{
public static void Main()
{
ReportingService2005 rs = new ReportingService2005();
rs.Credentials = System.Net.CredentialCache.DefaultCredentials;

Byte[] definition = null;
Warning[] warnings = null;
string name = "MyReport";

try
{
FileStream stream = File.OpenRead("MyReport.rdl");
definition = new Byte[stream.Length];
stream.Read(definition, 0, (int) stream.Length);
stream.Close();
}

catch(IOException e)
{
Console.WriteLine(e.Message);
}

try
{
warnings = rs.CreateReport(name, "/Samples", false, definition, null);

if (warnings != null)
{
foreach (Warning warning in warnings)
{
Console.WriteLine(warning.Message);
}
}

else
Console.WriteLine("Report: {0} created successfully with no warnings", name);
}

catch (SoapException e)
{
Console.WriteLine(e.Detail.InnerXml.ToString());
}

}
}

Hope this helps.

For more information:

Report Server Web Service Features

Report Server Namespace Management Methods

Good luck.

Publisherand suscriptor

Hello,
my question is the following: is it possible a database server can suscript
to a database "A" like a pull or push suscription and publish the same
database to another machines?. So, the machine is suscriptor and publisher of
the same database.
Are there any possible to do that in MSDE 2000?.
Thanks very much.
I see that arrangement described in BOL but have been unable to find out how to set it up.<br />If anyone has any idea how to set this up for merge replication or where to get the info. It would be a big help.<br />thabks.<br /><br />Thanks.