By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,265 Members | 1,333 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,265 IT Pros & Developers. It's quick & easy.

Reporting Services

P: n/a
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?
Jul 23 '05 #1
Share this Question
Share on Google+
7 Replies


P: n/a

"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
Jul 23 '05 #2

P: n/a
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.

Jul 23 '05 #3

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

Thx,

BZ

Jul 23 '05 #4

P: n/a
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.

Jul 23 '05 #5

P: n/a
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
Jul 23 '05 #6

P: n/a
All of my posts are thru google groups....

Thx,

BZ

Jul 23 '05 #7

P: n/a
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.

Jul 23 '05 #8

This discussion thread is closed

Replies have been disabled for this discussion.