How to Create Crystal Reports in Visual Studio 2010 c# with SQL. part 1

[@nanidancer]

in 2015 visual studio video concept not working. what should i do? please send me source code my email [e-mail]. please help me

[@SwiftLearn]

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();

[@SwiftLearn]

Please subscribe.

[@alanthilakraja]

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

[@farjanaakther5538]

Excellent Tutorials

[@SwiftLearn]

thanks

[@dnyaneshwarnarwate8594]

Excellent Bro Keep posting

[@SwiftLearn]

Thank you, I will

[@playfree9238]

Can I just use the Tables instead of making Views? or do I need the Views for this to work?

[@SwiftLearn]

you can use only table. but when you need to use multiple table create view. thanks

[@sweetenglish]

easy to understand😍

[@hamid_raza_ch]

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.

[@SwiftLearn]

Whats your Visual Studio version? if its VS 10 this tutorial help you to success, if VS 15 see this tutorial kzbin.info/www/bejne/j6SVfpmHfbWEbpo

[@reubenmwangikibara4434]

after dowloading the crustal setup, how do you intergrate with visual basic 2015

[@SwiftLearn]

i will upload such tutorial as soon as possible.

[@reubenmwangikibara4434]

@@SwiftLearn Would you help me at personal level if we likup plz

[@yapandasoftware]

Thank you for this video. Can you do the same connecting to a local database rather than SQL server DB?

[@SwiftLearn]

This is very easy. just put local database connection string. thanks.

[@reubenmwangikibara4434]

after dowloading the crustal setup, how do you intergrate with visual basic 2015

[@DrWambua]

@@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

[@reubenmwangikibara4434]

@@DrWambua kindly send me the link, am green in using crystall reports. kindly help. my emailis: [e-mail]

[@nizamuddin4128]

this is great tutorial. How to add image in crystal report?

[@SwiftLearn]

You are also great.

[@lifeliness8398]

Design the Dynamic Crystal Report of Receipt Size For Hotel That’s Include: Hotel Name, Items Detail, Quantity, Price Detail, And Total Amount.

[@bopbycntt5571]

thank you

[@ginasimrankaur7674]

How do you find the .cs file, as when i clicked on the button it was a .vb file. Please help asap

[@SwiftLearn]

just double click on form to go in .cs file

[@laicalenmacias151]

Where add name= connection ? And how to get it that connection in the app.config pls help me

[@SwiftLearn]

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. kzbin.info/www/bejne/b6OZZo2cZb-NodE

[@akhterhussain100]

hi sir,i am facing issue that after publishing crystal report it is not showing data ,please help

[@SwiftLearn]

if your textobject is smaller than value make it bigger

[@akhterhussain100]

it shows data after 20 to 30 print view it stop to give printview

[@SwiftLearn]

@@akhterhussain100 are you working in crystal report?

[@akhterhussain100]

@@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

[@SwiftLearn]

write this code in unload event crystalReport.Close(); crystalReport.Dispose();

[@sweetenglish]

Facile

[@aminaali5905]

How to create report without relation with main report plz.

[@SwiftLearn]

its fulfill your requirement kzbin.info/www/bejne/mJ7Cgqtneaase7M

[@mahmoudabdelfatah7027]

يا جماعة انا عندي مشكلة كبيرة مش عارف ليها حل الارقام في الكريستال ما بتظهرش عربي في ويندوز 10 او ويندوز8 زي ويندوز 7

[@SwiftLearn]

Anybody translate it in English please?

[@obadaageeb8581]

He asking about format of number viewing .Arabic number format in win 8 and 10 not view in the format is unlike win 7

[@abbasmohammed1034]

من الخصائص من paragraph و اختار right to left

[@samicasanova6720]

16:00

[@asad8710]

i copied as it is doenst shows anything on screen

[@SwiftLearn]

are you use VS10 in OS 10? so. you should use vs 15 and Crystal report 13_0_19 in OS10. thanks.

[@saulsamson4311]

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();

[@moorthithambi1227]

Tax cgst sgt total @12 120 120 240 @18 320 320 640 crystal report how make?

[@SwiftLearn]

Its simple just try.

[@shanilkt8723]

My VS2019 code is given below nothing is displaying in page ReportDocument cryRpt = new ReportDocument(); cryRpt.Load(@"~\CrystalReport1.rpt"); CrystalReportViewer1.ReportSource= cryRpt; CrystalReportViewer1.RefreshReport();

[@mohyminulshisier9160]

kindly stop talking !!!!!!!!!