469,097 Members | 1,430 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,097 developers. It's quick & easy.

Reporting Services

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
7 1935

"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
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
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
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
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
All of my posts are thru google groups....

Thx,

BZ

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

Similar topics

reply views Thread by Teo Lachev | last post: by
3 posts views Thread by Mohammad S Khan | last post: by
4 posts views Thread by Fabian von Romberg | last post: by
8 posts views Thread by Woody Splawn | last post: by
3 posts views Thread by =?Utf-8?B?Sm9uIEphY29icw==?= | last post: by
reply views Thread by kglaser89 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.