Actually when i run my Website , in local system it have been giving the required output of crystal reports when launching locally.
But when i post in iis 7.5 all the remaining crystal reports have been executing except only one report showing as blank ( Design layout only available ).
This is my webconfig
="1.0"="UTF-8"<configuration><configSections><sectionGroup name="businessObjects"><sectionGroup name="crystalReports"><section name="rptBuildProvider" type="CrystalDecisions.Shared.RptBuildProviderHandler, CrystalDecisions.Shared, Version=13.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304, Custom=null" /></sectionGroup></sectionGroup></configSections>
<connectionStrings>
<add name="webgardConnectionString" connectionString="Data Source=ATTIC-PC;Initial Catalog=webgard;Integrated Security=True" providerName="System.Data.SqlClient" />
<add name="webgardConnectionString2" connectionString="Data Source=ATTIC-PC;Initial Catalog=webgard;Integrated Security=True" providerName="System.Data.SqlClient" />
<add name="webgardConnectionString3" connectionString="Data Source=ATTIC-PC;Initial Catalog=webgard;Integrated Security=True" providerName="System.Data.SqlClient" />
<add name="webgardConnectionString4" connectionString="Data Source=ATTIC-PC;Initial Catalog=webgard;Integrated Security=True" providerName="System.Data.SqlClient" />
<add name="WebgardConnectionString5" connectionString="Data Source=ATTIC-PC;Initial Catalog=Webgard;Integrated Security=True" providerName="System.Data.SqlClient" />
<add name="WebgardConnectionString6" connectionString="Data Source=ATTIC-PC;Initial Catalog=Webgard;Integrated Security=True" providerName="System.Data.SqlClient" />
<add name="WebgardConnectionString7" connectionString="Data Source=ATTIC-PC;Initial Catalog=Webgard;Integrated Security=True" providerName="System.Data.SqlClient" />
<add name="WebgardConnectionString8" connectionString="Data Source=ATTIC-PC;Initial Catalog=Webgard;Integrated Security=True" providerName="System.Data.SqlClient" />
<add name="WebgardConnectionString9" connectionString="Data Source=ATTIC-PC;Initial Catalog=Webgard;Integrated Security=True" providerName="System.Data.SqlClient" />
<add name="WebgardConnectionString10" connectionString="Data Source=ATTIC-PC;Initial Catalog=Webgard;Integrated Security=True" providerName="System.Data.SqlClient" />
<add name="WebgardConnectionString11" connectionString="Data Source=ATTIC-PC;Initial Catalog=Webgard;Integrated Security=True" providerName="System.Data.SqlClient" />
<add name="WebgardConnectionString12" connectionString="Data Source=SKPILLAI-PC;Initial Catalog=Webgard;Integrated Security=True" providerName="System.Data.SqlClient" />
<add name="WebgardConnectionString13" connectionString="Data Source=SKPILLAI-PC;Initial Catalog=Webgard;Integrated Security=True" providerName="System.Data.SqlClient" />
<add name="WebgardConnectionString14" connectionString="Data Source=SKPILLAI-PC;Initial Catalog=Webgard;Integrated Security=True" providerName="System.Data.SqlClient" />
<add name="WebgardConnectionString15" connectionString="Data Source=SKPILLAI-PC;Initial Catalog=Webgard;Integrated Security=True" providerName="System.Data.SqlClient" />
<add name="WebgardConnectionString16" connectionString="Data Source=SKPILLAI-PC;Initial Catalog=Webgard;Integrated Security=True" providerName="System.Data.SqlClient" />
<add name="WebgardConnectionString17" connectionString="Data Source=SKPILLAI-PC;Initial Catalog=Webgard;Integrated Security=True" providerName="System.Data.SqlClient" />
<add name="WebgardConnectionString18" connectionString="Data Source=ATTIC-PC\SQLEXPRESS;Initial Catalog=Webgard;Integrated Security=True" providerName="System.Data.SqlClient" />
</connectionStrings>
<startup useLegacyV2RuntimeActivationPolicy="true">
<supportedRuntime version="v4.0"/>
<requiredRuntime version="v4.0.20506"/>
</startup>
<appSettings>
<add key="CrystalImageCleaner-AutoStart" value="true" />
<add key="CrystalImageCleaner-Sleep" value="60000" />
<add key="CrystalImageCleaner-Age" value="120000" />
</appSettings>
<system.web>
<compilation debug="true" targetFramework="4.0"><assemblies><add assembly="CrystalDecisions.CrystalReports.Engine, Version=13.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304" /><add assembly="CrystalDecisions.ReportSource, Version=13.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304" /><add assembly="CrystalDecisions.Shared, Version=13.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304" /><add assembly="CrystalDecisions.Web, Version=13.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304" /><add assembly="CrystalDecisions.ReportAppServer.ClientDoc, Version=13.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304" />
</assemblies><buildProviders><add extension=".rpt" type="CrystalDecisions.Web.Compilation.RptBuildProvider, CrystalDecisions.Web, Version=13.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304" /></buildProviders></compilation>
<httpHandlers><add verb="GET" path="CrystalImageHandler.aspx" type="CrystalDecisions.Web.CrystalImageHandler, CrystalDecisions.Web, Version=13.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304" /></httpHandlers></system.web>
<system.webServer><handlers>
<remove name="svc-Integrated" /><add name="CrystalImageHandler.aspx_GET" verb="GET" path="CrystalImageHandler.aspx" type="CrystalDecisions.Web.CrystalImageHandler, CrystalDecisions.Web, Version=13.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304" preCondition="integratedMode" /></handlers><validation validateIntegratedModeConfiguration="false" />
<directoryBrowse enabled="true" />
<modules>
<remove name="ServiceModel" />
</modules></system.webServer><businessObjects><crystalReports><rptBuildProvider><add embedRptInResource="true" /></rptBuildProvider></crystalReports></businessObjects>
<system.net>
<settings>
<socket alwaysUseCompletionPortsForAccept="false" alwaysUseCompletionPortsForConnect="false" />
</settings>
</system.net>
</configuration>
Code.cs:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using CrystalDecisions.CrystalReports.Engine;
using CrystalDecisions.Shared;
using System.Data.SqlClient;
using System.Data;
public partial class Report : System.Web.UI.Page
{
SqlConnection con = new SqlConnection("Data Source=ATTIC-PC\\SQLEXPRESS;Initial Catalog=Webgard;Integrated Security=True");
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
con.Open();
SqlCommand cmd = new SqlCommand("select distinct client_name from client_info", con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
ddclientname.DataTextField = "client_name";
ddclientname.DataValueField = "client_name";
ddclientname.DataSource = ds;
ddclientname.DataBind();
ddclientname.Items.Insert(0, new ListItem("-------select-------", "0"));
con.Close();
}
}
protected void Button1_Click(object sender, EventArgs e)
{
con.Open();
string Str;
ReportDocument cr = new ReportDocument();
cr.Load(Server.MapPath("~\\Reports\\Salary.rpt"));
Str = "select a.client_name,a.Emp_id,a.Employee_name,a.Grade,a.tot_days,a.mont,a.OT_days,a.tota_days,a.from_date,a.to_date,m.mess,co.conveyance,ad.Advance,r.Rent,u.Uniform from Attendance a inner join client_info c on a.client_name=c.client_name inner join mess m on a.Emp_id=m.Emp_id and a.client_name=m.client_name and a.from_date=m.from_date inner join uniform u on a.Emp_id=u.Emp_id and a.client_name=u.client_name and a.from_date=u.from_date inner join advance ad on a.Emp_id = ad.Emp_id and a.from_date=ad.from_date and a.client_name=ad.client_name inner join conveyance co on a.Emp_id=co.Emp_id and a.client_name=co.client_name and a.from_date=co.from_date inner join Rent r on a.Emp_id=r.Emp_id and a.client_name=r.client_name and a.from_date=r.from_date and ad.from_date='" + TextBox2.Text + "' and a.from_date='" + TextBox2.Text + "' and a.to_date='" + TextBox3.Text + "' and a.client_name='" + ddclientname.SelectedItem.ToString() + "'";
SqlCommand cmd = new SqlCommand(Str, con);
cmd.ExecuteNonQuery();
SqlDataAdapter ad1 = new SqlDataAdapter(cmd);
DataTable dt = new DataTable("Webgard");
ad1.Fill(dt);
cr.SetDataSource(dt);
CrystalReportViewer1.ReportSource = cr;
CrystalReportViewer1.RefreshReport();
con.Close();
}
}
Aspx.page
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Report.aspx.cs" Inherits="Report" %>
<%@ Register Assembly="CrystalDecisions.Web, Version=13.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"
Namespace="CrystalDecisions.Web" TagPrefix="CR" %>
<%@ Register assembly="AjaxControlToolkit" namespace="AjaxControlToolkit" tagprefix="asp" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
<link href="css/report.css" rel="stylesheet" type="text/css" />
</head>
<body>
<form id="form1" runat="server">
<div style="height: 796px ; background-color:ButtonHighlight" >
<CR:CrystalReportViewer ID="CrystalReportViewer1" runat="server"
AutoDataBind="true"/>
<asp:scriptmanager ID="Scriptmanager1" runat="server"></asp:scriptmanager>
<asp:Panel ID="Panel1" runat="server" CssClass="pa1" BorderColor="Black"
BorderStyle="Solid">
<asp:Button ID="Button1" runat="server" Text="VIEW REPORT"
CssClass="btnview" onclick="Button1_Click" />
<asp:TextBox ID="TextBox2" runat="server" CssClass="txtfrmdate" ></asp:TextBox>
<asp:CalendarExtender ID="TextBox2_CalendarExtender" runat="server"
Enabled="True" TargetControlID="TextBox2">
</asp:CalendarExtender>
<asp:TextBox ID="TextBox3" runat="server" CssClass="txttodate"></asp:TextBox>
<asp:CalendarExtender ID="TextBox3_CalendarExtender" runat="server"
Enabled="True" TargetControlID="TextBox3">
</asp:CalendarExtender>
<asp:DropDownList ID="ddclientname" runat="server" CssClass="ddclient">
</asp:DropDownList>
<asp:Label ID="lb1" runat="server" CssClass="lb1" Text="Client Name"></asp:Label>
<asp:Label ID="lb2" runat="server" CssClass="lb2" Text="From Date"></asp:Label>
<asp:Label ID="lb3" runat="server" CssClass="lb3" Text="To Date"></asp:Label>
</asp:Panel>
</div>
</form>
</body>
</html>