Hi, i am working on web application. I am using visual studio 2008 as ide and sql server 2005 as database. i used Microsoftreportviewer to print the report. it work fine at localhost but when it's uploded on server it shows the following error: Document is not found on the server. so plz anyone help me to short out this prblm.
i used the following code on (.cs) file
using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
public partial class PrintCheckout : System.Web.UI.Page
{
SqlConnection con = new SqlConnection();
string conctn = ConfigurationManager.ConnectionStrings["con"].ConnectionString;
SqlCommand com;
string roomno = "";
string id = "";
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
roomno = Request.QueryString["RoomNo"];
id = Request.QueryString["id"];
this.ReportViewer1.LocalReport.DataSources.Clear();
DataSet1 ds = new DataSet1();
DataTable dt = new DataTable();
con.ConnectionString = conctn;
dt.TableName = "Print Advance Report";
dt = getAllOrders();
ds.Tables[0].Merge(dt);
Microsoft.Reporting.WebForms.ReportDataSource rptDataSource = new Microsoft.Reporting.WebForms.ReportDataSource("DataSet1_DataTable1", dt);
this.ReportViewer1.LocalReport.DataSources.Add(rptDataSource);
this.ReportViewer1.LocalReport.Refresh();
}
}
public DataTable getAllOrders()
{
con.ConnectionString = conctn;
DataSet ds = null;
SqlDataAdapter adapter;
try
{
ds = new DataSet();
adapter = new SqlDataAdapter("select C.BillNo,dbo.GuestName(C.GuestID) as Name,convert(varchar(10),C.Date,103) as Date,convert(varchar(10),R.ArrivalDate,103) as ArrivalDate,R.ArrivalTime,convert(varchar(10),C.DepartureDate,103) as DepartureDate,C.DepartureTime,R.RoomRent,C.TotalRoomRent,C.RoomNo,E.NoOfPersons,C.LaundaryBill,C.FoodingBill,A.LuxuryTax,A.ServiceTax,A.ServiceCharges,A.AdvanceAmount,C.TotalDays,C.Refund,C.Total,C.GrandTotal,C.Discount,C.ExtraBedCharges,C.ExtraAmount from CheckOut C inner join Amount A on C.GuestID=A.GuestID inner join AllotRoom R on C.GuestID=R.GuestID inner join GuestEntry E on E.ID=C.GuestID where C.RoomNo='" + roomno + "' and C.GuestID='" + id + "'", con);
adapter.Fill(ds);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
con.Close();
}
return ds.Tables[0];
}
}