Publish to Multiple folders

Is it possible to publish reports in a project to different target folders?
It seem like all of the reports must be sent to the same folder and then
moved, which is quite annoying. Am I missing something?
TIA
DeanI split the reports in the development environment to different projects.
Each project goes to a different folder.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Dean" <deanl144@.hotmail.com.nospam> wrote in message
news:OMxvOJpCIHA.748@.TK2MSFTNGP04.phx.gbl...
> Is it possible to publish reports in a project to different target
> folders? It seem like all of the reports must be sent to the same folder
> and then moved, which is quite annoying. Am I missing something?
> TIA
> Dean
>|||I agree that this is rather annoying.
If you have separate projects for each report how do you handle Shared
Data Sources? For instance, if you have 5 reports in 5 individual
projects all using the same shared data source, and that data source
changes, do you need to update all 5 projects, otherwise one will over
write the other?
On Oct 9, 10:33 am, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
wrote:
> I split the reports in the development environment to different projects.
> Each project goes to a different folder.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Dean" <deanl...@.hotmail.com.nospam> wrote in message
> news:OMxvOJpCIHA.748@.TK2MSFTNGP04.phx.gbl...
> > Is it possible to publish reports in a project to different target
> > folders? It seem like all of the reports must be sent to the same folder
> > and then moved, which is quite annoying. Am I missing something?
> > TIA
> > Dean|||I name the shared data source the same name in each project. Yes, I have to
update the data sources in each project but I only have to do it once on the
server. In RS 2005 you have the option of putting all your shared data
sources in one place which I have done. All the folders use the same shared
data sources.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Matt Penner" <mattpenner2007@.gmail.com> wrote in message
news:1191966220.593999.117590@.g4g2000hsf.googlegroups.com...
>I agree that this is rather annoying.
> If you have separate projects for each report how do you handle Shared
> Data Sources? For instance, if you have 5 reports in 5 individual
> projects all using the same shared data source, and that data source
> changes, do you need to update all 5 projects, otherwise one will over
> write the other?
> On Oct 9, 10:33 am, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
> wrote:
>> I split the reports in the development environment to different projects.
>> Each project goes to a different folder.
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Dean" <deanl...@.hotmail.com.nospam> wrote in message
>> news:OMxvOJpCIHA.748@.TK2MSFTNGP04.phx.gbl...
>> > Is it possible to publish reports in a project to different target
>> > folders? It seem like all of the reports must be sent to the same
>> > folder
>> > and then moved, which is quite annoying. Am I missing something?
>> > TIA
>> > Dean
>|||Ah, thanks.
On Oct 10, 6:52 am, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
wrote:
> I name the shared data source the same name in each project. Yes, I have to
> update the data sources in each project but I only have to do it once on the
> server. In RS 2005 you have the option of putting all your shared data
> sources in one place which I have done. All the folders use the same shared
> data sources.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Matt Penner" <mattpenner2...@.gmail.com> wrote in message
> news:1191966220.593999.117590@.g4g2000hsf.googlegroups.com...
> >I agree that this is rather annoying.
> > If you have separate projects for each report how do you handle Shared
> > Data Sources? For instance, if you have 5 reports in 5 individual
> > projects all using the same shared data source, and that data source
> > changes, do you need to update all 5 projects, otherwise one will over
> > write the other?
> > On Oct 9, 10:33 am, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
> > wrote:
> >> I split the reports in the development environment to different projects.
> >> Each project goes to a different folder.
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >> "Dean" <deanl...@.hotmail.com.nospam> wrote in message
> >>news:OMxvOJpCIHA.748@.TK2MSFTNGP04.phx.gbl...
> >> > Is it possible to publish reports in a project to different target
> >> > folders? It seem like all of the reports must be sent to the same
> >> > folder
> >> > and then moved, which is quite annoying. Am I missing something?
> >> > TIA
> >> > Dean

Publication Problem

Hello,
I want to Create Publication with the Wizard but i always have a great
problem: After i click on okay on the Specify Snapshot Folder i always get
the following error:
"SQL Server Enterprise Manager could not retrieve information about the
Distributor of the database. Error 1038: Cannot use empty object or column
names. Use a single space if necessary."
And when i click on okay and the "Choose Publication Database" screen
appears i cannnot choose any database because in there do not appear any
databases.
What went wrong here?
Can anybody please help me here?
regards
patrick
PS: When i want to create a new Table for a Database a similar error occurs:
An unexpected error happened during this operation.
[Microsoft SQL-DMO (ODBC SQLState: 42000) - Cannot use empty object or
column names. Use a single space if necessary.
Maybe this could help to explain me what went wrong in my Enterprise Manager
that the Publication does not work correctly?
Hello,
I installed the Microsoft SQL Server 2000 on my machine once more and
fortunately the Publicaten worked. I did it like it is quoted in your posted
doc-file and on this
<a
href=http://msdn.microsoft.com/SQL/SQLCE/default.aspx?pull=/msdnmag/issues/03/09/datapoints/default.aspx> ReplicationExample
site, because i want to go through the sample of this site.
But it were to good to be true if all would be work, when i deploy the
sample application from this site on the Emulator and presses the
Synch-Button of the application, the following error occurs in a message box
on the display:
Error #1 of 1
Error Code: -2147012867
Message: A request to send data to the computer running IIS has failed. For
more information, see HRESULT.[,,,,]
Minor Err.: 28037
Source: Microsoft SQL Server 2000 Windows CE Edition.
Do know what went wrong here or do i have forgotten anything during the
Create Virtual Directory Wizard or the Publication Wizard or anything else?
Hopefully you are willing to help me again, because i do not simply look
through it.
regards
patrick
PS: I did all as i quoted it in the previous posting and once more my IIS,
SQL Server 2000 and VS.NET are all on the same machine.

publication

Use refresh in EM on the publications folder and the
replication monitor, publishers subfolders. This should
synchronize them. Alternatively use sp_helppublication to
see the list.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
Hi Paul:
I refresh all , but it's same
Cheers
nick
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:17e901c50f73$932c8030$a601280a@.phx.gbl...
> Use refresh in EM on the publications folder and the
> replication monitor, publishers subfolders. This should
> synchronize them. Alternatively use sp_helppublication to
> see the list.
> Rgds,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
|||Nick,
does sp_helppublication return one or five publications?
Rgds,
Paul Ibison (SQL Server MVP)
"Nick" <fsheng@.ebreathe.co.nz> wrote in message
news:e8ImhjgEFHA.2700@.TK2MSFTNGP14.phx.gbl...
> Hi Paul:
> I refresh all , but it's same
> Cheers
> nick
> "Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
> news:17e901c50f73$932c8030$a601280a@.phx.gbl...
>
|||HI Paul:
only say The command(s) completed successfully when i execute this stored
procedure. doesn't return any number of publication?
Could you tell me how to use this sp?
Cheers
nick
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:Oe0ILMhEFHA.548@.TK2MSFTNGP14.phx.gbl...
> Nick,
> does sp_helppublication return one or five publications?
> Rgds,
> Paul Ibison (SQL Server MVP)
> "Nick" <fsheng@.ebreathe.co.nz> wrote in message
> news:e8ImhjgEFHA.2700@.TK2MSFTNGP14.phx.gbl...
>
|||Nick,
just run it with no arguments in the publishing database - it should return
one row or five, and will tell us which data is correct.
Rgds,
Paul
"Nick" <fsheng@.ebreathe.co.nz> wrote in message
news:uagXd35EFHA.2832@.TK2MSFTNGP14.phx.gbl...
> HI Paul:
> only say The command(s) completed successfully when i execute this
> stored
> procedure. doesn't return any number of publication?
> Could you tell me how to use this sp?
> Cheers
> nick
> "Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
> news:Oe0ILMhEFHA.548@.TK2MSFTNGP14.phx.gbl...
>