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]

Re: Reporting Services


"no one" <noone@yahoo.co m> wrote in message
news:41F5B2A4.F 914D002@yahoo.c om...[color=blue]
>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?
>
>[/color]

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

http://www.reportingservicesfaq.com/ow.asp?ChangingDatasources

But it seems to be a common question, and there have been some solutions
discussed in microsoft.publi c.sqlserver.rep ortingsvcs:

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%3DSearch%26meta%3Dgroup%253Dmicrosoft.public.sqlserver.reportingsvcs

Simon

[no one]

Re: Reporting Services

Simon Hayes wrote:
[color=blue]
> "no one" <noone@yahoo.co m> wrote in message
> news:41F5B2A4.F 914D002@yahoo.c om...[color=green]
> >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?
> >
> >[/color]
>
> The short answer appears to be that you can't:
>
> http://www.reportingservicesfaq.com/...ingDatasources[/color]

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

[color=blue]
>
> But it seems to be a common question, and there have been some solutions
> discussed in microsoft.publi c.sqlserver.rep ortingsvcs:
>
> http://groups.google.ch/groups?hl=en...server.reporti
> Simon[/color]

Unfortunately, my ISP does not offer this newsgroup.

Thanks.

[xAvailx]

Re: Reporting Services

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]

Re: Reporting Services

xAvailx wrote:
[color=blue]
> The link Simon posted was thru Google Groups. You shouldn't need a
> newsreader/server to view the newsgroup thru Google Groups.
>[/color]

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

[Erland Sommarskog]

Re: Reporting Services

no one (noone@yahoo.co m) writes:[color=blue]
> Unfortunately, my ISP does not offer this newsgroup.[/color]

But it offerss microsoft.publi c.sqlserver.mis c which is defunct.

Anyway, you can tune into msnews.microsof t.com to get access to
all mirosoft.public .* newsgroups.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarsk og.se

Books Online for SQL Server SP3 at

http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

[xAvailx]

Re: Reporting Services

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

Thx,

BZ

[Michael van der Veeke]

Re: Reporting Services

My ISP was the same, but I got it from

msnews.microsof t.com

good luck

Michael

no one wrote:[color=blue]
> Simon Hayes wrote:
>[color=green]
>> "no one" <noone@yahoo.co m> wrote in message
>> news:41F5B2A4.F 914D002@yahoo.c om...[color=darkred]
>> >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[/color]
>> the[color=darkred]
>> > file once it has been deployed to the server. For the amount of[/color]
>> reports[color=darkred]
>> > that need to be created, this is impractical. Any pointers?
>> >
>> >[/color]
>>
>> The short answer appears to be that you can't:
>>
>> http://www.reportingservicesfaq.com/...ingDatasources
>>[/color]
> This is actually similar to what I am doing. Different reports for each
> environment.
>
>[color=green]
>>
>> But it seems to be a common question, and there have been some solutions
>> discussed in microsoft.publi c.sqlserver.rep ortingsvcs:
>>
>> http://groups.google.ch/groups?hl=en...server.reporti
>> <http://groups.google.c h/groups?hl=en&lr =&client=firefo x-a&rls=org.mozil la:en-GB:official&thr eadm=uxWX9v2%23 EHA.4092%40TK2M SFTNGP09.phx.gb l&rnum=5&prev =/groups%3Fhl%3De n%26lr%3D%26cli ent%3Dfirefox-a%26rls%3Dorg.m ozilla%253Aen-GB%253Aofficial %26q%3Dchange%2 Bdatasource%26b tnG%3DSearch%26 meta%3Dgroup%25 3Dmicrosoft.pub lic.sqlserver.r eportingsvcs>
>>
>> Simon
>> <http://groups.google.c h/groups?hl=en&lr =&client=firefo x-a&rls=org.mozil la:en-GB:official&thr eadm=uxWX9v2%23 EHA.4092%40TK2M SFTNGP09.phx.gb l&rnum=5&prev =/groups%3Fhl%3De n%26lr%3D%26cli ent%3Dfirefox-a%26rls%3Dorg.m ozilla%253Aen-GB%253Aofficial %26q%3Dchange%2 Bdatasource%26b tnG%3DSearch%26 meta%3Dgroup%25 3Dmicrosoft.pub lic.sqlserver.r eportingsvcs>
>>[/color]
> Unfortunately, my ISP does not offer this newsgroup.
>
> Thanks.
>[/color]