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? 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
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.
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 (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
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" <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. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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,
|
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...
|
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...
|
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,...
|
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...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
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...
|
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...
|
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)...
|
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...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
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...
|
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...
| |