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.
@gerharddewit48723 жыл бұрын
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.
@WiseOwlTutorials3 жыл бұрын
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!
@krismaly63007 жыл бұрын
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
@krismaly63007 жыл бұрын
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
@grantwilliams98387 жыл бұрын
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.
@the72u7h45 жыл бұрын
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.
@chencholon2 жыл бұрын
gracias, hasta ahora eres el primero en hacer estos tutoriales completos, me ayudo avanzar mas en mi servidor de reportes que tengo, gracias
@WiseOwlTutorials2 жыл бұрын
You're very welcome, thank you for watching!
@SrikanthYellow4 жыл бұрын
This is a brilliant guide for SSRS newbies like me. Thanks for this valuable tutorial
@KhemitPrince7 жыл бұрын
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.
@jccviking5 жыл бұрын
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_lopez3 жыл бұрын
What an excellent tutorial !
@WiseOwlTutorials3 жыл бұрын
Thanks! Glad you liked it and thanks for the comment!
@alxvseti4 жыл бұрын
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
@Mfbzai4 жыл бұрын
You are Hero! Thanks
@EmersonYurivilcaRicaldiDreams3 жыл бұрын
Thanks!
@melissaleigh30132 жыл бұрын
i literally love you thank you so much i needed to learn this for work lol
@WiseOwlTutorials2 жыл бұрын
:D thanks Melissa, happy to hear that the video helped you!
@malcorub5 жыл бұрын
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!
@CryptoQuantum6 жыл бұрын
God bless you, the only one who I really count on the internet. Many thanks for your excellent job!
@AlmutasimAlmazidi6 жыл бұрын
Brilliant Tutorials , keep going in advance way wit different tools. Thanks a lot.
@the72u7h45 жыл бұрын
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.
@TonyTigerTonyTiger6 жыл бұрын
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.
@tye33427 жыл бұрын
This is the best training video. I love the British accent! Please can you upload the SSAS 2008 training. Thanks.
@ZTava7 ай бұрын
It is so useful
@WiseOwlTutorials7 ай бұрын
Thanks, happy to hear that it helped!
@muhammadshahbazbabar915 жыл бұрын
simple and to the point, great job!!
@ioannistambakis87876 жыл бұрын
Amazing content and presentation.
@nezarhassani64955 жыл бұрын
I am working within 2017 version, for some reason I can't see the graphical Query Designer
@bekibragimov48014 жыл бұрын
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?
@smky7657 жыл бұрын
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
@minnrick79867 жыл бұрын
Thanks Andrew! As usual, very informative.
@oscarresonable20087 жыл бұрын
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.
@rajkumarrajan80599 ай бұрын
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?
@WiseOwlTutorials9 ай бұрын
Hi! Sorry I'm not sure - it could be a variety of things.
@jamolrizayev70302 жыл бұрын
visual studio 2019 why query designer auto joining tables is not working?
@WiseOwlTutorials2 жыл бұрын
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-sx9dx3 жыл бұрын
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.....
@WiseOwlTutorials3 жыл бұрын
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-sx9dx3 жыл бұрын
@@WiseOwlTutorials I am confused here, do we need the business intelligence templates to get reporting server running?
@pianoLee-sx9dx3 жыл бұрын
@@WiseOwlTutorials everything is working but I can't see any server name or it is empty....
@WiseOwlTutorials3 жыл бұрын
@@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.
@victorarayal7 жыл бұрын
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??
@rendanin83297 жыл бұрын
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
@andrewm48156 жыл бұрын
great videos
@Kernel0097 жыл бұрын
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
@Kernel0096 жыл бұрын
Awesome - thanks for the additional information!
@cuteboy13486 жыл бұрын
I see one person disliked this video ?? OMG
@malcorub5 жыл бұрын
Oracle users.
@superfreiheit14 жыл бұрын
I like SQL Server Data Tools better. Its has more functions
@Your_true_father4 жыл бұрын
Good tutorial, thanks! But you speak too fast. Don't forget, foreigners also watch your movies ;)
@WiseOwlTutorials4 жыл бұрын
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_father4 жыл бұрын
@@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-qq5rv3 жыл бұрын
This looks outdated for SRSS 2019
@SS-TX5 жыл бұрын
I am working within 2017 version, for some reason I can't see the graphical Query Designer.
@nezarhassani64955 жыл бұрын
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 !