Cannot set PasW field of crystal report table ???

serge calderara

Dear all

I am not able to set the PAssword field of a tables logInfo structure ???

I do it as follow :

For Each crTable In rptDoc.Database .Tables
crReportTabeLog info = crTable.LogOnIn fo
crReportTabeLog info.Connection Info = crConnectionInf o
crReportTabeLog info.Connection Info.Password = "admin"
crTable.ApplyLo gOnInfo(crRepor tTabeLoginfo)
Next

if I check afterwards the Passwor field, it is still empty and I ma even not
able to force it within the Watch window. IS it a readonly field ??

Thnaks for help
regards

Nov 7 '06 #1

Subscribe Reply

1144

serge calderara

I forgot to tell you that I am using the embeded crystal assemblies of VS2003
Report template have been made withinh crystal dev 7.0 developer edition
environement

"serge calderara" wrote:

Dear all

I am not able to set the PAssword field of a tables logInfo structure ???

I do it as follow :

For Each crTable In rptDoc.Database .Tables
crReportTabeLog info = crTable.LogOnIn fo
crReportTabeLog info.Connection Info = crConnectionInf o
crReportTabeLog info.Connection Info.Password = "admin"
crTable.ApplyLo gOnInfo(crRepor tTabeLoginfo)
Next

if I check afterwards the Passwor field, it is still empty and I ma even not
able to force it within the Watch window. IS it a readonly field ??

Thnaks for help
regards

Nov 7 '06 #2

Conbine Guard

U use visual studio 2003? why you use the DB tools
"serge calderara" <se************ @discussions.mi crosoft.comÐ´Èë ÏûÏ¢ÐÂÎÅ:C7**** *************** *************** @microsoft.com. ..

Dear all

I am not able to set the PAssword field of a tables logInfo structure ???

I do it as follow :

For Each crTable In rptDoc.Database .Tables
crReportTabeLog info = crTable.LogOnIn fo
crReportTabeLog info.Connection Info = crConnectionInf o
crReportTabeLog info.Connection Info.Password = "admin"
crTable.ApplyLo gOnInfo(crRepor tTabeLoginfo)
Next

if I check afterwards the Passwor field, it is still empty and I ma even
not
able to force it within the Watch window. IS it a readonly field ??

Thnaks for help
regards

Nov 8 '06 #3

serge calderara

What do you mean ?

"Conbine Guard" wrote:

U use visual studio 2003? why you use the DB tools
"serge calderara" <se************ @discussions.mi crosoft.comÃÂ´ ÃˆÃ«ÃÃ»ÃÂ¢ÃÃ ‚ÃŽÃ…:C7******* *************** ************@mi crosoft.com...
Dear all

I am not able to set the PAssword field of a tables logInfo structure ???

I do it as follow :

For Each crTable In rptDoc.Database .Tables
crReportTabeLog info = crTable.LogOnIn fo
crReportTabeLog info.Connection Info = crConnectionInf o
crReportTabeLog info.Connection Info.Password = "admin"
crTable.ApplyLo gOnInfo(crRepor tTabeLoginfo)
Next

if I check afterwards the Passwor field, it is still empty and I ma even
not
able to force it within the Watch window. IS it a readonly field ??

Thnaks for help
regards

Nov 8 '06 #4

serge calderara

Some more information,

I have seen that inside my report , there is an ODBC linked to the initial
SQL server databased by using SQL identfication mode.
Then when I run that report from my application, the login failed becasue
the initial sql identification credential has changed.

So what I am trying to do is to dynamically modifying the SQL credential in
order to be able to access properly when printing directly.

I have made the test with the Crystal viewer and I get prompt with the Login
Windows, the I noticed that wrong user and passwor is set, this comes from
initial report, by manually chage it to correct one works after words...

How to perform this through code

regards
serge

"Conbine Guard" wrote:

U use visual studio 2003? why you use the DB tools
"serge calderara" <se************ @discussions.mi crosoft.comÃÂ´ ÃˆÃ«ÃÃ»ÃÂ¢ÃÃ ‚ÃŽÃ…:C7******* *************** ************@mi crosoft.com...
Dear all

I am not able to set the PAssword field of a tables logInfo structure ???

I do it as follow :

For Each crTable In rptDoc.Database .Tables
crReportTabeLog info = crTable.LogOnIn fo
crReportTabeLog info.Connection Info = crConnectionInf o
crReportTabeLog info.Connection Info.Password = "admin"
crTable.ApplyLo gOnInfo(crRepor tTabeLoginfo)
Next

if I check afterwards the Passwor field, it is still empty and I ma even
not
able to force it within the Watch window. IS it a readonly field ??

Thnaks for help
regards

Nov 8 '06 #5

Similar topics

11060

Adding Field to Stored Procedure for Crystal Reports

by: Scott | last post by:

Hello: I have a stored procedure for generating our invoices in Crystal Reports. I have added a new field to the SP, but when I try to add the field to my Crystal Report invoice, the field isn't available in the list. However, if I create a new, blank report using the same stored procedure as the datasource, the field is available. I've seemingly tried every iteration of "Verify Database" to no avail. The obvious answer would be to...

Microsoft SQL Server

4031

HELP on Changing Crystal Report sql query at run time via vs.net.

by: Phin | last post by:

I need your HELP! I've seen all the posts on using Crystal Reports within vs.net (vb.net) and changing a SQL query at runtime. When I tried to pass in a dataset into the crystal report at runtime, the report still showed the results from the default query (from within the Crystal Report). Then I tried the XSD solution where you define a dataset (that mataches the database and the Crystal Report) and have the Crystal Report use this....

.NET Framework

11566

Cannot print using custom paper size (Crystal Report .NET)

by: Anniech | last post by:

I use VB.NET to integrate with crystal report 9.0 to print a report with custom paper size (using Dot Matrix printer). I have already added a custom paper size in the printer server and set the paper size in crystal report. However, 1. in web form, the crystal report viewer perview cannot identify the paper setting and use A4 instead. The print out is always with A4. 2. in win form, the crystal report viewer preview looks fine but...

Visual Basic .NET

1871

How to change database name for crystal report through VB.net

by: Ray | last post by:

Dear all, Now I am using the report document in vb.net to call the crystal report and I will set the database information in the report document. The code is as follow: ... ReportTemp.Load(_reportname) For Each table In ReportTemp.Database.Tables logoninfo = table.LogOnInfo With logoninfo.ConnectionInfo .ServerName = "Server"

Visual Basic .NET

2272

Crystal Report.Net DB Issue

by: Chris | last post by:

I have the following situation in a VB.Net App I am working on: 1.)A report created in VS.Net 2003 using the CR.Net component of VS 2003. 2.)The datasource for the report is a Stored Proc in a SQL Server DB (pull method). 3.)The Stored Proc has two input parameters of type date. 4.)The Stored Proc is a rather complex proc that was not written by me, but does work(see next item). It currently returns about 13K rows of data. 5.)The...

.NET Framework

3908

Cannot close connection of crystal report

by: bonita | last post by:

In my ASP.NET page, I have 2 checkboxes for users to choose which crystal report they want to display. These two reports use different tables. If report1 has been choosen and displayed in the crystal report, then I cannot check another checkbox to display report2 afterwards. If I close the website and open again, I can choose report2 and display as crystal report correct, but now I cannot check the checkbox1 to display report 1 afterwards....

ASP.NET

1988

Crystal Report cannot logon sql server!!??

by: abc | last post by:

Our web project is used VS2003 and Crystal Reports for Visual Studio.NET. There have reports that directly call to sql server's stored procedure. I also call SetDatabaseLogon method to change user id and password. But I found the crystal reports use ASPNET account to logon SQL Server, not my expected user id. Our SQL Server is MSDE and run on mixed authenitcation mode.

ASP.NET

7451

Crystal Reports Does Not Display BLOB Field Correctly in IBlobField Control Using Crystal Reports for VS.NET 2003

by: Jeff | last post by:

Help!!! The bitmap I am trying to display in a sample Crystal Report is coming up with much less quality than the original bitmap. I have a 300x300 dpi bitmap file that I want to insert at run time into a Crystal Report. The path to the file is stored in a varchar(100) field in a table in SQL Server. The Crystal Report displays the bitmap in the IBlobField object but it

.NET Framework

1578

data is nt seen in Cyrstal report in VB.net when there are twio or more table in DS..

by: arpan209 | last post by:

I am preparing a crystal report for library system... two tables.. 1)BookIssueDetail: fields : grno ,bookno,issuedat 2)studentMaster fileds: grno,stdename,(and lots more)..only these filed are req to display...

Visual Basic .NET

9568

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

9404

Changing the language in Windows 10

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,...

Windows Server

10008

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

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...

Online Marketing

9959

The easy way to turn off automatic updates for Windows 10/11

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,...

Windows Server

8833

AI Job Threat for Devs

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...

Career Advice

7381

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

5423

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

3929

transfer the data from one system to another through ip address

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

C# / C Sharp

3532

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP