VB.NET How to filter data in Crystal Reports using DateTimePicker
ฝัง
- เผยแพร่เมื่อ 20 ก.ย. 2024
- Get special perks and content-become a member today!
► / @ibasskung
Exclusive Videos for Members:
► • Members-only videos
สมัครเรียนคอร์สออนไลน์ (เรียนได้ตลอดชีพ) ภาษา C# และ Visual Basic .NET
หลักสูตรสำหรับผู้เริ่มต้นเขียนโปรแกรม (คอร์สพื้นฐาน), หลักสูตรพัฒนา Modern Desktop App ไปจนถึงหลักสูตรขั้นสูง (คอร์ส Workshop สอนทำโปรเจกต์)
📖 ดูหลักสูตรทั้งหมด: bit.ly/3lXWoj2
สนใจ สมัครโดยตรงกับอาจารย์ได้ที่เพจ หรือ LINE
► / codeaminute
Check out my Udemy courses:
Visual Basic .NET Programming for Complete Beginners
► bit.ly/3mgCOgp
Master Visual Basic .NET by Building a Point Of Sale System
► bit.ly/2PZvPfY
Free source code: codeaminute.bl...
Purchase source code: payhip.com/iBa...
Support me on Patreon: / ibasskung
💬 พูดคุยกับผมที่...
► LINE OA : lin.ee/ApE56xD
📺 ติดตามช่อง TH-cam
► / @ibasskung
► / @ibasskungacademy
► TikTok : tiktok.com/@codeaminute
#iBasskung #ComputerProgramming #สอนเขียนโปรแกรม
Very informative video. Please make another video in vb.net similer to sumifs function of excel
Thanks so much for your suggestion. Happy coding.
Congratulations on the video .. teaches how to feed a combobox through a table with access data ..
+Adriano Monteiro Thanks for your suggestions. ^_^
thanh you very much
You're welcome.
its a very good video
i have a question
what about a multiple selection in datagridview for example you select 3 data in datagrid view and pass it to crystal report
Thank you
You can use the DataGridView.MultiSelect Property. see this post for more info: stackoverflow.com/questions/41729130/multiple-selection-in-datagridview Hope this helps, thank you so much.
When i tried this code . I got an error in my program .. worst thing happen it causes a crash in my vs code application . Dont try this . Not recomended
Thank you very much
You are welcome.
"Hello, I have problem like when I select date like 1-feb to 28-feb the report shows jan months record in Feb's record. I use same code shows in video.(stringformula)"
Same problem here can u give me the resolution for this?
the problem is that Crystal report generally uses the yyyy / mm / dd format, I solve it using the formula in datetime
stringformula = "{PURCHASES.DATE} In DateTime (" & yearstar & "," & monstart & "," & daystart & ", 00, 00, 00) To DateTime (" &
yearend & "," & monthend & "," & dayend & ", 00, 00, 00)"
the datbasename.table name is not work
location load is not work
Great video sir, but i encountered an error when searching "from" date "to" date. My report gives an error "a date-time is required here" i used this code
result = "{ProductionOrder.IssueDate} >= #" & dtFrmSearchDate.Value.ToString("dd-MMM-yyyy") & "# "
result &= "AND {ProductionOrder.IssueDate}
Please visit my page: facebook.com/CodeAMinute
Thanks
error 1-load report fail and
2-invalid report file path
same
Hi, I'm getting an error "Failed to open rowset. Details: ADO Error Code: 0x; Source: Microsoft Office Access Database Engine; Description: Undefined function 'CONVERT' in expression. SQL state: 3085" How can I solve this?
Here is my coding :
stringformula = "{Purchase_PO.Po Date >= #" & Me.DateTimePicker1.Value.ToShortDateString & "# "
stringformula &= " And {Purchase_PO.Po Date}
Hello, Thanks so much for watching my video. Here are my original code:
stringFormula = "{Table1.Birth Date} >= #" & Me.DateTimePicker1.Value.ToShortDateString & "# "
stringFormula &= "And {Table1.Birth Date}
Great video👍
But i don't understand the codes because im using C# 😢 can u make c# videos like this plss im using c# and crystal report
Thanks for your suggestions. Here's an example: m.facebook.com/story.php?story_fbid=969545236551793&id=565459980293656
DEAR SIR UNABLE TO LOAD DATA
Yes brother i have same problem if u have solution plzz reply
Cara instal crystal report di vb 2019 gmna
the crystal report doesn't showed up what am should i do?
Please download from this site: How to Install Crystal Reports for Visual Studio
www.tektutorialshub.com/crystal-reports/install-crystal-reports-visual-studio/
please i need this by name and date at same time by c# and sql please thank you
Thanks so much for your suggestion. I will do it asap. Happy coding.
Hello, I have problem like when I select date like 1-feb to 28-feb the report shows jan months record in Feb's record. I use same code shows in video.(stringformula)
same with me need help :(
@@xiaokave change report method first show records in datagridview after move record to report n that's all.
@@arnavpatel3809 that's lot work to do. Any other solution?
@@arnavpatel3809 how to bring the datagridview records into the crystal report viewer?
@@xiaokave it's some code change and that's it.
Send your emailid I will send my code.
Hi my dear friend I have trouble
I need to make premiry school management system
Can you do that
khadar tutor
Zxp wax maad ka fahan tay kan
Why try Error message Invalid report file path.
Thanks so much for watching. please check out this tutorial: th-cam.com/video/EmiEtKoiDvY/w-d-xo.html
@@iBasskung thank you this tutorial working for me and i get finished my project, thanks appreciated
Congratulations 🎊
@@iBasskung yes sir, thank you
JUST HEADING ONLY DISPLAYING
Please source code Please
For more tutorials with source code examples, please chek out my blog: codeaminute.blogspot.com
Thanks so much. Have a nice day and Happy coding.
I'm preparing a graduating borogram premiry school management system
otherwise i would not graduate
Please help me
Sxb dadka qaar jawab lagama helo inta badan hadii weli caawimad aad u baahan tahay ila so xiriir balse waxaan filaya in waqtigani aad qalinjabisay :)
Hello
Hello, Thanks so much for watching my video.
For more tutorials and source code examples, please check out my blog: codeaminute.blogspot.com
Have a nice and Happy coding.