Solved

crystal 10 report, need to run in different server and database

Posted on 2006-07-19
8
288 Views
Last Modified: 2008-02-01
I have vb code to a crystal report 10, it works fine, if I have the report run in the same SQL server and database. However, if I run the report in different sql server and database, it will show up the Server1.DB1.procedure doesn't exist.

I need a way that I can dynamically change the servername and databasename when run the report, so the report can be run in different combination as long as the table/view/procedure exists.

Please help!
0
Comment
Question by:Skaugen
  • 3
  • 3
  • 2
8 Comments
 
LVL 17

Expert Comment

by:MIKE
ID: 17143309
Skaugen:

I"m not sure I'm understanding your question...but I'll take a shot at it.....

Do you have MS Data Transformation Services? If so, copy the database TABLE(s) that ther report needs over to the other SQL Server. Why do you need to change the datasource SERVER?

MikeV
0
 

Author Comment

by:Skaugen
ID: 17146182
Thanks for you feedback.

For example,
First I need the report run in Server1 and Database1, and then user may switch to run the same report in Server2 and Database2.

The Table structure in Server1/Database1 and Server2/Database2 are the same. However the data might be different.

I need the report can run in both, but in Crystal 10, the table location is like Server1.Database1.table, when I run the report in Server2.Database2, it will prompt up the error message saying "Server1.Database1.table is not exist...", which make sense since the report is trying to run in Server2.Database2.

So I need a solution for this, In crystal 8.5, what i did is to remove Server1.database1. from the datasource, but in Crystal 10, I have no way to do that. I was trying to find a way that if I can dynamically change it in my VB6 code.

Please suggest!

Skaugen
0
 
LVL 17

Expert Comment

by:MIKE
ID: 17146304
Copy the report and change the datasource....assign it to separate DB's and be done with it.
So that you will have 2 separate reports on for each datasource...named as such.

MikeV
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 

Author Comment

by:Skaugen
ID: 17146480
The problem is I have a lot of reports and don't want to keep two copies of all and also, I would like to have the flexibilty to do this, so the report will not restrict to server/database name as long as the table/view/proc structure is the same.

0
 
LVL 17

Assisted Solution

by:MIKE
MIKE earned 250 total points
ID: 17146555
0
 

Author Comment

by:Skaugen
ID: 17146709
I would like to use the trusted connection, instead of using myTable.SetLogOnInfo "Server", "Database", "User", "Password"
since different SQL server's username and password may vary, control from admin server is a lot of easy.

Any idea?
0
 
LVL 100

Accepted Solution

by:
mlmcc earned 250 total points
ID: 17160850
I believe if you set the report to use a trusted connection then set the logoninfo with just the server and database the current user will be used

mlmcc
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 17176567
Glad i could help

mlmcc
0

Featured Post

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Conditional Text in Crystal 4 54
Crystal reports vb.net 2 52
shared number array to be used in subreport 8 31
Crystal Reports - Record selection filter - formula editor 3 16
Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

790 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question