Write the code in your event. Replace connectionstring and crystal report file name. noted that your OS, crystal reports version and VS version should accommodate. CrystalReportGroup cr = new CrystalReportGroup(); SqlConnection conn = new SqlConnection(); conn.ConnectionString = ConfigurationManager.ConnectionStrings["MYfirstApp.Properties.Settings.MyFirstDBConnectionString"].ToString(); ParameterFields From = new ParameterFields(); ParameterField PID = new ParameterField(); PID.Name = "ProductID";// remember that your parameter field name and column name must be equal. ParameterDiscreteValue val = new ParameterDiscreteValue(); val.Value = Class1.ProductID; PID.CurrentValues.Add(val); From.Add(PID); crystalReportViewer1.ParameterFieldInfo = From; string sql = "SELECT * from SaleInfoView where ProductID = '"+Class1.ProductID+"' "; DataSet ds = new DataSet(); SqlDataAdapter adapter = new SqlDataAdapter(sql, conn); adapter.Fill(ds, "SaleInfoView"); cr.SetDataSource(ds.Tables["SaleInfoView"]); crystalReportViewer1.ReportSource = cr; crystalReportViewer1.Refresh();
HI, Really helped your video. thanks. when used where condition, it display perfectly, but when import record if shows all record. that mean where condition not working. pls help me to solve this issues
Hello sir. Muje aik issue a rha hy. Ma database sy invoice receipts print krwna chah rha hn. Aik hi table sy with unique invoice number. Crystal report use kr k. Lakin muje samj ni a rhi kasy krun. Help me sir with appropriate tutorial.
@@reubenmwangikibara4434 which crystal setup are you trying to use Mwangi? There's Crystal Reports for Visual Studio that you need to download and install which will automatically integrate with VS. Ensure it's not the stabdalone version that you create reports separately. Ukishindwa unishow nikupatie link
@@SwiftLearn this is not issue i figure out that in temp folder there is creating (Bigbal 3388_6284_{0383619A-AAED-45E2-B244-0A66A7A8C55C}) this temporary file when meet 75 time then crystal report stop showing data
I am using linq. thats why the connection created automatically. you can write what is your database connection. or add linq file. see this video. ruclips.net/video/9r65Zf0ZZko/видео.html
My VS2019 code is given below nothing is displaying in page ReportDocument cryRpt = new ReportDocument(); cryRpt.Load(@"~\CrystalReport1.rpt"); CrystalReportViewer1.ReportSource= cryRpt; CrystalReportViewer1.RefreshReport();
in 2015 visual studio video concept not working. what should i do? please send me source code my email sureshsurya220@gmail.com. please help me
Write the code in your event.
Replace connectionstring and crystal report file name.
noted that your OS, crystal reports version and VS version should accommodate.
CrystalReportGroup cr = new CrystalReportGroup();
SqlConnection conn = new SqlConnection();
conn.ConnectionString = ConfigurationManager.ConnectionStrings["MYfirstApp.Properties.Settings.MyFirstDBConnectionString"].ToString();
ParameterFields From = new ParameterFields();
ParameterField PID = new ParameterField();
PID.Name = "ProductID";// remember that your parameter field name and column name must be equal.
ParameterDiscreteValue val = new ParameterDiscreteValue();
val.Value = Class1.ProductID;
PID.CurrentValues.Add(val);
From.Add(PID);
crystalReportViewer1.ParameterFieldInfo = From;
string sql = "SELECT * from SaleInfoView where ProductID = '"+Class1.ProductID+"' ";
DataSet ds = new DataSet();
SqlDataAdapter adapter = new SqlDataAdapter(sql, conn);
adapter.Fill(ds, "SaleInfoView");
cr.SetDataSource(ds.Tables["SaleInfoView"]);
crystalReportViewer1.ReportSource = cr;
crystalReportViewer1.Refresh();
Please subscribe.
Excellent Tutorials
thanks
HI, Really helped your video. thanks. when used where condition, it display perfectly, but when import record if shows all record. that mean where condition not working. pls help me to solve this issues
Excellent Bro Keep posting
Thank you, I will
easy to understand😍
after dowloading the crustal setup, how do you intergrate with visual basic 2015
i will upload such tutorial as soon as possible.
@@SwiftLearn
Would you help me at personal level if we likup plz
Can I just use the Tables instead of making Views? or do I need the Views for this to work?
you can use only table. but when you need to use multiple table create view. thanks
Hello sir.
Muje aik issue a rha hy. Ma database sy invoice receipts print krwna chah rha hn. Aik hi table sy with unique invoice number. Crystal report use kr k.
Lakin muje samj ni a rhi kasy krun. Help me sir with appropriate tutorial.
Whats your Visual Studio version? if its VS 10 this tutorial help you to success, if VS 15 see this tutorial ruclips.net/video/Ys2MfQHPQ88/видео.html
Thank you for this video. Can you do the same connecting to a local database rather than SQL server DB?
This is very easy. just put local database connection string. thanks.
after dowloading the crustal setup, how do you intergrate with visual basic 2015
@@reubenmwangikibara4434 which crystal setup are you trying to use Mwangi? There's Crystal Reports for Visual Studio that you need to download and install which will automatically integrate with VS. Ensure it's not the stabdalone version that you create reports separately. Ukishindwa unishow nikupatie link
@@DrWambua kindly send me the link, am green in using crystall reports. kindly help. my emailis: reubenmwangikibara@gmail.com
How do you find the .cs file, as when i clicked on the button it was a .vb file. Please help asap
just double click on form to go in .cs file
hi sir,i am facing issue that after publishing crystal report it is not showing data ,please help
if your textobject is smaller than value make it bigger
it shows data after 20 to 30 print view it stop to give printview
@@akhterhussain100 are you working in crystal report?
@@SwiftLearn this is not issue i figure out that in temp folder there is creating (Bigbal 3388_6284_{0383619A-AAED-45E2-B244-0A66A7A8C55C}) this temporary file when meet 75 time then crystal report stop showing data
write this code in unload event crystalReport.Close();
crystalReport.Dispose();
thank you
Where add name= connection ? And how to get it that connection in the app.config pls help me
I am using linq. thats why the connection created automatically. you can write what is your database connection. or add linq file.
see this video. ruclips.net/video/9r65Zf0ZZko/видео.html
My VS2019 code is given below nothing is displaying in page
ReportDocument cryRpt = new ReportDocument();
cryRpt.Load(@"~\CrystalReport1.rpt");
CrystalReportViewer1.ReportSource= cryRpt;
CrystalReportViewer1.RefreshReport();
this is great tutorial. How to add image in crystal report?
You are also great.
Design the Dynamic Crystal Report of Receipt Size For Hotel That’s Include: Hotel Name, Items Detail, Quantity, Price Detail, And Total Amount.
يا جماعة انا عندي مشكلة كبيرة مش عارف ليها حل الارقام في الكريستال ما بتظهرش عربي في ويندوز 10 او ويندوز8 زي ويندوز 7
Anybody translate it in English please?
He asking about format of number viewing .Arabic number format in win 8 and 10 not view in the format is unlike win 7
من الخصائص من paragraph و اختار right to left
How to create report without relation with main report plz.
its fulfill your requirement ruclips.net/video/bm_Qx1DAyEQ/видео.html
i copied as it is doenst shows anything on screen
are you use VS10 in OS 10? so. you should use vs 15 and Crystal report 13_0_19 in OS10. thanks.
Facile
16:00
Tax cgst sgt total
@12 120 120 240
@18 320 320 640 crystal report how make?
Its simple just try.
Error found
adapter.Fill(ds, "tbl_std");
DataTable dt = ds.Tables["tbl_std"];
cr.SetDataSource(ds.Tables["tbl_std"]);
cr.SetDataSource(ds.Tables["tbl_std"]);
crystalReportViewer1.ReportSource = cr;
crystalReportViewer1.Refresh();
kindly stop talking !!!!!!!!!