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.
"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)"
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 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}
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
Please download from this site: How to Install Crystal Reports for Visual Studio www.tektutorialshub.com/crystal-reports/install-crystal-reports-visual-studio/
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)
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.
![Baby Kia - GLOVES & DRACS (BLACK AF1s) [Official Music Video]](http://i.ytimg.com/vi/ajm8LeB0qQk/mqdefault.jpg)
Congratulations on the video .. teaches how to feed a combobox through a table with access data ..
+Adriano Monteiro Thanks for your suggestions. ^_^
Very informative video. Please make another video in vb.net similer to sumifs function of excel
Thanks so much for your suggestion. Happy coding.
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.
"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)"
Thank you very much
You are welcome.
the datbasename.table name is not work
location load is not work
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 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
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
error 1-load report fail and
2-invalid report file path
same
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
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/
DEAR SIR UNABLE TO LOAD DATA
Yes brother i have same problem if u have solution plzz reply
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: ruclips.net/video/EmiEtKoiDvY/видео.html
@@iBasskung thank you this tutorial working for me and i get finished my project, thanks appreciated
Congratulations 🎊
@@iBasskung yes sir, thank you
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.
JUST HEADING ONLY DISPLAYING
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.