473,324 Members | 2,370 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

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 2092

"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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Teo Lachev | last post by:
I would like to introduce you officially to my book "Reporting Services in Action" and let you know about its availability. I wrote this book for information workers, system administrators and...
3
by: Mohammad S Khan | last post by:
I am currently doing some research on reporting features provided / compatible with dotnet features. Our current application has excel reprots that are emailed both with an without scheduling...
4
by: Fabian von Romberg | last post by:
Hi, I have installed Sql Reporting Services on 2 machines, one is WIN 2000 PRO and the other one is WIN 2000 ADV. SERVER. When I try to access a report using the webbrowser, I get the following...
8
by: Woody Splawn | last post by:
I am asking this question here because I asked this question in the Reporting Services Newsgroup and did not get an answer. Does anyone know if Reporting Services is intended to work in a...
1
by: iThinkData | last post by:
Should these 3 items, .Net 2.0 Website, SQLServer 2005, Reporting Services 2005. all reside on the same computer? I know that the website issues a configuration error saying it can't find...
1
by: rmk | last post by:
How can I get the 2000 and 2005 versions of SQL Server Reporting Services both working on my development laptop ????? I have ASP.NET 1.1 and 2.0 installed on my laptop. I have Visual Studio...
3
by: =?Utf-8?B?Sm9uIEphY29icw==?= | last post by:
We use SQL Server 2000 We user VS 2005 How can we use SQL Server reporting Services? Thanks,
3
by: Blasting Cap | last post by:
I'm using VS 2005, SQL 2005 reporting services. SQL reporting services is working, and I have it both on my local computer, as well as on a server. I've created a report in the SQL Business...
0
by: fperri | last post by:
Hi, I am trying to configure reporting services which I just added to an already existing installation of SQL Server 2005. When I am in the reporting services configuration manager and I am trying...
0
by: JTP PR | last post by:
Business Intelligence software company, Yellowfin today announced its successful foray into the Asia Pacific telecommunications sector through its expanding partner network. Two organisations,...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.