changing connection string from one sql server to another using vb .net

I have developed numerous reports in a vb .net app (Windows Database App)
that is
soon to go into production. When I built each report, CR connected to sql
server on my development platform. The connection string is different than
it will be at my client.
How can I change the connection string so that it recognizes my client's
server instead of mine for each of these reports? This is not technically a
sql server question, but I am hoping some of the sql developers who review
these posts will have run into the same issue,
Thanks for any help.
Bernie YaegerConnection String data is generally stored in a centralized location...
1) config File
2) Registry
3) INI
4) Global.ASAX
hope this helps
Greg J
PDX, Oregon

changing connection string from one sql server to another using vb .net

I have developed numerous reports in a vb .net app (Windows Database App)
that is
soon to go into production. When I built each report, CR connected to sql
server on my development platform. The connection string is different than
it will be at my client.
How can I change the connection string so that it recognizes my client's
server instead of mine for each of these reports? This is not technically a
sql server question, but I am hoping some of the sql developers who review
these posts will have run into the same issue,
Thanks for any help.
Bernie YaegerConnection String data is generally stored in a centralized location...
1) config File
2) Registry
3) INI
4) Global.ASAX
hope this helps
Greg J
PDX, Oregon

Changing Colors of Set of Rows based on Group / Matrices

Norman Yuan helpe me very much with changing colors on alternate rows, but
now I need help with a couple of other reports that use matrices.
Is there an ""on group change" event that I can test so that I can determine
when the group changes so that I can change the background color for all the
rows in that group?
Please let me know.
Thanks in advacne.I guess that you used ROWNUMBER(Nothing) now, simply use the
ROWNUMBER(Groupname) for putting the same logic in place for groups.
HTH, Jens K. Suessmeyer.
--
http://www.sqlserver2005.de
--

Changing an existing Crystal 8.0 report to use stored proc

Hello,
I have approximately 34 Crystal 8 reports that currently run off embedded sql statements. I need to change these to run off stored procedures, and am not sure how to convert them.

The returned columns are the same, although the queries have changed slightly.

If I attempt to directly change the SQL through "Show SQL Query" it doesn't take. I also tried "Set Location" which only replaces the table name with the sp name, and also fails.

If I build a new report from scratch, it works, but this is very time consuming and error prone.

Can someone tell me how to change the existing reports to use the sp's?

Thanks,
JamesShow SQL Query wont' allow u to change existing sql.

Report object has SQLQueryString String type. Gets or sets SQL query string. Read/Write Can be written only when formatting idle which according to crystal allows you to change sql at runtime. Maybe this would help. Change this to your procedure name systematically.

Thanks

Changes related to PDF in SQL Server 2005 Reporting Services

Hi All,

I am working on SQL Server 2005 reporting services. In reports I am required to make changes related to exporting report to PDF. Following are those changes:

1) Change PDF export page format to letter from legal

2) Fix page break to ensure that all details related to a specific issue are viewable on the same page

In reports exporting is done through the control given by services itself. So can any one please guide me regarding how this changes can be done. Please help me ASAP...

Thanks....

For (1), it seems like you should be able to just change the page size of the report. Or do you need to change the size just for PDF? If you are using URL access or SOAP, you can specify page sizes via device info settings. See http://msdn2.microsoft.com/en-us/library/ms154682.aspx

For (2), you will need to modify the RDL; try looking into the KeepTogether and RepeatWith settings on report items.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSRDL/htm/rsp_ref_rdl_elements_ae_4ak3.asp|||

With regard to page breaks I can see a KeepTogether property that refers to the whole report but not to individual groups. There is no RepeatWith setting within my rdl (SQL2005).

I would like my report to group on a particular field but don't want it to break before or after the report header / footer. Any idea how I can do this?

Changed machine name after SSRS installation

Hi,
I changed my machine name after installation of SSRS 2005. After the name
change, nothing seems working. To make the reports work, what and where do I
need to make the changes?
Whenever I starts reconfiguration, it says Invalid Namespace error.
Appreciate your help.
Thanks
AtulHave you checked whether the server is getting accessed from "Reporting
Services configuration" from configuration menu.
Amarnath
"Atul Shukla" wrote:
> Hi,
> I changed my machine name after installation of SSRS 2005. After the name
> change, nothing seems working. To make the reports work, what and where do I
> need to make the changes?
> Whenever I starts reconfiguration, it says Invalid Namespace error.
> Appreciate your help.
> Thanks
> Atul
>
>|||If nothing is so imp in your server then reinstall it. One more thing just try
typing http://localhost/reports this is the check recommended by MS to see
whether RS installed properly if you dont get the home page then it is not
installed properly.
Amarnath
"Atul Shukla" wrote:
> No. Whenever I try to access the reporting service configuration, I get the
> error (file attached).
> It seems that I need to re-install SQL Server.
>
> "Amarnath" <Amarnath@.discussions.microsoft.com> wrote in message
> news:D6758B6E-17D1-4336-85F0-CF76470D6873@.microsoft.com...
> > Have you checked whether the server is getting accessed from "Reporting
> > Services configuration" from configuration menu.
> >
> > Amarnath
> >
> > "Atul Shukla" wrote:
> >
> >> Hi,
> >>
> >> I changed my machine name after installation of SSRS 2005. After the name
> >> change, nothing seems working. To make the reports work, what and where
> >> do I
> >> need to make the changes?
> >> Whenever I starts reconfiguration, it says Invalid Namespace error.
> >>
> >> Appreciate your help.
> >> Thanks
> >> Atul
> >>
> >>
> >>
>
>

Change the Shared Data Source when deploying

I am trying to move my reports (and data sources) from one server to another.
I can move everything fine, but when I go to execute a report, it says
invalid data source, even though the data source exists with the same name as
it did on the original server. I can manually go through each report and
point them to the data source and it works fine, but I need to get this
working with little or no intervention.
--
JasonMake sure you create the shared datasource first before deploying any
reports that reference it, it should get picked up fine then.
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"JasonDWilson" <JasonDWilson@.discussions.microsoft.com> wrote in message
news:8005DE7C-15C1-4AAC-82C4-83F1C3FFDB75@.microsoft.com...
>I am trying to move my reports (and data sources) from one server to
>another.
> I can move everything fine, but when I go to execute a report, it says
> invalid data source, even though the data source exists with the same name
> as
> it did on the original server. I can manually go through each report and
> point them to the data source and it works fine, but I need to get this
> working with little or no intervention.
> --
> Jason

Change sql agent login user

In keeping with the microsoft suggestion, I changed the
mssql agent login to a user. Now My application does not
run, the error log reports the following
RegOpenKeyEx of "SOFTWARE\Microsoft\MSSQLServer\" failed:
Result Code = 0x00000005
I have tried adding users, and domain users. it only works
if I add the administrators from the built in group.
Please help!Hi!
Do please check if the article at
http://support.microsoft.com/defaul...kb;en-us;283811 is helpful
for you.
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"shivi" <infor@.villageideas.com> wrote in message
news:c2b901c3ed05$20714760$a501280a@.phx.gbl...
> In keeping with the microsoft suggestion, I changed the
> mssql agent login to a user. Now My application does not
> run, the error log reports the following
> RegOpenKeyEx of "SOFTWARE\Microsoft\MSSQLServer\" failed:
> Result Code = 0x00000005
> I have tried adding users, and domain users. it only works
> if I add the administrators from the built in group.
> Please help!

change sender for subscription.

I need change the sender for the reports under certain folder.
I guess that I need to change RSreportServer.config.
However it made effects on all reports subscripted.
the problem is that I need to change some reports under certatin folder.
is there someone could answer this question?
thanks.This is not supported through the config file. The SendEmailToUserAlias
property will enable all users to set the sender. What you can do is grant
users, that need to change the sender, the 'Manage All subscriptions'
permission. This will allow them to set the sender. It will also allow
them to create Data Driven subscriptions and to modify other users
subscriptions so it might do more then you want.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"ken lee" <klee@.monetagroup.com> wrote in message
news:O1ploUkBGHA.312@.TK2MSFTNGP09.phx.gbl...
>I need change the sender for the reports under certain folder.
> I guess that I need to change RSreportServer.config.
> However it made effects on all reports subscripted.
> the problem is that I need to change some reports under certatin folder.
> is there someone could answer this question?
> thanks.
>

Change reporting services default URL (From http://server/reports to http://CompanyReports)

I looked online and couldn't find anything to help me make this change. I want to change the default URL for reporting services to another url. Is this possible? Any assistance would be greatly appreciated.

I wouldn't try to change the reporting services default URL.

Instead, I would create an alias or....

Name the server that hosts reporting services "CompanyReports". Then set report manager on that server to be the default website. Then when you navigate to http://CompanyReports from any PC on your network, you will see the report manager on that server.

Change Report Datasource

I have a c# assembly that uses the reporting services webservice to render reports.

Every user accessing this component needs to render this report passing different datasource to it in order to browse data in different databases (es.: test databse server, production database server)

Is it possible to create a linked report and change the connection only to it?

Other suggestions?

Thanks

Hi,

you can change the connection string property depending on the user (role or something you want to differentiate with). I don′t know if that is actually a solution for your problem but this is worth a try. using an expression could be something like

="Data Source=" & IIF(SomeExpression,"TestServer","ProductionServer") (...Rest of the connection string here...)

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

Yes, it works great with reporting services 2005, but i forgot to tell you that i have to do the same with reporting services 2000...that's the problem. Is it possible under 2000 to do the same thing? If "No", are there other ways to programmatically call a report with dinamyc conection string.

The only solution i've found is as follows:

==========

rs.render --> obtain the byte stream from REPORT_1

rs.CreateReport --> create REPORT_2 using the stream of REPORT_1

rs.GetReportDataSources(REPORT_2) --> to obtain datasource of REPORT_2

Modify the property ".connectString" of this DataSourceDefinition

rs.render to render the newly created report

finally delete the new report.

===================

In this solution, copying the report slows down execution time i suppose...... Another solution might be to directly modify datasourcedefinition of REPORT_1 but if two or more users try to call the same report with different connectionstrings i think there might be problems.

Any suggestions?

|||This is something I would like to do. Where exactly would I enter that expression? In VS Report Designer, when I create a new Data Source, the "fx" button is grayed out. Is that where I should be entering this expression? Is there a reason why the builder is disabled?

Thanks,|||

With Reporting Services 2005, open the report in the solution and switch from design to code view (xml structure) and modify connectstring node as follows:

<ConnectString>="data source=" &amp; Parameters!ServerName.Value &amp; ";initial catalog=Northwind;"</ConnectString>

You also have to create the parameter "ServerName".

If you want, change also the Catalog Name using another parameter...

With reporting services 2000 you cannot do the same...try reading my code example reading abow...that works fine for me

Change quality rendering to PDF

PDF - rendering of reports that contain images, makes very large pdf-files.
Is there any option that I can set the export quality of the images?
I have seen in this forum that there have been many questions about
rendering images, but very few good answers ... can anyone tell me if there
are any solution to my problem ? .... changes in SP2?What is your source for images? There are lots of good tools out there for
reducing the size of images. For example, if your images are stored in a
file system, IrfanView is an easy tool to use, and it has good compression
as well.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"TiJei" <TiJei@.discussions.microsoft.com> wrote in message
news:7BAA23AF-4337-4145-B957-06E80ABBB79B@.microsoft.com...
> PDF - rendering of reports that contain images, makes very large
> pdf-files.
> Is there any option that I can set the export quality of the images?
> I have seen in this forum that there have been many questions about
> rendering images, but very few good answers ... can anyone tell me if
> there
> are any solution to my problem ? .... changes in SP2?|||Thank you for your answer Jeff,
I know there is a lot of tools for resizing images, but why should the
pdf-rendering "enlarge" my images?
If i use a jpeg as source, with the size about 300kb and 96*96 dpi, I got a
export file at about 2,3 MB.
When rendering to pdf, I want to have the possibility to declare the
properties for the image, today the size of the exported file indicates that
the quality always are high?
"Jeff A. Stucker" wrote:
> What is your source for images? There are lots of good tools out there for
> reducing the size of images. For example, if your images are stored in a
> file system, IrfanView is an easy tool to use, and it has good compression
> as well.
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "TiJei" <TiJei@.discussions.microsoft.com> wrote in message
> news:7BAA23AF-4337-4145-B957-06E80ABBB79B@.microsoft.com...
> > PDF - rendering of reports that contain images, makes very large
> > pdf-files.
> > Is there any option that I can set the export quality of the images?
> >
> > I have seen in this forum that there have been many questions about
> > rendering images, but very few good answers ... can anyone tell me if
> > there
> > are any solution to my problem ? .... changes in SP2?
>
>

Change Print Defaults

I have noticed that all the reports I create in VS 2000 for RS 2000 all have the default print set to potrait with 1" margins. I was wondering if there was a way to make the default different for different reports. Some I only want a .5" and some and I want to print landscape and still other I need both. Does anyone know how to go about this? Thanks

You can set the print settings for every report individually. In VS 2003 got to the Report Menu and choose Report Properties. Go to the layout tab and adjust the width, height and margins as per your printing requirements. Note there is no specific Portrait/Landscape option here, you control it using width and the height.

One technique that I use when I start a new project is I set up 2 blank report templates (portrait and landscape) with the necessary branding, logo and print settings already set up. Then when I create a new report I just copy paste the relevant template.

The layout settigns are also applied when exporting to PDF.

|||That worked great thanks

Change Look & Feel

Is there a way to change the look and feel of the reports in the bit where
the parameters selection is? And what about the top section?
Im thinking of changing background etc.
JonasChanging the style of HTML Viewer toolbar is not possible in the initial
release but it can be done in SP1. Details are in SP1 readme:
http://download.microsoft.com/download/7/f/b/7fb1a251-13ad-404c-a034-10d79ddaa510/SP1Readme_EN.htm
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jonas Larsen" <Jonas.Larsen@.Alcan.com> wrote in message
news:%23S6IjXmWEHA.2844@.TK2MSFTNGP12.phx.gbl...
> Is there a way to change the look and feel of the reports in the bit where
> the parameters selection is? And what about the top section?
> Im thinking of changing background etc.
> Jonas
>