Crystal Reports Problem: Please reply ASAP -- dotnet performance

dotnet performance : Crystal Reports Problem: Please reply ASAP

Mithun Verma
1/23/2004 9:20:26 AM

Hello All,
I have a Windows application that uses Crystal Reports 9 (bundled Version)
developed using VS.NET 2003 on a windows server 2003 m/c.
The application has to be deployed on the client machine that has Windows
XP installed. Before deploying we make sure that .NET framework 1.1 is
installed on the XP machine. In the setup project, for support for Crystal
Reports, we have added the following merge modules:
1)Crystal_Managed2003.msm
2) Crystal_Database_Access2003.msm
3)Crystal_Database_Access2003_enu.msm
4)Crystal_RegWiz2003.msm
5)VC_User_CRT71_RTL_X86.msm
6)VC_User_STL71_RTL_X86.msm

The problem we are facing is like this: Whenever the user tries to pull up
the reports, a database logon screen pops up for the report. I am unable to
figure out as to why this is happening only for Crystal Reports. All the
other functionality in the application is working fine without having to
specify the database connection information interactively. The database
server is not in the same network as this Client WinXP machine. We specify
the IP address of the DB server in the DB connection string. Could this be a
problem?
If someone has faced this problem earlier or has any solution to this
problem, do let me know. I need to resolve this problem ASAP.

Thanks in advance
Mithun

Nauzad Kapadia
1/25/2004 8:14:27 AM

hi,

This is not a problem, but indeed the way crystal report works.

When you create a crystal report that connects to a database, it does not
persist the password in the report itself. Therefore everytime u run the
report and the report tries to fetch the data from the database and in the
process asks you for the password.

The work around for this is to supply the password and any other database
connection parameters to crystal reports at runtime, just before you show
the report. Refer to the following code-snippet

Dim cr As New CrystalReport1()

Dim crConnInfo As New ConnectionInfo()

Dim tInfo As New TableLogOnInfo

crConnInfo.DatabaseName = "pubs"

crConnInfo.UserID = "sa"

crConnInfo.Password = "sa"

tInfo.ConnectionInfo = crConnInfo

cr.Database.Tables(0).ApplyLogOnInfo(tInfo)

Make sure to repeat the last line for every table u use in the report or
loop thru tables.count property.

Regards,

Nauzad Kapadia [MVP]

[quoted text, click to view]

Jurgen
1/26/2004 2:16:06 AM

You should install the latest service packs and hot fix from the CrystalDecisions
particularly to the version that you use

Create the installation project correctly

Check your CrystalViewer object pointing to the right version

Uninstall the program in the destination PC and the
reinstall with the new project with the latest servicepacks/hot fix of the Crystal Report

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about dotnet performance

View Other Months
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
December 2007
January 2008
February 2008
March 2008
April 2008
May 2008
June 2008

home · blog · groups

Questions? Comments? Contact the dn