Reporting Services

[no one]

I am looking for informaton about Reporting Services, in particular how
to change the datasource, username and password for a report
programmically. Right now, I can only get it to work after changing the
file once it has been deployed to the server. For the amount of reports
that need to be created, this is impractical. Any pointers?

[Simon Hayes]

"no one" <no***@yahoo.com> wrote in message
news:41***************@yahoo.com...

I am looking for informaton about Reporting Services, in particular how
to change the datasource, username and password for a report
programmically. Right now, I can only get it to work after changing the
file once it has been deployed to the server. For the amount of reports
that need to be created, this is impractical. Any pointers?

The short answer appears to be that you can't:

http://www.reportingservicesfaq.com/...ingDatasources

But it seems to be a common question, and there have been some solutions
discussed in microsoft.public.sqlserver.reportingsvcs:

http://groups.google.ch/groups?hl=en....reportingsvcs

Simon

[no one]

Simon Hayes wrote:

"no one" <no***@yahoo.com> wrote in message
news:41***************@yahoo.com...

I am looking for informaton about Reporting Services, in particular how
to change the datasource, username and password for a report
programmically. Right now, I can only get it to work after changing the
file once it has been deployed to the server. For the amount of reports
that need to be created, this is impractical. Any pointers?
The short answer appears to be that you can't:

http://www.reportingservicesfaq.com/...ingDatasources

This is actually similar to what I am doing. Different reports for each environment.


But it seems to be a common question, and there have been some solutions
discussed in microsoft.public.sqlserver.reportingsvcs:

http://groups.google.ch/groups?hl=en...server.reporti
Simon

Unfortunately, my ISP does not offer this newsgroup.

Thanks.

[xAvailx]

The link Simon posted was thru Google Groups. You shouldn't need a
newsreader/server to view the newsgroup thru Google Groups.

Thx,

BZ

[no one]

xAvailx wrote:

The link Simon posted was thru Google Groups. You shouldn't need a
newsreader/server to view the newsgroup thru Google Groups.

Yes, I know. But it would be nice if I could post as well.

[Erland Sommarskog]

no one (no***@yahoo.com) writes:

Unfortunately, my ISP does not offer this newsgroup.

But it offerss microsoft.public.sqlserver.misc which is defunct.

Anyway, you can tune into msnews.microsoft.com to get access to
all mirosoft.public.* newsgroups.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp

[xAvailx]

All of my posts are thru google groups....

Thx,

BZ

[Michael van der Veeke]

My ISP was the same, but I got it from

msnews.microsoft.com

good luck

Michael

no one wrote:

Simon Hayes wrote:

"no one" <no***@yahoo.com> wrote in message
news:41***************@yahoo.com...

>I am looking for informaton about Reporting Services, in particular how
> to change the datasource, username and password for a report
> programmically. Right now, I can only get it to work after changing

the

> file once it has been deployed to the server. For the amount of

reports

> that need to be created, this is impractical. Any pointers?
>
>

The short answer appears to be that you can't:

http://www.reportingservicesfaq.com/...ingDatasources

This is actually similar to what I am doing. Different reports for each
environment.

But it seems to be a common question, and there have been some solutions
discussed in microsoft.public.sqlserver.reportingsvcs:

http://groups.google.ch/groups?hl=en...server.reporti
<http://groups.google.ch/groups?hl=en&lr=&client=firefox-a&rls=org.mozilla:en-GB:official&threadm=uxWX9v2%23EHA.4092%40TK2MSFTNG P09.phx.gbl&rnum=5&prev=/groups%3Fhl%3Den%26lr%3D%26client%3Dfirefox-a%26rls%3Dorg.mozilla%253Aen-GB%253Aofficial%26q%3Dchange%2Bdatasource%26btnG%3 DSearch%26meta%3Dgroup%253Dmicrosoft.public.sqlser ver.reportingsvcs>

Simon
<http://groups.google.ch/groups?hl=en&lr=&client=firefox-a&rls=org.mozilla:en-GB:official&threadm=uxWX9v2%23EHA.4092%40TK2MSFTNG P09.phx.gbl&rnum=5&prev=/groups%3Fhl%3Den%26lr%3D%26client%3Dfirefox-a%26rls%3Dorg.mozilla%253Aen-GB%253Aofficial%26q%3Dchange%2Bdatasource%26btnG%3 DSearch%26meta%3Dgroup%253Dmicrosoft.public.sqlser ver.reportingsvcs>

Unfortunately, my ISP does not offer this newsgroup.

Thanks.