473,850 Members | 2,036 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Substitute DSN with data source authenication at runtime to view/access Crystal reports

I created several CR reports (in r8.5 and r10) using a system DSN named
"CrystalUse r" with username and login ID and use them in my VB.NET app. In
order for my clients to run the
report, the same DSN must be created in their machine. I would like to know
if I can substitute the DSN at runtime with info provided by the VB.NET
application instead.

Your help is greatly appreciated.

Bill

Nov 21 '05 #1
4 1465
http://www.vbcity.com/forums/topic.asp?tid=99737
"Bill Nguyen" <bi************ *****@jaco.com> wrote in message
news:%2******** ********@TK2MSF TNGP09.phx.gbl. ..
I created several CR reports (in r8.5 and r10) using a system DSN named
"CrystalUse r" with username and login ID and use them in my VB.NET app.
In order for my clients to run the
report, the same DSN must be created in their machine. I would like to
know
if I can substitute the DSN at runtime with info provided by the VB.NET
application instead.

Your help is greatly appreciated.

Bill

Nov 21 '05 #2
On Sat, 7 May 2005 20:07:33 -0700, "Bill Nguyen"
<bi************ *****@jaco.com> wrote:
I created several CR reports (in r8.5 and r10) using a system DSN named
"CrystalUser " with username and login ID and use them in my VB.NET app. In
order for my clients to run the
report, the same DSN must be created in their machine. I would like to know
if I can substitute the DSN at runtime with info provided by the VB.NET
application instead.

Your help is greatly appreciated.

Bill
I got this code from Crystal

Dim objTab As CrystalDecision s.CrystalReport s.Engine.Table
Dim objLogInf As CrystalDecision s.Shared.TableL ogOnInfo
For Each objTab In cr.Database.Tab les
objLogInf = objTab.LogOnInf o
objLogInf.Conne ctionInfo.Serve rName = "Server"
objLogInf.Conne ctionInfo.Passw ord = "password"
objLogInf.Conne ctionInfo.UserI D = "user"
objTab.ApplyLog OnInfo(objLogIn f)
Next

Doug Taylor


Nov 21 '05 #3
Doug;
I added this to my routine (using Reportdocument control) and it's not
working. It seemed to me that the table login was ingnored, the app still
looking for DSN info.
How did you get it work in your app?
THanks
Bill

"Doug Taylor" <Do************ @tayNOSPAMmade. demon.co.uk> wrote in message
news:oo******** *************** *********@4ax.c om...
On Sat, 7 May 2005 20:07:33 -0700, "Bill Nguyen"
<bi************ *****@jaco.com> wrote:
I created several CR reports (in r8.5 and r10) using a system DSN named
"CrystalUse r" with username and login ID and use them in my VB.NET app.
In
order for my clients to run the
report, the same DSN must be created in their machine. I would like to
know
if I can substitute the DSN at runtime with info provided by the VB.NET
application instead.

Your help is greatly appreciated.

Bill


I got this code from Crystal

Dim objTab As CrystalDecision s.CrystalReport s.Engine.Table
Dim objLogInf As CrystalDecision s.Shared.TableL ogOnInfo
For Each objTab In cr.Database.Tab les
objLogInf = objTab.LogOnInf o
objLogInf.Conne ctionInfo.Serve rName = "Server"
objLogInf.Conne ctionInfo.Passw ord = "password"
objLogInf.Conne ctionInfo.UserI D = "user"
objTab.ApplyLog OnInfo(objLogIn f)
Next

Doug Taylor

Nov 21 '05 #4
Mad;
This looks like something good for creating DSN in client machines. I'll
work on it and get back to you.
Thanks for your help.
Bill

"Mad Murdoch" <ma*@here.net > wrote in message
news:um******** ******@TK2MSFTN GP09.phx.gbl...
http://www.vbcity.com/forums/topic.asp?tid=99737
"Bill Nguyen" <bi************ *****@jaco.com> wrote in message
news:%2******** ********@TK2MSF TNGP09.phx.gbl. ..
I created several CR reports (in r8.5 and r10) using a system DSN named
"CrystalUse r" with username and login ID and use them in my VB.NET app.
In order for my clients to run the
report, the same DSN must be created in their machine. I would like to
know
if I can substitute the DSN at runtime with info provided by the VB.NET
application instead.

Your help is greatly appreciated.

Bill


Nov 21 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
1654
by: Slonjo | last post by:
I don't know if this has been addressed in some other form/forum but we tried what we thought was everything. I apologize if i'm being redundant. We build reports like so when they require passing parameters to limit the results: One person develops the report layout using a view. The other person creates a datatable at runtime from a stored proc
5
2129
by: Paul Scotchford | last post by:
Hi all, Thanks in advance to any contributions to my question. Im running SQLServer 2000 in a Win 2000 Server env. Background: ========== The database has many views that range from simple to complex joins on tables.
1
1408
by: Bob | last post by:
Hello Do I need the Crystal Reports Runtime installed on the client browser machine to be able to view a report on an asp.net page? We want to generate some reports for our clients to view over an aspx page but don't want them to have to have the runtime on their machines Thanks! Bob
0
1875
by: Sridhar | last post by:
Hi, I have a Crystal Report which has two sub reports in it. When I try to view this Crystal Report in my local computer, it is showing data for sub reports also. But when I deploy it to the web server and view the Crystal Report I am not able to view the data of sub reports. It is not giving any error. It is not showing the data. I checked the dlls of Crystal Report. Both the local host and server has same versions. I am not knowing...
12
2538
by: Tony Ciconte | last post by:
We are evaluating the prospect of integrating and/or using Crystal Reports with some of our current products. Some of these are still in Access 97 and are running well. Since we cannot include the report wizard in a runtime environment, we are looking at ad hoc report writers like Crystal. Can we include Crystal with our runtimes and/or is there another report writer that we should be looking at? Any and all help is greatly appreciated.
3
3052
by: Tyranno.Lex | last post by:
I am using Visual Studio .NET 2003 and have successfully deployed a commercial web application written in C# and ASP.NET. I am now wanting to add reporting using Crystal Reports and am having a devil of a time doing this. The problem is that my application uses an encapsulated data tier for accessing the database vs. accessing it directly via the client tier. However, EVERY example that I have ever seen for creating a Crystal Report at...
1
1355
by: candela | last post by:
Hello, I need your help and I am gonna explain my program so you have an idea of my program work. I am writing a program that will print an invoice and I am using VC# 2005 and crystal reports to do that. I use one Access database with 4 different tables which I connect to manually within the code and I mean I didn't add a dataSet to the application, I defined an OleDbConnection, OleDbCommand, OleDbAdapter and DataSet everytime I...
2
5358
by: Priyavenkat | last post by:
i am using VB 6.0, MS Access as backend and Crystal Reports 10 for reports. I connect data source to Crystal Reports 10 using ODBC dsn. It works correctly in my PC. When it is distributed to another PC, where the db path is different from my PC; reports is not working. How can I set the data source location through coding? I am using the following code, but it shows the error "script out of range". Dim CrxApp As New CRAXDRT.Application...
8
3094
by: Brock | last post by:
I am trying to populate a Crystal Report from data in my DataGrid. The reason for this is that I want the user to be able to change values without updating the database, but still have their report reflect the values they anticipate committing to see hypothetical totals of columns from a set of records. These records are displaying properly on my DataGrid but I'm not sure how to get Crystal Reports 10 to use as its datasource the dataset...
0
9744
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
11011
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10670
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
10725
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
10352
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
9503
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
5931
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4547
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
3
3178
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.