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?"no one" <noone@.yahoo.com> wrote in message
news:41F5B2A4.F914D002@.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...gingDatasources

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=e...r.reportingsvcs

Simon|||Simon Hayes wrote:

> "no one" <noone@.yahoo.com> wrote in message
> news:41F5B2A4.F914D002@.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...gingDatasources

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=e...er ver.reporti
> Simon

Unfortunately, my ISP does not offer this newsgroup.

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

Thx,

BZ|||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.|||no one (noone@.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, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||All of my posts are thru google groups...

Thx,

BZ|||My ISP was the same, but I got it from

msnews.microsoft.com

good luck

Michael

no one wrote:
> Simon Hayes wrote:
>> "no one" <noone@.yahoo.com> wrote in message
>> news:41F5B2A4.F914D002@.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...gingDatasources
>>
> 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=e...er ver.reporti
>> <http://groups.google.ch/groups?hl=en&lr=&client=firefox-a&rls=org.mozilla:en-GB:official&threadm=uxWX9v2%23EHA.4092%40TK2MSFTNGP09.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%40TK2MSFTNGP09.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.