Advertisement

02.25.2008 at 05:41PM PST, ID: 23192314
[x]
Attachment Details

Crystal Reports on the Web

Asked by ROTRTechTeam in Business Objects, Crystal Reports Software

Tags: Crystal Reports, Crystal Reports, 11, web, C#

We have a web application that needs to use Crystal Reports.  During QA testing we have discovered that if the user does not have Crystal Reports on their computer, the report displays, but none of the buttons (export, print, move to next page, etc.) work.  I have attached a code snippet.  What do we need to do to get this to work properly?Start Free Trial 
1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:
46:
47:
48:
49:
50:
51:
52:
53:
54:
55:
56:
57:
58:
59:
60:
61:
62:
63:
64:
65:
66:
67:
68:
69:
70:
71:
72:
73:
74:
75:
76:
77:
78:
79:
80:
81:
82:
83:
84:
85:
86:
87:
88:
89:
90:
91:
92:
93:
94:
95:
96:
97:
98:
99:
100:
101:
102:
103:
104:
105:
106:
107:
108:
109:

private void PullReport()
{
try
{
if (!CheckFields())
{
return;
}
clsUtilities objUtil = new clsUtilities();
clsReports objRptCon = new clsReports();
objRptCon.GetReportConnectionInfo();
if (ReportName == "RewardShipped")
{
ReportName += "_" + this.ddViewBy.SelectedItem.Text;
}
else if (ReportName == "InventoryReceipt")
{
ReportName += "_" + this.ddSortBy.SelectedItem.Value;
}
ReportDocument rpt = new ReportDocument();
string physicalpath = Request.ServerVariables["APPL_PHYSICAL_PATH"].ToString();
rpt.Load(physicalpath + "reports\\" + ReportName + ".rpt");
//set log on info
TableLogOnInfo log = new TableLogOnInfo();
log.ConnectionInfo.DatabaseName = objRptCon.Database;
log.ConnectionInfo.Password = objRptCon.Password;
log.ConnectionInfo.ServerName = objRptCon.Server;
log.ConnectionInfo.UserID = objRptCon.UserName;
CrystalDecisions.CrystalReports.Engine.Table rptTable = rpt.Database.Tables[0];
rptTable.ApplyLogOnInfo(log);
this.CrystalReportViewer1.ReportSource = rpt;
//add parameters
ParameterField field1 = new ParameterField();
ParameterField field2 = new ParameterField();
ParameterField field3 = new ParameterField();
ParameterDiscreteValue parDisvalue1 = new ParameterDiscreteValue();
ParameterDiscreteValue parDisvalue2 = new ParameterDiscreteValue();
ParameterDiscreteValue parDisvalue3 = new ParameterDiscreteValue();
switch (ReportName)
{
case "InventoryBalance":
field1 = this.CrystalReportViewer1.ParameterFieldInfo[0]; 
parDisvalue1.Value = Convert.ToDateTime(this.txtAsOfDate.Text.Trim());
field1.CurrentValues.Add(parDisvalue1);
break;
case "InventoryReceipt_Date":
field1 = this.CrystalReportViewer1.ParameterFieldInfo[0]; 
parDisvalue1.Value = Convert.ToDateTime(this.txtDateFrom.Text.Trim());
field1.CurrentValues.Add(parDisvalue1);
field2 = this.CrystalReportViewer1.ParameterFieldInfo[1]; 
parDisvalue2.Value = Convert.ToDateTime(this.txtDateTo.Text.Trim());
field2.CurrentValues.Add(parDisvalue2);
break;
case "InventoryReceipt_Item":
field1 = this.CrystalReportViewer1.ParameterFieldInfo[0]; 
parDisvalue1.Value = Convert.ToDateTime(this.txtDateFrom.Text.Trim());
field1.CurrentValues.Add(parDisvalue1);
field2 = this.CrystalReportViewer1.ParameterFieldInfo[1]; 
parDisvalue2.Value = Convert.ToDateTime(this.txtDateTo.Text.Trim());
field2.CurrentValues.Add(parDisvalue2);
break;
case "InventoryReceipt_RefNo":
field1 = this.CrystalReportViewer1.ParameterFieldInfo[0]; 
parDisvalue1.Value = Convert.ToDateTime(this.txtDateFrom.Text.Trim());
field1.CurrentValues.Add(parDisvalue1);
field2 = this.CrystalReportViewer1.ParameterFieldInfo[1]; 
parDisvalue2.Value = Convert.ToDateTime(this.txtDateTo.Text.Trim());
field2.CurrentValues.Add(parDisvalue2);
break;
case "Adjustment":
field1 = this.CrystalReportViewer1.ParameterFieldInfo[0]; 
parDisvalue1.Value = Convert.ToDateTime(this.txtDateFrom.Text.Trim());
field1.CurrentValues.Add(parDisvalue1);
field2 = this.CrystalReportViewer1.ParameterFieldInfo[1]; 
parDisvalue2.Value = Convert.ToDateTime(this.txtDateTo.Text.Trim());
field2.CurrentValues.Add(parDisvalue2);
break;
case "RewardShipped_Detail":
field1 = this.CrystalReportViewer1.ParameterFieldInfo[0]; 
parDisvalue1.Value = Convert.ToDateTime(this.txtDateFrom.Text.Trim());
field1.CurrentValues.Add(parDisvalue1);
field2 = this.CrystalReportViewer1.ParameterFieldInfo[1]; 
parDisvalue2.Value = Convert.ToDateTime(this.txtDateTo.Text.Trim());
field2.CurrentValues.Add(parDisvalue2);
break;
case "ConfirmationLetter":
field1 = this.CrystalReportViewer1.ParameterFieldInfo[0]; 
parDisvalue1.Value = Convert.ToDateTime(this.txtDateFrom.Text.Trim());
field1.CurrentValues.Add(parDisvalue1);
field2 = this.CrystalReportViewer1.ParameterFieldInfo[1]; 
parDisvalue2.Value = Convert.ToDateTime(this.txtDateTo.Text.Trim());
field2.CurrentValues.Add(parDisvalue2);
break;
case "RewardShipped_Summary":
field1 = this.CrystalReportViewer1.ParameterFieldInfo[0]; 
parDisvalue1.Value = Convert.ToDateTime(this.txtDateFrom.Text.Trim());
field1.CurrentValues.Add(parDisvalue1);
field2 = this.CrystalReportViewer1.ParameterFieldInfo[1]; 
parDisvalue2.Value = Convert.ToDateTime(this.txtDateTo.Text.Trim());
field2.CurrentValues.Add(parDisvalue2);
break;
}
this.CrystalReportViewer1.DataBind();
}
catch(Exception Ex) 
{
this.lblError.Text = Ex.Message;
}
}
[+][-]02.26.2008 at 07:42AM PST, ID: 20985253

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]02.26.2008 at 07:48AM PST, ID: 20985328

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]02.26.2008 at 01:59PM PST, ID: 20989401

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: Business Objects, Crystal Reports Software
Tags: Crystal Reports, Crystal Reports, 11, web, C#
Sign Up Now!
Solution Provided By: mlmcc
Participating Experts: 2
Solution Grade: A
 
 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628