| Groups | Blog | Home |
sql server reporting services : Set Connection String through code - can this be done?
Report Viewer. This is a technique I used heavily in Crystal. It allowed me to build the reports against the development servers (Web & SQL), and copy the report files to one or more production servers, where the connection settings (SQL Server (Data Source), Database (Initial Catalog), Login (User ID), and Password could be set through code for the report and all subreports. I understand the steps are a little different with reporting services, but this seems pretty basic. Is there really no way to do this? Maybe something not so obvious? Thanks for any help in advance, -Meade
RS 2005 support expression-based connection strings with private data
sources. Look at the ExpressionBasedConnection sample report here (http://prologika.com/CS/blogs/blog/archive/2005/10/05/687.aspx). -- HTH, ---------------------------------------------- Teo Lachev, MVP, MCSD, MCT "Microsoft Reporting Services in Action" "Applied Microsoft Analysis Services 2005" Home page and blog: http://www.prologika.com/ ---------------------------------------------- [quoted text, click to view] "Meade Robboy" <meade_NO_SPAM@earthlink.net> wrote in message news:%23GVBKpH9FHA.3760@TK2MSFTNGP14.phx.gbl... > First, let me say that I am trying to use Server Reports with the Winform > Report Viewer. > > This is a technique I used heavily in Crystal. > It allowed me to build the reports against the development servers (Web & > SQL), and copy the report files to one or more production servers, where > the connection settings (SQL Server (Data Source), Database (Initial > Catalog), Login (User ID), and Password could be set through code for the > report and all subreports. > > I understand the steps are a little different with reporting services, but > this seems pretty basic. > Is there really no way to do this? Maybe something not so obvious? > > Thanks for any help in advance, > -Meade >
Meade, RS uses a datasource entity on the server, this is were the
connectionstring lives, you can use the same name for the datasource but they datasources can be different from server to server. HTH, Ed Richard [quoted text, click to view] "Meade Robboy" <meade_NO_SPAM@earthlink.net> wrote in message news:%23GVBKpH9FHA.3760@TK2MSFTNGP14.phx.gbl... > First, let me say that I am trying to use Server Reports with the Winform > Report Viewer. > > This is a technique I used heavily in Crystal. > It allowed me to build the reports against the development servers (Web & > SQL), and copy the report files to one or more production servers, where > the connection settings (SQL Server (Data Source), Database (Initial > Catalog), Login (User ID), and Password could be set through code for the > report and all subreports. > > I understand the steps are a little different with reporting services, but > this seems pretty basic. > Is there really no way to do this? Maybe something not so obvious? > > Thanks for any help in advance, > -Meade >
Can you explain a little more how to set up the Expression-Based
Connection Strings. I am looking at your code download and I am a little lost. I am new to Reporting Services and I am trying to set it up so that my reports, which are cmmon among several customers, can be reused by simply changing the connection string (initial catalog, maybe the data source/server). Thanks in advance for any help that you can give. Scott
1. Set up a private data source.
2. In the Connection string property enter a VB.NET expression that returns your connection string. In my case, I am calling a property in an external .NET assembly which gets the connection string from the Report Server web.config at runtime. At design time, the GetConnectionString property returns a constant so the report won't blow up in the Report Designer. -- HTH, ---------------------------------------------- Teo Lachev, MVP, MCSD, MCT "Microsoft Reporting Services in Action" "Applied Microsoft Analysis Services 2005" Home page and blog: http://www.prologika.com/ ------------------------------------------------- [quoted text, click to view] <scott.hunley@cox.net> wrote in message news:1133973973.657031.201640@g14g2000cwa.googlegroups.com... > Can you explain a little more how to set up the Expression-Based > Connection Strings. I am looking at your code download and I am a > little lost. I am new to Reporting Services and I am trying to set it > up so that my reports, which are cmmon among several customers, can be > reused by simply changing the connection string (initial catalog, maybe > the data source/server). > > Thanks in advance for any help that you can give. > > Scott >
Does this have to use VB.NET? The component I am using is written in
C#. I am trying to the code that I downloaded from your site: AdventureWorks.Utils.ConnectionString. I am attempting to check the querystring for a parameter (DB=name) to decide which connection string to pull from the web.config file on the Report Server. Currently I just have it where it should default to returning me the connection string that I have declared as a constant, just to prove that it works on the server. However, I am getting the following error when I deploy the report and try to run it: An error has occurred during report processing. Error during processing of the ConnectString expression of datasource 'AdventureWorksPrivate'. I deployed the private assembly to the bin folder on the report server: C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\bin Am I missing something? Should I sign the assembly and deploy it to the GAC? I can't understand why it finds it on the IDE, but not on the server. Any help would be greatly appreciated. Thanks, Scott
[quoted text, click to view]
>Does this have to use VB.NET? No, you can use whatever language you want.[quoted text, click to view] > Am I missing something? Should I sign the assembly and deploy it to > the GAC? I can't understand why it finds it on the IDE, but not on the > server. No, you don't have to. What is probably missing is granting your assembly CAS rights in rssrvpolicy.config,e .g. <CodeGroup class="UnionCodeGroup" version="1" Name="SecurityExtensionCodeGroup" Description="Code group for the AdventureWorks Utils library" PermissionSetName="FullTrust"> <IMembershipCondition class="UrlMembershipCondition" version="1" Url="C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\bin\AdventureWorks.dll" /> </CodeGroup> -- HTH, ---------------------------------------------- Teo Lachev, MVP, MCSD, MCT "Microsoft Reporting Services in Action" "Applied Microsoft Analysis Services 2005" Home page and blog: http://www.prologika.com/ ------------------------------------------------- [quoted text, click to view] <scott.hunley@cox.net> wrote in message news:1134071050.650651.38270@o13g2000cwo.googlegroups.com... > Does this have to use VB.NET? The component I am using is written in > C#. I am trying to the code that I downloaded from your site: > AdventureWorks.Utils.ConnectionString. I am attempting to check the > querystring for a parameter (DB=name) to decide which connection string > to pull from the web.config file on the Report Server. Currently I > just have it where it should default to returning me the connection > string that I have declared as a constant, just to prove that it works > on the server. However, I am getting the following error when I deploy > the report and try to run it: > > An error has occurred during report processing. > Error during processing of the ConnectString expression of datasource > 'AdventureWorksPrivate'. > > I deployed the private assembly to the bin folder on the report server: > > C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting > Services\ReportServer\bin > > Am I missing something? Should I sign the assembly and deploy it to > the GAC? I can't understand why it finds it on the IDE, but not on the > server. > > Any help would be greatly appreciated. > > Thanks, > > Scott >
Thanks alot for your time, you've been a tremendous help.
Scott
Don't see what you're looking for? Try a search.
|
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |