1.First of All Add New Item Crystal
Report File
2.Not Available Crystal
Report Because it is Third Party Software VS 2010 have not Inbuild Crystal
Report.
3. so First of all
Install Crystall Report 13 Right.
4. Crystall Report is
Installing.
5. That Time We Create
Designing or Creating Database
6.Crystal Report Has 5
Sections
1.Report
Header
2.Page Header
3.Detailes (Scrolling Record)
4.Report
Footer
5.Page Footer
7. Now Completed Programming Crystal
Report to MS Access Database Connectivity in VS 2010
8.Source Code Are As Under
string scon = @"Provider=Microsoft.ACE.OLEDB.12.0;Data
Source=D:\Business Projects\Masters Demo\CrystalReport_WithMSACCESSConnectivityinCsharp\bin\Debug\db_crpdemo.accdb;Persist
Security Info=True";
OleDbConnection con;
OleDbCommand cmd = new
OleDbCommand();
public Form1()
{
InitializeComponent();
}
private void
button3_Click(object sender, EventArgs e)
{
mainmethod("Year");
}
private void mainmethod(string str)
{
long DAY1 = long.Parse(dtp_date.Value.Day.ToString());
long MONTH1 = long.Parse(dtp_date.Value.Month.ToString());
long YEAR1 = long.Parse(dtp_date.Value.Year.ToString());
string selectq = "";
if (str == "Day")
{
selectq
= "select
* from tbl_crpdemo where F_DAY=" + DAY1 + " AND F_MONTH=" + MONTH1 + " AND F_YEAR=" + YEAR1 + "";
}
else if (str == "Month")
{
selectq = "select *
from tbl_crpdemo where F_MONTH=" + MONTH1 + " AND F_YEAR=" + YEAR1 + "";
}
else if (str == "Year")
{
selectq
= "select
* from tbl_crpdemo where
F_YEAR=" + YEAR1 + "";
}
else
{
selectq =
"select
* from tbl_crpdemo";
}
crpreport(selectq);
}
private void
crpreport(string s)
{
Crp_Demo pr
= new Crp_Demo();
DataSet ds2 = new DataSet();
printreport(s).Fill(ds2); pr.SetDataSource(ds2.Tables[0]); crp_RecordReport.ReportSource = pr; crp_RecordReport.RefreshReport();
}
public OleDbDataAdapter
printreport(string q1)
{
con = new OleDbConnection(scon);
con.Open();
DataSet ds = new DataSet();
OleDbDataAdapter adapter = new OleDbDataAdapter(q1,
scon);
return adapter;
con.Close();
}
private void
button1_Click(object sender, EventArgs e)
{
mainmethod("Day");
}
private void
button2_Click(object sender, EventArgs e)
{
mainmethod("Month");
}
private void
Form1_Load(object sender, EventArgs e)
{
mainmethod("All");
}
}
contact me:
(For Source Code And
Designing Trick)
www.plus.google.com/+aminsati
whatsapp
number +918140005015
Comment me
Your Mail ID I will Send You Source Code Thank You,
EmoticonEmoticon