SSRS 2016 Part 1 - Creating and Deploying Your First Report

แชร์
ฝัง
  • เผยแพร่เมื่อ 25 ธ.ค. 2024

ความคิดเห็น • 204

  • @MA-wv1fj
    @MA-wv1fj 3 ปีที่แล้ว +3

    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.

  • @srt8216
    @srt8216 7 ปีที่แล้ว +62

    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
      @tyrellpremdutt5201 4 ปีที่แล้ว +1

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

  • @karanmachendranath7162
    @karanmachendranath7162 5 ปีที่แล้ว +1

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

  • @rugwizainnocent1881
    @rugwizainnocent1881 5 ปีที่แล้ว +1

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

  • @TsiriniainaRakotonirina
    @TsiriniainaRakotonirina 4 ปีที่แล้ว +2

    I really blame TH-cam for this Video! *TH-cam, 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 TH-cam exists.
    God bless you brother!
    I'm here in South Africa as well and you are making our Country proud of you👍🏼🙌🏼

  • @Yor6ure
    @Yor6ure 4 ปีที่แล้ว +5

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

  • @mondlimkhanyiswa1206
    @mondlimkhanyiswa1206 5 ปีที่แล้ว +2

    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
      @WiseOwlTutorials  5 ปีที่แล้ว

      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!

  • @vantagefreightsolutions1234
    @vantagefreightsolutions1234 2 ปีที่แล้ว +1

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

  • @meanomine4995
    @meanomine4995 ปีที่แล้ว +1

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

  • @ahmadsaeed3166
    @ahmadsaeed3166 5 ปีที่แล้ว

    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.

  • @toulasantha
    @toulasantha 2 ปีที่แล้ว +1

    This is gold. Flawless delivery 👏👏👏

    • @WiseOwlTutorials
      @WiseOwlTutorials  2 ปีที่แล้ว +1

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

  • @yehudabadihi9844
    @yehudabadihi9844 4 ปีที่แล้ว +1

    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.

  • @bhavyaramgiri9396
    @bhavyaramgiri9396 2 ปีที่แล้ว

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

  • @TavandtheTadpole
    @TavandtheTadpole 4 ปีที่แล้ว +1

    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
      @WiseOwlTutorials  4 ปีที่แล้ว

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

  • @hassanalsoltan2543
    @hassanalsoltan2543 3 ปีที่แล้ว +1

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

  • @vijaykumarpatki9278
    @vijaykumarpatki9278 2 ปีที่แล้ว +1

    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
      @WiseOwlTutorials  2 ปีที่แล้ว

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

  • @GSoftagon
    @GSoftagon 6 ปีที่แล้ว +2

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

  • @kamjobmail
    @kamjobmail 7 ปีที่แล้ว

    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....

  • @yoshiyaouchi5216
    @yoshiyaouchi5216 4 ปีที่แล้ว +1

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

  • @giuliko
    @giuliko 8 ปีที่แล้ว +14

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

    • @mrrustygray
      @mrrustygray 7 ปีที่แล้ว +1

      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.

  • @heathermari83
    @heathermari83 5 ปีที่แล้ว +2

    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!

  • @dougkampe6117
    @dougkampe6117 7 ปีที่แล้ว

    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!

  • @mib910
    @mib910 5 ปีที่แล้ว +6

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

  • @ErikaMartinez-jn7ry
    @ErikaMartinez-jn7ry 7 ปีที่แล้ว

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

  • @richardekeopara886
    @richardekeopara886 3 ปีที่แล้ว +1

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

    • @WiseOwlTutorials
      @WiseOwlTutorials  3 ปีที่แล้ว

      You're very welcome Richard, thanks for watching!

  • @raghud541
    @raghud541 4 ปีที่แล้ว

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

  • @adrianomorrison2
    @adrianomorrison2 3 ปีที่แล้ว +1

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

    • @WiseOwlTutorials
      @WiseOwlTutorials  3 ปีที่แล้ว

      Obrigado Adriano, thank you for watching!

  • @unicomp5705
    @unicomp5705 5 ปีที่แล้ว

    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

  • @klazim2000
    @klazim2000 5 ปีที่แล้ว

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

  • @bhavyaramgiri9396
    @bhavyaramgiri9396 3 ปีที่แล้ว +1

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

    • @WiseOwlTutorials
      @WiseOwlTutorials  3 ปีที่แล้ว

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

  • @2k6jayesh
    @2k6jayesh 4 ปีที่แล้ว

    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 :)

  • @yeshwanthmanellore
    @yeshwanthmanellore 3 ปีที่แล้ว +1

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

    • @WiseOwlTutorials
      @WiseOwlTutorials  3 ปีที่แล้ว

      You're very welcome, thanks for watching!

  • @abhinavkumar8271
    @abhinavkumar8271 8 ปีที่แล้ว

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

  • @ros6089
    @ros6089 4 ปีที่แล้ว

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

  • @nahomassefa6210
    @nahomassefa6210 6 ปีที่แล้ว +5

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

  • @maziyarrazmjou4061
    @maziyarrazmjou4061 7 ปีที่แล้ว

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

  • @engineering_music
    @engineering_music 8 ปีที่แล้ว

    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.

  • @humayunhimu6045
    @humayunhimu6045 ปีที่แล้ว +1

    Pretty awesome tutorial for learning SSRS

  • @helloworld-sr4qj
    @helloworld-sr4qj 7 ปีที่แล้ว

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

  • @PatrickQuijano
    @PatrickQuijano 5 ปีที่แล้ว

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

  • @kalicharankhetwal
    @kalicharankhetwal 6 ปีที่แล้ว +2

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

  • @WilliamCase
    @WilliamCase 7 ปีที่แล้ว

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

  • @Bulollas
    @Bulollas 5 ปีที่แล้ว +1

    Very straight instructions and super clear!

  • @imadabab
    @imadabab 3 ปีที่แล้ว +1

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

    • @WiseOwlTutorials
      @WiseOwlTutorials  3 ปีที่แล้ว

      Thank you so much, I appreciate that!

    • @imadabab
      @imadabab 3 ปีที่แล้ว +1

      Thanks for your efforts dear.

  • @michaelshepherdmunemo4414
    @michaelshepherdmunemo4414 2 ปีที่แล้ว +1

    Thank you for a well detailed presentation

    • @WiseOwlTutorials
      @WiseOwlTutorials  2 ปีที่แล้ว

      You're very welcome Michael, thanks for watching!

  • @maeluu835
    @maeluu835 7 ปีที่แล้ว +1

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

  • @TheFullDegeneration
    @TheFullDegeneration 7 ปีที่แล้ว

    Clearly, quickly, understandably. Thank you.

  • @wooh88
    @wooh88 7 ปีที่แล้ว

    As always, The best tutorials on TH-cam ! Thanks,

  • @ajijacob1
    @ajijacob1 7 ปีที่แล้ว

    Excellent video Andrew. Greater refresher..

  • @danielleandre8320
    @danielleandre8320 8 ปีที่แล้ว

    Excellent video.. Big fan of your teaching

  • @kevinwenrick7657
    @kevinwenrick7657 6 ปีที่แล้ว +1

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

  • @daviddavid7325
    @daviddavid7325 7 ปีที่แล้ว

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

  • @fazalrahman476
    @fazalrahman476 7 ปีที่แล้ว +1

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

  • @CookingScripts
    @CookingScripts 3 ปีที่แล้ว +2

    thank you.

  • @satyagarapati3611
    @satyagarapati3611 6 ปีที่แล้ว

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

  • @haitianchick5091
    @haitianchick5091 8 ปีที่แล้ว +3

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

  • @suvradeepbanerjee6801
    @suvradeepbanerjee6801 3 ปีที่แล้ว +1

    Thank you so much!

    • @WiseOwlTutorials
      @WiseOwlTutorials  3 ปีที่แล้ว +1

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

  • @denverli2008
    @denverli2008 4 ปีที่แล้ว +1

    it is super helpful.thanks

    • @WiseOwlTutorials
      @WiseOwlTutorials  4 ปีที่แล้ว

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

  • @rvallamneni
    @rvallamneni 6 ปีที่แล้ว

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

  • @MarkKennethSuyat
    @MarkKennethSuyat 4 ปีที่แล้ว

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

  • @maksympt1
    @maksympt1 4 ปีที่แล้ว

    Very good video and explanation. Thanks

  • @jezb7535
    @jezb7535 6 ปีที่แล้ว

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

  • @prolific9002
    @prolific9002 5 ปีที่แล้ว +1

    Excellent Tutorial. Maybe even exceptional.

    • @WiseOwlTutorials
      @WiseOwlTutorials  5 ปีที่แล้ว

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

  • @KBCrazy2674
    @KBCrazy2674 3 ปีที่แล้ว +1

    Very well explained , Thanks

  • @linuxmq3945
    @linuxmq3945 6 ปีที่แล้ว

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

  • @vladbakman4416
    @vladbakman4416 4 ปีที่แล้ว

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

  • @IshaSiri
    @IshaSiri 6 ปีที่แล้ว +1

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

  • @gracexing5509
    @gracexing5509 3 ปีที่แล้ว +1

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

    • @WiseOwlTutorials
      @WiseOwlTutorials  3 ปีที่แล้ว

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

  • @samytheslammer
    @samytheslammer 5 ปีที่แล้ว +1

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

    • @WiseOwlTutorials
      @WiseOwlTutorials  5 ปีที่แล้ว

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

  • @santoshkothapalli
    @santoshkothapalli 4 ปีที่แล้ว

    very well explained. Simple.

  • @rohidaskumbharkar1070
    @rohidaskumbharkar1070 7 ปีที่แล้ว

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

  • @pankajrana1008
    @pankajrana1008 4 ปีที่แล้ว +1

    Thanks for your good work

    • @WiseOwlTutorials
      @WiseOwlTutorials  4 ปีที่แล้ว

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

  • @ThrivolousZ
    @ThrivolousZ 2 ปีที่แล้ว

    Excellent video. Setup is VERY crucial though and just an update - I didn't find the template under Business Intelligence although once I installed SSRS it was there in Visual Studio 2017, directly under Reporting Services. It's 2022 and things have changed so if you are stuck reach out and I can share what I did for the setup. Excited to go through this tutorial though.

    • @WiseOwlTutorials
      @WiseOwlTutorials  2 ปีที่แล้ว

      Hi Aaron! Thanks for the offer but we already have videos which show how to install Reporting Services templates for both Visual Studio 2017 and 2019 which you can see in this playlist th-cam.com/play/PLNIs-AWhQzcmn2xNYQu8ahIVHobCJSEbq.html
      I hope it helps!

    • @ThrivolousZ
      @ThrivolousZ 2 ปีที่แล้ว +1

      @@WiseOwlTutorials Well there ya go. I'll go check it out. :).

    • @WiseOwlTutorials
      @WiseOwlTutorials  2 ปีที่แล้ว

      @@ThrivolousZ No problem Aaron, I hope it's useful!

  • @zoomcam7706
    @zoomcam7706 2 ปีที่แล้ว +1

    GREAT TUTORIAL...CONGRATS

  • @mchittaj
    @mchittaj 4 ปีที่แล้ว +1

    Awesome explanation, thanks, can you please show how to do a drill down on reports like click the genre and see what movies were in that genre

    • @WiseOwlTutorials
      @WiseOwlTutorials  4 ปีที่แล้ว +1

      Thanks Mithun! We do have a video on drill through in SSRS th-cam.com/video/1f7jHrtfhp0/w-d-xo.html It's from an older series of videos but the technique is still the same in modern versions of SSRS.
      I hope that helps!

    • @mchittaj
      @mchittaj 4 ปีที่แล้ว

      WiseOwlTutorials thanks a lot, can we do a line and bar chart in same chart ?

  • @revolution4u
    @revolution4u 5 ปีที่แล้ว

    You're awesome. Thank you my best teacher

  • @dajim6
    @dajim6 6 ปีที่แล้ว +1

    Thanks! Excellent video

  • @mike060187
    @mike060187 6 ปีที่แล้ว +1

    Great tutorial and well thought out!

  • @JeewakaKarunaratne
    @JeewakaKarunaratne 3 ปีที่แล้ว +1

    love you man. great

  • @ibrahimallam165
    @ibrahimallam165 5 ปีที่แล้ว +1

    Thank you for this amazing tutorial!!

    • @WiseOwlTutorials
      @WiseOwlTutorials  5 ปีที่แล้ว

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

  • @mashegorampedi3295
    @mashegorampedi3295 2 หลายเดือนก่อน +1

    Worth it.

  • @oscarayang9825
    @oscarayang9825 6 ปีที่แล้ว

    Very helpful. Nice one mate. Thanks

  • @nelsonthekinger
    @nelsonthekinger 7 ปีที่แล้ว

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

  • @prabhusundararajinspired
    @prabhusundararajinspired 7 ปีที่แล้ว

    Awesome!! what are the new feature added in 2016 SSRS?

    • @prabhusundararajinspired
      @prabhusundararajinspired 7 ปีที่แล้ว

      Thank you so much !!! very useful content "www.wiseowl.co.uk/blog/s2503/ssrs-2016-new.htm"

  • @swapnilkale8339
    @swapnilkale8339 3 ปีที่แล้ว +1

    Thank you so much

    • @WiseOwlTutorials
      @WiseOwlTutorials  3 ปีที่แล้ว

      You're very welcome, thanks for watching!

  • @tomhagedorn1674
    @tomhagedorn1674 7 ปีที่แล้ว

    Very good videos. is there a way to pass parameters directly to a dataset? looking for use in the where clause rather than as a dataset filter.

  • @cencom01
    @cencom01 5 ปีที่แล้ว +2

    Great work on this series! Extremely useful. Question, I created my first report using a from date and end date perimeter. Do you go over how to show the from and end dates as part of the header of the printed report so people would know the date range that was run?

    • @WiseOwlTutorials
      @WiseOwlTutorials  5 ปีที่แล้ว +1

      Hi there, the easiest way to do this is to drag the parameter from the Report Data window into the header section of the report. I hope that helps!

  • @sadenlav
    @sadenlav 4 ปีที่แล้ว

    Dear Mr.
    Do you know how to add a crystal report with the Server report service?

  • @tiago5a
    @tiago5a 2 ปีที่แล้ว

    which is better to build a report? The Visual Studio or the Report Builder?

  • @bharathchinta
    @bharathchinta 7 ปีที่แล้ว

    Very Helpful videos. Thanks

  • @shaileshsingh8906
    @shaileshsingh8906 4 ปีที่แล้ว

    well very nice explainantion ,thanks

  • @tgroves4831
    @tgroves4831 4 ปีที่แล้ว

    Can you add a report like this to SSMS Custom Reports?

  • @fadwa2413
    @fadwa2413 3 ปีที่แล้ว

    what do I need to be good at SSIS and DataWareHouse?

  • @lcmarcosr
    @lcmarcosr 4 ปีที่แล้ว

    Great video!!! Is any way to set the totals for an invoice at the end of the page using ssrs report? If I put it on the footer with a visible condition in the last page, the footer height in the first pages are quit huge with the blank space of the totals not display. Thx in advance

  • @MrBp2404
    @MrBp2404 6 ปีที่แล้ว +1

    Good job my friend!

  • @atifuddin3601
    @atifuddin3601 7 ปีที่แล้ว +1

    Good work sir👍🏻

  • @charmeleon10
    @charmeleon10 4 ปีที่แล้ว

    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?

  • @farhanakhan1348
    @farhanakhan1348 5 ปีที่แล้ว +1

    You are too good!

  • @muchaim2275
    @muchaim2275 5 ปีที่แล้ว

    What is SSRS for given pivot charts, pivot tables, and Power BI? Is it necessary? Are executives expected to understand how to use this service just to see charts and tables? SSIS seems to do what Power Query does. SSAS = Power Pivot so what are these tools for anymore?

  • @zanelentombela8284
    @zanelentombela8284 6 ปีที่แล้ว

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