.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
 
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan

Home >> Forum >> C# >> Post New QuestionBookmark and Share Subscribe to Forum

how to export crystal report to pdf

Posted By: jyothi     Posted Date: October 21, 2010    Points:2   Category :C#
hi all,

how to export multiple crystal reports to single pdf. this is very urgent.


reply me immediately

jyothi

Responses
Author: krishana singh             
Posted Date: November 30, 2010     Points: 5   

if (con.State == ConnectionState.Closed)
con.Open();
string a = "select invoiceno,csheetno,paymentby,packagesname,invoicedate,currencey,username,agent,hoteldescription,hotelbookingcharge,hotelbookingqty,totalhotelcharge,packagedescription,packagescharge,packagesqty,totalpackagecharge,ticketdescription,ticketbookingcharge,ticketbookingqty,totalticketcharge,visadescription,visacharge,visaqty,totalvisacharge,subtotal,servicetax,grandtotal,HotelChecked,PackageChecked,TicketChecked,VisaChecked, Discount,TDS,othertax from tbladdinvoice where invoiceno='" + txtinvoicenosearch.Text + "' OR agent='" + txtagentnamesearch.Text + "'OR username='" + txtcustmernamesearch.Text + "' ";
SqlCommand cmd= new SqlCommand(a,con);
SqlDataReader dr= cmd.ExecuteReader();
DataTable dt= new DataTable();
dt.Load(dr);
if (dt.Rows.Count > 0)
{
rpthotel d = new rpthotel();
d.SetDataSource(dt);
crystalReportViewer1.ReportSource = d;
crystalReportViewer1.Refresh();
}



Post Reply

You must Sign In To post reply
 
 
Find more Forum Questions on C#, ASP.Net, Vb.Net, SQL Server and more Here
Quick Links For Forum Categories:
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  OOPs  SilverlightIISJQuery
JavaScript/VBScriptBiztalkWPFPatten/PracticesWCFOthers
www.DotNetSpark.comUnAnsweredAll

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend