SSRS 2016 Part 1 - Creating and Deploying Your First Report
Vložit
- čas přidán 5. 08. 2024
- 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
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.
Absolutely Agree. I also never commented on a video but this one... Excellent Presenter
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.
Great work, happy to help!
I really blame CZcams for this Video! *CZcams, 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 CZcams exists.
God bless you brother!
I'm here in South Africa as well and you are making our Country proud of you👍🏼🙌🏼
very rare to watch this for free.From my experience, u can have it here only. Thank you 1000 times
The presenter's demonstration is so thorough and accentuates on all the points.Thank's a lot man
Truly a wise Owl, you are a natural teacher. Well explained and thorough lesson.
This video is on the money. Thank you WiseOwl. You are really wise. You have just made my life easier.
I have rarely seen such as very well explained and presented tutorial, congrats and thank you :)
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 :)
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!
Hii, I'm trying to learn MSBI
Hey friend, I'm gonna start my sql studies from your videos. You're awesome. Thanks a lot.
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.
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.
I wish you were my high school math teacher! Your explanation and presentation in this video is top-notch!
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
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!
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!
Amazing! Thank you so much for delivering such valuable training videos.
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.
All I could say is; You're just Amazing!
Fantastic series. Thanks so much. Your demonstration style is superb.
Excellent explanation. i had exposure to SSRS but without knowledge, this video really helped me to understand the fundamentals very well,thanks a lot.
very helpful. I was searching for a simple, and clear tutorial to start to make a report.
Hi Andrew, You have been a very good teacher.Thanks a lot for this tutorial.
Great job!!. This video refreshed my reporting knowledge quickly and easily. Thank you.
Awesome videos for everyone that needs to SSRS, really i appreciate it. thanks mate
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.
I like the way you presented the tutorial. Very easy to learn. Thank you very much! Kudos to you!
As always, The best tutorials on CZcams ! Thanks,
This was an excellent, top-notch tutorial - you are a gifted teacher. Thank you for sharing your time and knowledge with us.
Thank you so much for watching!
Very well done. This s a great quick overview, really easy to follow even in high speed time ;-)
Bravo! A brilliant tutorial that worked perfectly! Excellent explanations and a pleasant voice.
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.
Happy to hear that, Seth! Thanks for taking the time to leave a comment and for watching!
Reportle..its brilliant 😄 Watching this for second time. Worth it
😀 thanks Bhavya!
Excellent video Andrew. Greater refresher..
Really perfect tutorial for beginners. It's detailed and clear!
Love, love it! Good refresher for me👍🏽👍🏽
Indeed
Thank you. Great tutorial. Very clear and easy to follow.
after 2 min of watching i knew ur one of the best.
This is gold. Flawless delivery 👏👏👏
Thanks! Happy to hear you enjoyed it and thank you for watching!
Really good refresher video on SSRS Thank you very soft spoken and easy to follow
Thanks! Happy to hear that it helped!
Excellent stuff, very useful for beginners like me. Thanks a ton for the video.
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....
Clearly, quickly, understandably. Thank you.
Fantastic coverage and presentation. You covered a lot mate in this video. I used it today to revise my SSRS skill. Good on you.
Thanks! Happy to hear that you found it useful and thank you for watching!
Great tutorial and well thought out!
Fantastic... One of the best i have seen. So clear, concise and to the point.
Thank you for the kind words Hassan!
Thanks! Excellent video
Amazing tutorial, have covered all topics in an hour. Thank you so much. Again...this is an amazing tutorial.
My pleasure Bhavya, I'm glad you found it helpful and thank you for watching!
wow, the best tutorial I seen so far :)))
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
Awesome training video!
Great instructor, a lot of energy :))) Thanks!
Very helpful. Nice one mate. Thanks
That was very helpful. Thank you for making such a great tutorial.
You're very welcome, happy to hear that you found it useful and thanks for watching!
Excellent video.. Big fan of your teaching
Gr8 Video. It saved lots of time to learn SSRS :)
Very good video and explanation. Thanks
Thanks a lot.
I am brazilian. I like your videos. Very good.
Obrigado Adriano, thank you for watching!
Good job my friend!
Awesome work!
You're awesome. Thank you my best teacher
Thanks very much, Andrew. Awesome tutorial and simple presentation.
You're very welcome Richard, thanks for watching!
very well explained. Simple.
Very Good start..I'm following @WiseOwlTutorials. Please don't stop in mid.
It's very good to know.
Good Present, easy to understand Create and deployment the Report. Thanks
Thanks a lot !!! Excellent videos
wow thanks so much for this video. very clear and straightforward...
You are the best!!! Thank you so much!!
Very useful video for beginners. Thank you for your effort.
You're very welcome, thanks for watching!
Very Helpful videos. Thanks
That is what I call worth watching! Thank you for a very clear tutorial.
Very helpful video, thank-you :)
Good work sir👍🏻
Thank you very much for such great video. Indeed exceptional and usefull
Very straight instructions and super clear!
Thanks Roberto!
Thank you for a well detailed presentation
You're very welcome Michael, thanks for watching!
Thank you for this amazing tutorial!!
You're very welcome, Ibrahim, thank you for watching!
Nice Presentation, Thank you
Pretty awesome tutorial for learning SSRS
Thanks, happy to hear that you liked it!
Very well explained , Thanks
Thanks!
Very nicely explained. Well done and I like the word reportal. Lol
Indeed, this was a very good tutorial. I will even donate a few bucks.
thanks. great video.
well done, bravo!!
Best explanation.
Best on CZcams*****
GREAT TUTORIAL...CONGRATS
Thanks!
Thanks for your good work
You're very welcome, thanks for watching and taking the time to leave a comment!
7 Stars Tutorial. Thanks a lot. I already subscribed long time ago.
Thank you so much, I appreciate that!
Thanks for your efforts dear.
love you man. great
Thank you!
Thank you so much!
You're very welcome Suvradeep, thank you for watching!
it is super helpful.thanks
You're very welcome, Mehmet. Thanks for watching!
Very Very Good!
Good job man
Hey can anyone help me in letting know where .rdl file is deployed on the server
well very nice explainantion ,thanks
THANK YOU SO MUCH
Nice video. thanks
good teacher. I like the video . thank you so much
You're very welcome Grace, I'm happy that you enjoyed it!
Excellent Tutorial. Maybe even exceptional.
Thanks! Happy to hear that you enjoyed it, thanks for watching and taking the time to leave a comment!
Thank you very much for your very informative video and series.
I have a question though: If I want to deploy the report to multiple report servers, each of them in different networks, and I don't want to manually change anything in the actual report properties (So I could just pull the report from a repository and deploy it with no changes) is it possible to indicate a path to a variable in a local file that contains the correct URL rather than specifying the URL in report properties?