i am new in Crystal Report, I've Created a Crystal Report Successfully By following Methods
1)Created Crystal Report As Blank
2)get into Database Expert and create Database using OLE DB(ADO)
3)in OLE DB(ADO) i simply add tables into the Database and showed it on Crystal Report
4)Then i created a Win form on which i used Crystal Report Viewer
5)then i use following Code on Crystal Report Viewer Tab to Call the Crystal Report
Code:
var cryRpt = new ReportDocument();
cryRpt.Load(@"C:\Users\Ahsan\Desktop\PROJECT INVENTORY SOFTWARE\InventorySoftware\InventorySoftware\Crystal Reports\CrystalReport2.rpt");
crystalReportViewer1.ReportSource = cryRpt;
crystalReportViewer1.Refresh();
Now what does it do, it go to table fetch complete Data on the table, like if i have 500 Records then it will load all the 500 Records, and that's what i don't want to do. what i actually need to do is to fetch data of a specific invoice no and i am not able to do this in any way.
i want it to fetch data for only that invoice number which is written on the form (a text box) at run time, and the query through which i want to fetch data is build using Joins.
i am stuck and doing Google from past 3 hours but not able to do it.
Please dear fellows Help me out. i will be very grateful
Thanks.