SSRS 2016 - Comparing Report Builder with SQL Server Data Tools

[@Exanji89]

You are honestly the best teacher I have ever come across, in school or online. I see you haven't uploaded videos on your KZbin channel in a long time, I assume you're busy with your company. Hopefully you'll come back to KZbin eventually, you are an AMAZING teacher.

[@gerharddewit4872]

Along with other people I want to agree: You truly added value in this video and even among the others videos of yours that I have seen. This tutorial is fairly outstanding. Thank you.

[@WiseOwlTutorials]

Thank you, Gerhard!

[@AV-uv3jz]

Really great teaching style here. All videos in the SSRS series have been amazing and enough repetition done throughout vids to drill in the learning. Voice / speed / pitch is perfect. Thank you so much for uploading these have helped a lot.

[@WiseOwlTutorials]

Thanks so much for the kind comments and for watching!

[@krismaly6300]

OMG! This another long and very good video. Especially Reports Developer must watch. The Host is an Expert in MS SQL & Reports. His tone of teaching is so good anybody can listen and learn very fast I have watched several videos in this WiseOwl site they are all very good for learning and i think the way they teach is very good. In this video Comparing Report Builder and SSDT is awesome. I honestly recommend others to watch not only this video look for other videos too. Thanks for educating the community and appreciate your volunteer ship. God Bless you. Thanks a bunch

[@krismaly6300]

A person can be a very good teacher He who loves teaching and He who knows the subject You have both qualities Please please please keep teaching and make the world highly knowledgeable Do your duty rest live it to... I love your approach and teaching and I learned a lot from you I salute you God bless you

[@grantwilliams9838]

A brilliant presentation with everything I needed to know and get started. Thanks to the Wise Owl crew for putting together a really helpful presentation.

[@the72u7h4]

The fun part about SSRS is installing VS then the data tools to get reporting services enabled within VS so you can create a reporting services project. That crap took me about 4 attempts to get it sorted out.

[@chencholon]

gracias, hasta ahora eres el primero en hacer estos tutoriales completos, me ayudo avanzar mas en mi servidor de reportes que tengo, gracias

[@WiseOwlTutorials]

You're very welcome, thank you for watching!

[@SrikanthYellow]

This is a brilliant guide for SSRS newbies like me. Thanks for this valuable tutorial

[@KhemitPrince]

Thank you very much. I recently embarked on a project to do reports from mysql and this video came in the nick of time when I was wondering which platform to utilize. Great presentation, thank you.

[@jccviking]

Thank you, thank you, thank you for a wonderfully complete and easy to follow tutorial. I write software for a living and although I'm pretty conversant with SQL Server databases, I've never used the reporting services. However, I've just been assigned a project that will require them. Your tutorial gave me the base knowledge I needed to get started. Note: I viewed a few others before I found yours. All I can say is ugh! You probably already know this but, the latest version of the RDL report designer for Visual Studio does not offer the intuitive relationship defining as shown in your video. Version 2.0 matches the Report Builder's more awkward one. No problem though because I can to use the use the SSMS Query Designer and copy the SQL into the report designer. Anyway, thanks again for a great tutorial.

[@mau_lopez]

What an excellent tutorial !

[@WiseOwlTutorials]

Thanks! Glad you liked it and thanks for the comment!

[@alxvseti]

07:20 Creating a New Report or Report Project 11:10 Creating Data Sources 49:12 Opening the Web Portal 51:41 Deploying Reports from Report Builder 55:20 Deploying a Report Server Project 1:00:01 A Brief Summary

[@Mfbzai]

You are Hero! Thanks

[@EmersonYurivilcaRicaldiDreams]

Thanks!

[@melissaleigh3013]

i literally love you thank you so much i needed to learn this for work lol

[@WiseOwlTutorials]

:D thanks Melissa, happy to hear that the video helped you!

[@malcorub]

I've been referencing your videos for a few years now. Happy Valentines Day!@

[@gchunin8918]

Thank you! So helpful!

[@WiseOwlTutorials]

You're very welcome, thanks for watching!

[@CryptoQuantum]

God bless you, the only one who I really count on the internet. Many thanks for your excellent job!

[@AlmutasimAlmazidi]

Brilliant Tutorials , keep going in advance way wit different tools. Thanks a lot.

[@the72u7h4]

If you are a reporting analyst, you won't see Report builder. You'll see VS with reporting services. It's all about the shared data sources. Report builder is good for say an end user who knows what they want, and has access to get it (ie permissions) and is more like a power user. That will get old REAL QUICK if you are writing reports daily like me and want to get things out quick and not open a bunch of windows. Just one solution, many projects, keeps it clean.

[@TonyTigerTonyTiger]

I think there is another importance difference, but I do not have access to both of them right now to check it. If I remember correctly, in Visual Studio (SSDT) there is a dropdown control that allows you to select specific report elements by name, but it doesn't exist in Report Builder. For example, if you have a large, complex report and need to lookup textbox117 for some reason, you can easily find it in Visual Studio using the dropdown, but in Report Builder you would have to just continue clicking on individual textboxes one by one until you happened to hit textbox117.

[@tye3342]

This is the best training video. I love the British accent! Please can you upload the SSAS 2008 training. Thanks.

[@ZTava]

It is so useful

[@WiseOwlTutorials]

Thanks, happy to hear that it helped!

[@muhammadshahbazbabar91]

simple and to the point, great job!!

[@ioannistambakis8787]

Amazing content and presentation.

[@nezarhassani6495]

I am working within 2017 version, for some reason I can't see the graphical Query Designer

[@bekibragimov4801]

Does Report Builder consume server recourses to run a report? If I need to make a minor change and run it, would it impact the server performance?

[@smky765]

I am using report builder and I created a report using that with 5 parameters(all of them multi-value parameters). After that I published the report parts to the server, and then finally when I deployed the report to the report server, the issue began. The report is not working the way it used to work on the local system. For example the multi value parameters are selecting 'select all' by default, even though I am specifying the values. Please let me know what went wrong with the deployment and let me know what to do

[@minnrick7986]

Thanks Andrew! As usual, very informative.

[@oscarresonable2008]

Thanks for this upload. I want to ask something. How can I connect MySQL ODBC connection in SSRS 2016 Web Portal? In VS2015 reporting analytics no problem but once I deploy, that is were error comes out and says cannot create connection to data source. I'm using VS2015 and SSRS 2016. Hope you can help me.

[@rajkumarrajan8059]

Super explanation i am practing on differen version of SSRS, i am using SSMS 2019 and Visual Studio 2017, unable to establish connection. I am getting the below error, Have tried several troubleshooting options it is not working. Do you have any solution for this?

[@WiseOwlTutorials]

Hi! Sorry I'm not sure - it could be a variety of things.

[@jamolrizayev7030]

visual studio 2019 why query designer auto joining tables is not working?

[@WiseOwlTutorials]

It works for me. The auto joining is based on foreign key constraints in the database. If you don't have foreign key constraints the query designer won't create joins automatically. I hope it helps!

[@pianoLee-sx9dx]

Hello! Another great tutorial! I have got sql server 2019 installed though but when trying to connect to my reporting server, I can't find any server name.....

[@WiseOwlTutorials]

Hi Lee! SSRS changed to a standalone installation in SQL Server 2017. We have videos in this playlist which show how to install SSRS and the Business Intelligence templates kzbin.info/aero/PLNIs-AWhQzcmn2xNYQu8ahIVHobCJSEbq I hope it helps!

[@pianoLee-sx9dx]

@@WiseOwlTutorials I am confused here, do we need the business intelligence templates to get reporting server running?

[@pianoLee-sx9dx]

@@WiseOwlTutorials everything is working but I can't see any server name or it is empty....

[@WiseOwlTutorials]

@@pianoLee-sx9dx Hi Lee! No, you need the business intelligence templates if you want to create reports. You do need to install Reporting Services to get your report server running though.

[@victorarayal]

Really nice videos! Thank you ! I got a question ... Since i am working with SQL server installed on my computer, how can other people to see the reports in their web browser??

[@rendanin8329]

Configure reporting service and create url, give them that url to acces it from you computer and they might need user account to access it

[@andrewm4815]

great videos

[@Kernel009]

A few runs at this comment till I finally nailed down what I needed to ask :) So you are using IE as an Administrator to access the report server because of specific circumstances with it installed on the same machine - can you clarify what these circumstances are or point me in the direction where to find out? Additionally, any idea why Microsoft Edge prompts for credentials - and even when entering admin level credentials (same work fine from IE), it still does not work? Error below: An error has occurred during report processing. (rsProcessingAborted) Cannot create a connection to data source 'Movies'. (rsErrorOpeningConnection) A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) Access is denied

[@Kernel009]

Awesome - thanks for the additional information!

[@cuteboy1348]

I see one person disliked this video ?? OMG

[@malcorub]

Oracle users.

[@superfreiheit1]

I like SQL Server Data Tools better. Its has more functions

[@Your_true_father]

Good tutorial, thanks! But you speak too fast. Don't forget, foreigners also watch your movies ;)

[@WiseOwlTutorials]

Thanks for the feedback! I have been working on speaking more slowly but I do still sometimes forget, sorry! On KZbin you can slow down the video using the player controls at the bottom of the screen which might help. Thank you for watching!

[@Your_true_father]

@@WiseOwlTutorials l've tried to slow down but sounds quality makes down also for some reason. Your tutorials about SSIS are sounding perfect. Thanks for feedback!

[@AshishSingh-qq5rv]

This looks outdated for SRSS 2019

[@SS-TX]

I am working within 2017 version, for some reason I can't see the graphical Query Designer.

[@nezarhassani6495]

yes i had the same problem and i search about it , if u get the solution please shear it with us , or any one have a solution for this issue !