ExamGuru IT/.Net Guru : Crystal Format on ASPFriends.com 'ngfx-crystal' list

.NETGURU

Crystal Format

Messages

Related Types

This message was discovered on ASPFriends.com 'ngfx-crystal' list.
Responses highlighted in red are from those people who are likely to be able to contribute good, authoratitive information to this discussion. They include Microsoft employees, MVP's and others who IMHO contribute well to these kinds of discussions.

Vasan.S

Hi All,
Iam facing a small problem while using crystal reports. I am using
CrystalReportViewer for generating report from a .rpt file.

In this while the page is loading a prompt window is coming and asking
us to enter the password. I used the foll code in body onload

Dim tbCurrent As CrystalDecisions.CrystalReports.Engine.Table

Dim tliCurrent As CrystalDecisions.Shared.TableLogOnInfo

For Each tbCurrent In cbsMain.Database.Tables

tliCurrent = tbCurrent.LogOnInfo

With tliCurrent.ConnectionInfo

.ServerName = "dotnet"

.UserID = "sa"

.Password = "dotnet"

.DatabaseName = "dbname"

End With

tbCurrent.ApplyLogOnInfo(tliCurrent)

Next tbCurrent

but still the prompt window is coming. can u pls explain me how to solve the
problem.

waiting for reply

VasanS

Reply to this message...

Eric Landes (VIP)

Vasan,
I don't see any code binding cbsmain (which I am assuming is the report
document) to your viewer. Is that there?
=20
Eric

-----Original Message-----
From: Vasan.S [mailto:Click here to reveal e-mail address]
Sent: Wednesday, July 24, 2002 8:55 AM
To: ngfx-crystal
Subject: [ngfx-crystal] Crystal Format

Hi All,
Iam facing a small problem while using crystal reports. I am using
CrystalReportViewer for generating report from a .rpt file.

In this while the page is loading a prompt window is coming and asking
us to enter the password. I used the foll code in body onload

Dim tbCurrent As CrystalDecisions.CrystalReports.Engine.Table

Dim tliCurrent As CrystalDecisions.Shared.TableLogOnInfo

For Each tbCurrent In cbsMain.Database.Tables

tliCurrent =3D tbCurrent.LogOnInfo

With tliCurrent.ConnectionInfo

.ServerName =3D "dotnet"

.UserID =3D "sa"

.Password =3D "dotnet"

.DatabaseName =3D "dbname"

End With

tbCurrent.ApplyLogOnInfo(tliCurrent)

Next tbCurrent

but still the prompt window is coming. can u pls explain me how to solve the
problem.

waiting for reply

VasanS

| [ngfx-crystal] member Click here to reveal e-mail address =3D YOUR ID |
http://www.aspfriends.com/aspfriends/ngfx-crystal.asp =3D JOIN/QUIT=20

Confidentiality Notice: This e-mail message, including any
attachments, is for the sole use of the intended recipient(s) and may
contain confidential and privileged information. Any unauthorized
review, use, disclosure or distribution is prohibited. If you are not
the intended recipient, please contact the sender by reply e-mail and
destroy all copies of the original message.

PARTNERS Health Plan Phone: 574-233-4899
100 E. Wayne St., Suite 502 Fax: 574-234-7484
South Bend, IN 46601 www.partnersindiana.com

Confidentiality Notice: This e-mail message, including any
attachments, is for the sole use of the intended recipient(s) and may
contain confidential and privileged information. Any unauthorized
review, use, disclosure or distribution is prohibited. If you are not
the intended recipient, please contact the sender by reply e-mail and
destroy all copies of the original message.

PARTNERS Health Plan Phone: 574-233-4899
100 E. Wayne St., Suite 502 Fax: 574-234-7484
South Bend, IN 46601 www.partnersindiana.com

Confidentiality Notice: This e-mail message, including any
attachments, is for the sole use of the intended recipient(s) and may
contain confidential and privileged information. Any unauthorized
review, use, disclosure or distribution is prohibited. If you are not
the intended recipient, please contact the sender by reply e-mail and
destroy all copies of the original message.

PARTNERS Health Plan Phone: 574-233-4899
100 E. Wayne St., Suite 502 Fax: 574-234-7484
South Bend, IN 46601 www.partnersindiana.com

Confidentiality Notice: This e-mail message, including any
attachments, is for the sole use of the intended recipient(s) and may
contain confidential and privileged information. Any unauthorized
review, use, disclosure or distribution is prohibited. If you are not
the intended recipient, please contact the sender by reply e-mail and
destroy all copies of the original message.

PARTNERS Health Plan Phone: 574-233-4899
100 E. Wayne St., Suite 502 Fax: 574-234-7484
South Bend, IN 46601 www.partnersindiana.com

------_=_NextPart_001_01C233D5.4B430810

Reply to this message...

Vasan.S

Eric

I will copy the entire code to u....fine find where iam wrong...

Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

Dim tbCurrent As CrystalDecisions.CrystalReports.Engine.Table

Dim tliCurrent As CrystalDecisions.Shared.TableLogOnInfo

For Each tbCurrent In cbsMain.Database.Tables

tliCurrent = tbCurrent.LogOnInfo

With tliCurrent.ConnectionInfo

.ServerName = "dotnet"

.UserID = "sa"

.Password = "dotnet"

.DatabaseName = "freds"

End With

tbCurrent.ApplyLogOnInfo(tliCurrent)

Next tbCurrent

Dim pvCustPattern As New CrystalDecisions.Shared.ParameterValues()

Dim pdvCustPattern As New _

CrystalDecisions.Shared.ParameterDiscreteValue()

pdvCustPattern.Value = Trim(txtState.Text)

pvCustPattern.Add(pdvCustPattern)

cbsMain.DataDefinition.ParameterFields("@state").ApplyCurrentValues(pvCustPattern)

cvwMain.ReportSource = cbsMain

End Sub

this is the code iam using in onload event. When iam executing the code it first ask for a parameter window, and when i set this then login window comes asking us to enter password. when i enter all the details it works fine.....but how to pass parameters to it inorder to supress the window.

VasanS

----- Original Message -----
From: Eric Landes
To: ngfx-crystal
Sent: Thursday, July 25, 2002 5:47 PM
Subject: [ngfx-crystal] RE: Crystal Format

Vasan,
I don't see any code binding cbsmain (which I am assuming is the report document) to your viewer. Is that there?

Eric
-----Original Message-----
From: Vasan.S [mailto:Click here to reveal e-mail address]
Sent: Wednesday, July 24, 2002 8:55 AM
To: ngfx-crystal
Subject: [ngfx-crystal] Crystal Format

Hi All,
Iam facing a small problem while using crystal reports. I am using
CrystalReportViewer for generating report from a .rpt file.

In this while the page is loading a prompt window is coming and asking
us to enter the password. I used the foll code in body onload

Dim tbCurrent As CrystalDecisions.CrystalReports.Engine.Table

Dim tliCurrent As CrystalDecisions.Shared.TableLogOnInfo

For Each tbCurrent In cbsMain.Database.Tables

tliCurrent = tbCurrent.LogOnInfo

With tliCurrent.ConnectionInfo

.ServerName = "dotnet"

.UserID = "sa"

.Password = "dotnet"

.DatabaseName = "dbname"

End With

tbCurrent.ApplyLogOnInfo(tliCurrent)

Next tbCurrent

but still the prompt window is coming. can u pls explain me how to solve the
problem.

waiting for reply

VasanS

| [ngfx-crystal] member Click here to reveal e-mail address = YOUR ID | http://www.aspfriends.com/aspfriends/ngfx-crystal.asp = JOIN/QUIT
| [ngfx-crystal] member Click here to reveal e-mail address = YOUR ID | http://www.aspfriends.com/aspfriends/ngfx-crystal.asp = JOIN/QUIT

Reply to this message...

	System.EventArgs
	System.Object

ExamGuru IT Solutions - .Net Guru is owned and operated by ExamGuru, Inc., the man behind .Net Guru. If you're in the market for bespoke software or software consultancy, why not get him and his highly trained team to help? - www.examguru.net/ITCertification

Need Dot Net Interview Questions?
Ask ExamGuru, Inc. for advice and help on Passing .Net Interviews

.Net Projects
Best-of-breed application framework for .NET projects, developed by ExamGuru, Inc. and ExamGuru IT

Free .net Help
Commission ExamGuru, Inc. and his team for your next bespoke software project

FogBUGZ
The only bug tracking system carefully crafted with one goal in mind: helping teams create great software.

Awesome Tools
If you don't know about these, you're missing out... IT Certification Questions
IT Interview Questions
Free Oracle 10g Training
MCSE Boortcamp
Cisco Study Guides
Cheap Study Guides
Exact Questions
Dot Net Interview Questions
Oracle OCP
Cheap Travel
Designer Perfumes - Wholesale Prices
Free Programming Tutorials

	Copyright © ExamGuru, Inc. 2001-2006
	Contact Us - Terms of Use - Privacy Policy - www.dot-net-guru.com - www.examguru.net - www.oraclesource.net - www.itinterviews.net - www.examguru.net/ITCertification