RDLC Report C# | Multiple Reports in Same Report Viewer Page in c# Windows Form with SQL Server

welcome to my channel so plan this tutorial I will show you how to create multiple report in a single our daily report in c-sharp in his palm application if you don't subscribe my channel yet please subscribe and press the bell icon for upcoming videos start Visual Studio click on new project when this power application name the application multiple report are DLC location ng icon folder and sister dinner for the children the G icon folder okay now it says this form in this form I will display report multiple report and single our deals report this is my database username sspecial authentication and password is blah blah blah okay now it's connected this is the tablet ease of the table it's 20 info tab exam info tab and class info tab and these are the column in this table okay now go to the tool box and at button control this button control used to load report in report viewer at the level control this level control I will use this title of the space text is multiple report in a single rdls report windows palm change the font size make it as bigger because of this is title to space font bold true okay and since the back color of this form this is default control back color as green yes now it's looking nice and change the back color of this button control also okay now change the font size of this button text size is 10 and font volt true okay now by far for color I mean text color is white ok button face there's a text text is load report yes now go to the tool box and add a max up to report viewer just a drag the expand the reporting and report B were drugged and drop it in the windows power application it says this report beaver ok it's ok now I'm adding a dataset right click on the project in solution Explorer and add new item click on data select the dataset and name the data set the default name is data set to 1 dot access Li I just renamed it with the method is it ok now the data set is created you can add the data table or you can drag the dated here and the table from the server Explorer which you created in the SQL Server database click on yes the connection is to use does all ok class info tab exam info tab and instrument info tab then steal three table I will display the three tables record in one report in multi Ardell support okay now I'm gonna add report in that case exactly reporting before they can use report wizard name is our DLC report or not our DLC this is the report ok now I'm going to design this report to design this report go to the report data and click on Nino if you don't have report data just go to the View menu and click on report data will be added now click on new data set what I created there is that is it 1 and data source is my data set and you can see the all the table or added in the data set it said added in their report data so exam 2 exam info tab and add another table class info tab click on ok yes all the table added in the report data neither is it insert text box this text box I'll use 2 as a title of the report text is all in one do make it Center change the font size and font bold true okay now it's looking nice now I'm gonna add all these tables in this report in that case first first of all I will use to display student info so click my data set that is it one student name address and is this is from student info tab add new column insert column right yes contact ok now I'm going to add one more table click on table yes this table I'll use to display this second data set exam name and feel no need third column so delete this column yes and he says this column now I'm gonna add third table in this table I will display class info so that's it let us say three class ID and class name okay delete column and research this report all so now it's done double-click to go to the button button click event this event I will you write code to display report and it would be your okay private editable student info now data table DT equal to new data table now use SQL connection to connect project with the database SQL connection con equal to new SQL connection you should add namespace system the dead a dirt SQL plenteous this space is shaded ok now open the connection Condor open now add come on SQL command CMD equal to new SQL command my SQL command is select star from the student info tab this is the SQL table and click on OK now okay SQL data reader Rd equal to CM d dot execute reader now load Rd in DT DT dot load rd return DT ok it's done now I have to add connection string took a canister listing go to the solution of strand often the FV config file you can see the connection is string just select the connection string and coffee coffee this connection string right click - coffee yes it's coffee now first in the double connection in SQL connection okay now it's connected with the SQL Server database now just a select and coffee this method I have to write C method for student info examine for and class info this is for a student info now I just coffee it is for egg exam info this is X I mean for and this one is for class info okay now it's done now just change the command car nesting is same just change the command the X I mean from a third change the commands eggs I mean for tab and class info class info underscore tab okay now it's done now I'm going to write code in the bottom click event to load data in your crystal dip our DLC report and it would be you are ok report data source as student in four equals two new record editors add new space oh sorry s is a small letter so problem as it should be capital letter sources okay now add name is facing my reception reporting door - in this form just click it will add automatically and using my accept lottery putting buttons palm ok now it's done now at day one double quotation debt is it one my dad a city's debt is it one and that is it one is for student info you can see in their data can see it on you go to the reporter Dale City put you can see the data set one and two and three which I added in the reporters okay now just coffee you put that the church is 24 and rebooted is is two for class in for sorry for over 4x I mean for not assistant data set 2 is for examine phone just copy the method this is for exam info and report data chores this is that is a 3/4 class info equal to neo reporter teachers let us hit three this is for class info now in the method class info okay now you could viewer what I added in that one despawn application it would be your one dot local report dot day teachers dotted now add student on earth as d UD INF okay you can see and say miss he could be or 100 local to put attitudes dotted exam INF and closer in it finally he would be R 1 dot refresh report you should do refresh she put all the time to learn report pinout debug yes it's debugging just click on load o the choice of the report destiny definition has not been specified I have not specified the leak for destination so now add report destination I mean put location R DLC report location so he would be r1 dot local referred dot liquid that we put forth is my report forth is a report name this is the report one dot or DLC to get the path right click and click on property ok full this is the full forth just double click select all and copy you can use these pots G I can add at the rate and the starting up double quotation yes now it's solved the bag again now load report yes the report is displaying and loading for factly but this location full location is not perfect because if you want to use this application in different come different fish same inclined fish it then it will not get the exact location so I'll show you how to use a specific location without without food without mentioning the full location full directory ok now you can see and the report is displaying perfectly I click and click the body property field color color lime yes now click OK yes the report is now displaying colorful green color [Music] it's now fine multiple report is student info I examine flow and class intro all are displaying in single report okay now report but this is full fourth I will not use full fourth I will only use three four 200 earth are dlc so that if you if I use this application in different computer and client faces then it will show it should be okay but here you can see an error occurred during the local reported G icon you can see it's displaying the beam debug report 200 else it's are expecting the report in the debug folder of the application of the solution to display to load this report you should place this report worden dot our dlc file in the debug folder so this is the debug folder just click the report hundred LC and drag and drop it in the debug folder okay now you can see it will not displaying any error it will get that there are dlc report from the debug folder automatically so debug again load yes now it's working without instead of full fourth it's only a report name now lord but it's not displaying the source of the refer decision and definition is not found so comment out and comment yes the back again lowered yes it's displaying for factly

Channel: Swift Learn

Views: 17,830

Keywords: swift learn, display multiple reports in same report viewer, how to show multiple reports in single page, c# report viewer, rdlc subreport, rdl report in c#, rdlc, .rdlc, rdlc report, multiple report, display multiple report in rdlc, rdlc report in c#, rdlc report in c# with sql step by step, rdlc c# code, rdlc report in c# with sql server, display myltiple report, rdlc report in c# windows application

Id: 1Q8LWm4jx9o

Length: 17min 41sec (1061 seconds)

Published: Wed Jul 08 2020