SSRS 2016 Part 1 - Creating and Deploying Your First Report

By Andrew Gould
Download the script for the Movies 2016 database here www.wiseowl.co.uk/videos/sql2...
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can join this channel to get access to perks:
/ @wiseowltutorials
Or you can click this link www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!
This video gives an overview of creating and deploying a simple report using SQL Server Reporting Services 2016. The video is designed to give a basic guide to the process from start to finish (we'll save the details for later videos in this series) so that you can get up and running as easily as possible.
00:00 Topic list
01:03 What you need Checklist
03:05 Creating a Report Project
06:09 Adding a New Report
09:30 A Quick Tour of the Screen
12:37 Inserting and Formatting Report Items
16:19 Creating a Data Source
19:44 Creating a Dataset
24:40 Editing Data Sources and Datasets
25:44 Working with Tables and Columns
28:39 Formatting Tables
34:17 Sorting, Filtering and Table Headers
38:22 Setting the Report Server URL
43:08 Deploying the Report Project
45:28 Viewing Deployed Reports
50:22 Working with a Matrix and a Chart
57:24 Deploying a Single Report
Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, SQL Server, Reporting Services, Analysis Services, Integration Services, ASP.NET, C#, Visual Basic, Microsoft Access, Microsoft PowerPoint, Microsoft Word, Microsoft Project, Microsoft Publisher, Microsoft Visio and more

[@srt8216]

I haven't commented on any video, ever, but I made an exception for this one. The content has been explained quite exceptionally. Often, tutorial videos spend so much time at the beginning talking about themselves and their 'Visions' - this video has none of that. The presenter quickly starts working with the matter at hand and providing value for the viewer's time. The tools have also been explained with such ease, without dumb-ing it down too much. I have been working with SSRS for 3+ years, but was still engaged right till the end. Well done, sir! I am happy I ran into this channel and look forward to watching the other videos.

[@tyrellpremdutt5201]

Absolutely Agree. I also never commented on a video but this one... Excellent Presenter

[@MA-wv1fj]

Installed visual studio 2017, installed SSDT 2017, added SSRS, SSIS, SSAS, added data source, created report and deployed without any errors within 4 hours . Thank you so much for complete, easy and up to point video.

[@WiseOwlTutorials]

Great work, happy to help!

[@TsiriniainaRakotonirina]

I really blame KZbin for this Video! *KZbin, the Blue Thumbs is not enought to appreciate the quality of Content of this Video. We need more!* There is no word to appreciate how beautiful is your video: - The explanation is very detailed - The pace is enough for one to learn from scratch the topic even if we never heard of it - The approach of changing and running the Preview everytime is amazingly pedagogic and perfect. It helps us to know what was changed and what is its impact - I thought I knew Visual Studio, as I worked with it since 2006, but today, in 2020, I learnt that I was wrong. You are a marvelous trainer. And you deserve much much more subscribers. This is exactly why KZbin exists. God bless you brother! I'm here in South Africa as well and you are making our Country proud of you👍🏼🙌🏼

[@Yor6ure]

Truly a wise Owl, you are a natural teacher. Well explained and thorough lesson.

[@rugwizainnocent1881]

very rare to watch this for free.From my experience, u can have it here only. Thank you 1000 times

[@karanmachendranath7162]

The presenter's demonstration is so thorough and accentuates on all the points.Thank's a lot man

[@bhavyaramgiri9396]

Reportle..its brilliant 😄 Watching this for second time. Worth it

[@WiseOwlTutorials]

😀 thanks Bhavya!

[@gideon17you]

This video is on the money. Thank you WiseOwl. You are really wise. You have just made my life easier.

[@giuliko]

Hey friend, I'm gonna start my sql studies from your videos. You're awesome. Thanks a lot.

[@mrrustygray]

There are many free courses on SQL at www.udemy.com as well. It is a good resource for many of the business intelligence programs.

[@adrianomorrison2]

Thanks a lot. I am brazilian. I like your videos. Very good.

[@WiseOwlTutorials]

Obrigado Adriano, thank you for watching!

[@mib910]

I have rarely seen such as very well explained and presented tutorial, congrats and thank you :)

[@mondlimkhanyiswa1206]

Thanks man, from South Africa we thank you for this video. Been having issues on how to go about solving this local reporting services problem, looked at other people's solutions, none of them worked until this one. Highly appreciated man. Thanks

[@WiseOwlTutorials]

Hi Mondli, I'm really happy to hear this one helped you out! And thanks for taking the time to leave a comment, it's much appreciated!

[@heathermari83]

Thank you for being so clear and concise in your explanations of how to in each of your videos... So helpful and this is my favorite "go to" for when I need a brush up on my SSRS skills. Thank you so much for helping us to perfect our skills!

[@saikumaryadav8515]

Hii, I'm trying to learn MSBI

[@nahomassefa6210]

All I could say is; You're just Amazing!

[@dougkampe6117]

We recently moved from SQL Server 208 r2 to 2016 and I'm migrating my old reports. I forgot some of the steps, but this video was extremely helpful (and current)! Thanks!

[@2k6jayesh]

Brilliant Tutorial. Very easy to understand format. Been trying to learn SSRS for a while now , i wish i found this gem earlier. Will be watching the rest of the videos in this series , Thank you so much :)

[@ahmadsaeed3166]

you are awesome sir, it took me 2 days to deploy my first project and it all happened after watching this video the only thing i was missing to run visual studio as an administrator.

[@meanomine4995]

This was an excellent, top-notch tutorial - you are a gifted teacher. Thank you for sharing your time and knowledge with us.

[@WiseOwlTutorials]

Thank you so much for watching!

[@yehudabadihi9844]

Listen, listen to me well, look, I do not know who you are, Mr. Lecturer, but, I have never encountered such a good online teacher. And I've been through a lot of online tutorials in my life. That's it. I had to stop in the middle and give that feedback. Now I can go back continue the lesson.

[@maeluu835]

Amazing! Thank you so much for delivering such valuable training videos.

[@WilliamCase]

Fantastic series. Thanks so much. Your demonstration style is superb.

[@vantagefreightsolutions1234]

Really good refresher video on SSRS Thank you very soft spoken and easy to follow

[@WiseOwlTutorials]

Thanks! Happy to hear that it helped!

[@toulasantha]

This is gold. Flawless delivery 👏👏👏

[@WiseOwlTutorials]

Thanks! Happy to hear you enjoyed it and thank you for watching!

[@yoshiyaouchi5216]

I wish you were my high school math teacher! Your explanation and presentation in this video is top-notch!

[@engineering_music]

As always, WiseOwl tutors are amazing speakers and very knowledgeable. Loved the video was very apprehensive about SSRS but your video made it so easy and I am confident now to create my own. Already subscribed.

[@raghud541]

Excellent explanation. i had exposure to SSRS but without knowledge, this video really helped me to understand the fundamentals very well,thanks a lot.

[@yeshwanthmanellore]

Very useful video for beginners. Thank you for your effort.

[@WiseOwlTutorials]

You're very welcome, thanks for watching!

[@maziyarrazmjou4061]

Awesome videos for everyone that needs to SSRS, really i appreciate it. thanks mate

[@kalicharankhetwal]

Hi Andrew, You have been a very good teacher.Thanks a lot for this tutorial.

[@ErikaMartinez-jn7ry]

very helpful. I was searching for a simple, and clear tutorial to start to make a report.

[@TavandtheTadpole]

Thank you very much. I had an urgent report to build in SSRS for work today and had no prior knowledge of SSRS. We managed to get a report out to the business in time.

[@WiseOwlTutorials]

Happy to hear that, Seth! Thanks for taking the time to leave a comment and for watching!

[@satyagarapati3611]

Great job!!. This video refreshed my reporting knowledge quickly and easily. Thank you.

[@PatrickQuijano]

I like the way you presented the tutorial. Very easy to learn. Thank you very much! Kudos to you!

[@ajijacob1]

Excellent video Andrew. Greater refresher..

[@haitianchick5091]

Love, love it! Good refresher for me👍🏽👍🏽

[@krismaly6300]

Indeed

[@vijaykumarpatki9278]

Fantastic coverage and presentation. You covered a lot mate in this video. I used it today to revise my SSRS skill. Good on you.

[@WiseOwlTutorials]

Thanks! Happy to hear that you found it useful and thank you for watching!

[@wooh88]

As always, The best tutorials on KZbin ! Thanks,

[@humayunhimu6045]

Pretty awesome tutorial for learning SSRS

[@WiseOwlTutorials]

Thanks, happy to hear that you liked it!

[@ros6089]

Bravo! A brilliant tutorial that worked perfectly! Excellent explanations and a pleasant voice.

[@hassanalsoltan2543]

Fantastic... One of the best i have seen. So clear, concise and to the point.

[@WiseOwlTutorials]

Thank you for the kind words Hassan!

[@helloworld-sr4qj]

Really perfect tutorial for beginners. It's detailed and clear!

[@kevinwenrick7657]

Very well done. This s a great quick overview, really easy to follow even in high speed time ;-)

[@kamjobmail]

i don't think there is a youtube playlist for this... not a biggie... good stuff. thanks for all your good work. i learned alot from your vba stuff already. now I am starting this one....

[@jezb7535]

Thank you. Great tutorial. Very clear and easy to follow.

[@klazim2000]

after 2 min of watching i knew ur one of the best.

[@michaelshepherdmunemo4414]

Thank you for a well detailed presentation

[@WiseOwlTutorials]

You're very welcome Michael, thanks for watching!

[@bhavyaramgiri9396]

Amazing tutorial, have covered all topics in an hour. Thank you so much. Again...this is an amazing tutorial.

[@WiseOwlTutorials]

My pleasure Bhavya, I'm glad you found it helpful and thank you for watching!

[@mike060187]

Great tutorial and well thought out!

[@unicomp5705]

GREAT PLAYLIST!!!! I will primarily use this report designer to embed reports in Desktop apps and Web apps using the ReportViewer control and Visual Studio, :-) Mike in LA, Calif, USA

[@johnnybarideaux1079]

Awesome training video!

[@TheFullDegeneration]

Clearly, quickly, understandably. Thank you.

[@dajim6]

Thanks! Excellent video

[@rvallamneni]

Excellent stuff, very useful for beginners like me. Thanks a ton for the video.

[@fazalrahman476]

wow, the best tutorial I seen so far :)))

[@MrBp2404]

Good job my friend!

[@abhinavkumar8271]

Very Good start..I'm following @WiseOwlTutorials. Please don't stop in mid.

[@abhinavkumar8271]

It's very good to know.

[@imadabab]

7 Stars Tutorial. Thanks a lot. I already subscribed long time ago.

[@WiseOwlTutorials]

Thank you so much, I appreciate that!

[@imadabab]

Thanks for your efforts dear.

[@richardekeopara886]

Thanks very much, Andrew. Awesome tutorial and simple presentation.

[@WiseOwlTutorials]

You're very welcome Richard, thanks for watching!

[@danielleandre8320]

Excellent video.. Big fan of your teaching

[@nelsonthekinger]

Great instructor, a lot of energy :))) Thanks!

[@oscarayang9825]

Very helpful. Nice one mate. Thanks

[@DayneTraje]

Awesome work!

[@samytheslammer]

That was very helpful. Thank you for making such a great tutorial.

[@WiseOwlTutorials]

You're very welcome, happy to hear that you found it useful and thanks for watching!

[@IshaSiri]

Gr8 Video. It saved lots of time to learn SSRS :)

[@revolution4u]

You're awesome. Thank you my best teacher

[@atifuddin3601]

Good work sir👍🏻

[@zanelentombela8284]

You are the best!!! Thank you so much!!

[@alisafi3704]

Thanks a lot !!! Excellent videos

[@Bulollas]

Very straight instructions and super clear!

[@WiseOwlTutorials]

Thanks Roberto!

[@maksympt1]

Very good video and explanation. Thanks

[@MarkKennethSuyat]

wow thanks so much for this video. very clear and straightforward...

[@bharathchinta]

Very Helpful videos. Thanks

[@santoshkothapalli]

very well explained. Simple.

[@ibrahimallam165]

Thank you for this amazing tutorial!!

[@WiseOwlTutorials]

You're very welcome, Ibrahim, thank you for watching!

[@rohidaskumbharkar1070]

Good Present, easy to understand Create and deployment the Report. Thanks

[@karthikreddy7713]

Nice Presentation, Thank you

[@vladbakman4416]

Thank you very much for such great video. Indeed exceptional and usefull

[@KBCrazy2674]

Very well explained , Thanks

[@WiseOwlTutorials]

Thanks!

[@mzonerz]

Best explanation.

[@klgyal2010]

Very helpful video, thank-you :)

[@kenkeating299]

thanks. great video.

[@itsmeforsure5475]

well done, bravo!!

[@AM-nn8xn]

Best on KZbin*****

[@gracexing5509]

good teacher. I like the video . thank you so much

[@WiseOwlTutorials]

You're very welcome Grace, I'm happy that you enjoyed it!

[@pankajrana1008]

Thanks for your good work

[@WiseOwlTutorials]

You're very welcome, thanks for watching and taking the time to leave a comment!

[@JeewakaKarunaratne]

love you man. great

[@WiseOwlTutorials]

Thank you!

[@benyams8014]

THANK YOU SO MUCH

[@zoomcam7706]

GREAT TUTORIAL...CONGRATS

[@WiseOwlTutorials]

Thanks!

[@suvradeepbanerjee6801]

Thank you so much!

[@WiseOwlTutorials]

You're very welcome Suvradeep, thank you for watching!

[@daviddavid7325]

Indeed, this was a very good tutorial. I will even donate a few bucks.

[@helloworld8201]

Good job man

[@linuxmq3945]

That is what I call worth watching! Thank you for a very clear tutorial.

[@prolific9002]

Excellent Tutorial. Maybe even exceptional.

[@WiseOwlTutorials]

Thanks! Happy to hear that you enjoyed it, thanks for watching and taking the time to leave a comment!

[@pankajarora5774]

Very nicely explained. Well done and I like the word reportal. Lol

[@kyrgyzaly]

Very Very Good!

[@denverli2008]

it is super helpful.thanks

[@WiseOwlTutorials]

You're very welcome, Mehmet. Thanks for watching!

[@hichambennani9477]

Nice video. thanks

[@CookingScripts]

thank you.

[@WiseOwlTutorials]

You're very welcome!

[@swapnilkale8339]

Thank you so much

[@WiseOwlTutorials]

You're very welcome, thanks for watching!

[@muhammedali5059]

Thank you very much ;