Click to See Complete Forum and Search --> : How to open CrystalReport in another machine


Debsoft
April 9th, 2003, 05:34 AM
Hi Friends!

I'm developing an application in .NET where I need to open reports made in CrystalReports 8.5. The report opens up at my end properly.(I'm using the connection parameters of the SQL Server database at my end). Now, when I send this same report to my client, he is not able to open up the report and see it.

Is it because the connection parameters of the SQL Server database at my client's end are different. If so, how to tackle this problem since Clients will inevitably have different connection parameters. Also I need to know will the client be able to open up my reports even if he DOESN'T have CrystalReports 8.5 installed on his machine.

TIA,

Debsoft

Huzaifa
April 9th, 2003, 06:54 AM
hi

What kind of Error are you getting on the client side

if its something like this
Login failed then it is defintelty database login issue
have u tried something like this

public ReportDocument oRpt=new ReportDocument();

oRpt.Load(reportname);
CrystalReportViewer1.DataBind();
CrystalReportViewer1.ReportSource = oRpt;


CrystalDecisions.Shared.TableLogOnInfo crLogonInfo;
crLogonInfo = oRpt.Database.Tables[0].LogOnInfo;

crLogonInfo.ConnectionInfo.ServerName = servername;
crLogonInfo.ConnectionInfo.UserID =userid;
crLogonInfo.ConnectionInfo.Password =password;
crLogonInfo.ConnectionInfo.DatabaseName =databasename;

oRpt.Database.Tables[0].ApplyLogOnInfo(crLogonInfo);


huzaifa

Debsoft
April 11th, 2003, 06:44 AM
Hi huzaifa!!

I've already done that...actually I was facing the "Login Failed" problem before...so searched the net and found this solution.

But the problem is the reports are opening fine at my end but not at client's end...may be because of different database connection parameters...

Have u ever made a report in Crystal Report 8.5 and tried to run it elsewhere on a machine where the connection parameters for SQL Server are different than that on your machine ?????

thanks for your reply...if u hve any possible clue do let me know.

Regards,
Debsoft

Huzaifa
April 23rd, 2003, 04:30 AM
hi

Did u able to slove ur problem

please tell me exactly wat kind of error u are getting while accessing the report

Could be one of the issues
why don't you save the report in the latest version
The frame work at the client side is not properly installed (re installed it)
if u r packaging ur application u neet to add modules like Crystal_regwiz2003.msm

huzaifa