how to make rdlc report in vb.net using mysql database

hi welcome to RvB developing Channel today our topic of discussion is rdlc report today we will learn how to create this report on an invoice so that we can become aware of creating invoices today we will learn about rdlc reports the correct method of creating rdlc reports Dynamic data connection and expression fields in the report Etc if anyone has any questions about the project we are making this video on today then I will tell them to watch the previous video I will put the link of the previous video in the description box of the video for them let's get started first we will see how the rdlc report works for that we will make an invoice entry here okay now our entry is done now we will save the invoice now after saving we will get a do want to print receipt dialog now if we click on the yes button then the invoice will be visible in front of us as you can see the invoice is displayed in front of us now we will close it now we will print this invoice in a different way now you can see our invoice okay now we will try to understand the whole thing practically our request to those who are watching the video you must subscribe our Channel and share the video because we put a lot of hard work behind making this video that's why we have this special request for you let's get started now we will first create a blank data set and create a blank table that will be just like our real table here you can create it separately but it must match the query that you write in your program let's get started now we right-click on the project and then go to add and then go to add new item here we click on the data Tab and then here we select data set now here we put the data set name then we will click add now we will create a table just like the real table in our database now we will create columns here like the table columns in our database our table has been created now we will only set the data type of some columns to decimal otherwise we will not able to do any calculations in the report later after that there is a solution for them if they make a mistake we will discuss it later now we save and close the data set now we add a rdlc report now we right-click on the project and then we go to add then click on new item here we click on reporting tab then here we select report now we will name the report then we will click on ADD button now we will go into the report data if we don't find the report data here then we will click on the report data in the view tab above after that here you can see report data tab now we click on report data now we right-click on data set and then click on add data set here we will name the data set for the report the reason for this name will be understood while we programming here we will select the data set that we have created earlier here the table is automatically selected which was in our data set now we click on OK all right now we will add here first report header and Report footer now we will Design the report you will see the whole thing very seriously because it is an important part of the video now we are designing this text box for report header here we will add the ruler for position measurement now we will add both text and column value to the expression of this text box first we will put our text here in double quotation marks then we put the Ampersand symbol then we will add the data set fields after pasting the data set field here we will now delete these two parts from here and here now click ok now we will create the next Fields by copying it now here also we will use similar method now we will move forward one by one you can keep watching the video without skipping okay our report design is done now we will go back into the form now we will program to display the report we have already prepared the code to save time now we will just copy and paste it here sorry rrdlc report viewer is not created here that's why the error shows here so we will add report viewer here the name we will use here is the name we have in our programming we will add this report viewer here okay everything is fine now we will execute the program sorry an error has shown here okay we understand where the error is coming from now we will execute once more and see what happens all right now we will do an invoice entry here okay our invoice entry is done now we will save and after saving a dialog box will appear in front of us then if we click on the yes button the invoice will appear in front of us okay now the invoice is displayed in front of us there are some issues with the invoice we will fix them okay let's execute it once more now we will edit and update this invoice here we will only change the date and then we click on update button here you can see the invoice displayed in front of us but there is a little problem we will solve it soon okay now we close and fix it all right now we execute again now we will print the invoice in another way okay everything is fine as you can see now what you are seeing here is grouping problem I will tell you the day when I will discuss about grouping otherwise everything is fine okay that's it for today's video many thanks to those watching the video our request to those who are watching the video if you like the video then please subscribe the channel and click on the Bell icon and please share the video thank you

Channel: VB Developing

Views: 1,648

Keywords: how to make rdlc report in vb.net using mysql database, rdlc report in vb.net using mysql database, rdlc report in vb.net with mysql database, rdlc report in vb.net with mysql database example, rdlc report using dataset in vb.net microservices, rdlc report using dataset in vb.net, vb.net tutorial, vb.net projects, vb.net programming, make rdlc report using dataset in vb.net core, #vb.net, #visualbasic, #visualstudio, #mysql, #mysqltutorials, #mysqldba, #mysqldatabase, #mysqldb, #rdlc, #vb

Id: hWc-FFBsGws

Length: 31min 17sec (1877 seconds)

Published: Mon Oct 03 2022