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.
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.
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.
Excellent explanation. i had exposure to SSRS but without knowledge, this video really helped me to understand the fundamentals very well,thanks a lot.
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.
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!
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👍🏼🙌🏼
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
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.
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?
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?
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!
When I choose reporting services and try and connect to the instance I created originally when installing SQL server, I get an error telling me "cannot connect to ......" What a fucking waste of time this was
Another great video. Your youtube videos are better than most paid programs out there. I have been able to follow report creation and editing without any problems. The SSRS is working beautifully on my Visual Studio development area. One thing that I got stuck is on the deploying part. When I go to the Server management Studio and try to open the Reporting Services, I get this message: "The Reporting Services Instance could not be found" Before posting here, I try reinstalling, updating, checked the web for solutions and still nothing. I even try doing the same installation on another computer and I get the exact same error! What am I doing wrong? I have Windows 10 on both computers and installed VS 2017, MMS 17.7, MMC 3, MS-SQL 2017, SQL SCM 2017. I followed your first video on how to install everything, but when you show the SQL Server configuration Manager, I don't see the reporting Services there. I go to the Reporting Services Configuration Manager and it says: "Started". I can even test the connection successfully. Again, I can create and edit SSRS reports in Visual Studio. I just can't access the reporting Services server. Any help would be truly appreciated. Thanks.
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.
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
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?
What do I need to do to keep different editions of a periodic report? Like for example: I want to have available to my stakeholders Monthly Sales Reports from a Sales Database and Id like each report to be interactive (toggle groupings, dynamic filtering, etc). But since all reports are supposed to be connected to a single and constantly evolving database (added, updated, deleted records), I can't imagine how I could do the above said multi-editions for the example Monthly Sales Report. Is there a method you could suggest?
Hi Sid! Scheduled report snapshots are what you need! docs.microsoft.com/en-us/sql/reporting-services/report-server/add-a-snapshot-to-report-history-report-manager?view=sql-server-ver15 I hope it helps!
Damn anyoneone have a connection problem while creating dataset (20.24 on the video). The connection is made but after I get that message error :"You have specified integrated security or credentials in the connection string for the data source, but the data source is configured to use a different credential type. To use the values in the connection string, you must configure the unattended report processing account for the report server. Any help ? BTW awesum video wiseowl !
Hi Jonathan! I'm not sure if this is the cause of your issue but in SSRS 2017 data sources have an annoying habit of resetting their credentials to the Don't Use Credentials setting when you first create them. Try opening the Data Source Properties dialog (double-click the data source in the Report Data window), head to the Credentials page and check that it's using the type of credentials you think it should be. I hope that helps!
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!
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
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....
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
HI! I am using SSRS reports. I am in a big throuble with table's layout and looking for it on internet i didn't found anything that can help me, then I am trying telling you my problem: I have to send MHTML in mail body for my boss, that has a GMAIL account. He reads mail on PC and on mobile. I can't use MobileReportingServices, but I need to fix the visualization problems: is there a way to make the layout flexible in SSRS? Using particular function maybe? Every research i did says that it's not possible, then I am asking you tha same thing. Please help me.
Hi there, I'm sorry but your research is correct, tables in SSRS aren't really very dynamic in the way you want them to be. One thing you could try is creating two tables in the report, one for viewing in normal HTML view and one for MHTML (I think that you can make SSRS distinguish between the two but I've not done this myself). You could then add an expression to each table's Hidden property which tests the value of the RenderFormat.Name property and makes the table visible when it's being viewed in the appropriate renderer. Here's a blog which shows the basic principle by hiding a table header when the report is displayed in Excel www.wiseowl.co.uk/blog/s373/excel-render-format.htm Here's information from Microsoft on SSRS rendering extensions docs.microsoft.com/en-us/sql/reporting-services/extensions/rendering-extension/rendering-extensions-overview?view=sql-server-ver15 I hope that points you in the right direction!
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!
Hiya! I keep getting the following error message 'Unable to connect to data source Movies' when I click on Query Designer. When I click details to view the error is says the following: You have specified integrated security or credentials in the connection string for the data source, but the data source is configured to use a different credential type. To use the values in the connection string, you must configure the unattended report processing account for the report server. Do you know how I can fix this issue? Thanks!
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.
![[Full Episode] The Restaurant War Thailand ศึกพ่อค้าซ่าแม่ค้าแซ่บ Episode 2 | 29 ก.ย. 67](http://i.ytimg.com/vi/r3lfLNH6Ke4/mqdefault.jpg)
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!
Truly a wise Owl, you are a natural teacher. Well explained and thorough lesson.
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.
This video is on the money. Thank you WiseOwl. You are really wise. You have just made my life easier.
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!
I have rarely seen such as very well explained and presented tutorial, congrats and thank you :)
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
Excellent explanation. i had exposure to SSRS but without knowledge, this video really helped me to understand the fundamentals very well,thanks a lot.
Thanks very much, Andrew. Awesome tutorial and simple presentation.
You're very welcome Richard, thanks for watching!
All I could say is; You're just Amazing!
after 2 min of watching i knew ur one of the best.
Pretty awesome tutorial for learning SSRS
Thanks, happy to hear that you liked it!
Very straight instructions and super clear!
Thanks Roberto!
As always, The best tutorials on TH-cam ! Thanks,
Excellent video Andrew. Greater refresher..
wow thanks so much for this video. very clear and straightforward...
GREAT TUTORIAL...CONGRATS
Thanks!
Great job!!. This video refreshed my reporting knowledge quickly and easily. Thank you.
Excellent video.. Big fan of your teaching
Excellent stuff, very useful for beginners like me. Thanks a ton for the video.
wow, the best tutorial I seen so far :)))
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.
Excellent Tutorial. Maybe even exceptional.
Thanks! Happy to hear that you enjoyed it, thanks for watching and taking the time to leave a comment!
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!
Thanks! Excellent video
Great tutorial and well thought out!
Great instructor, a lot of energy :))) Thanks!
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.
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!
@@WiseOwlTutorials Well there ya go. I'll go check it out. :).
@@ThrivolousZ No problem Aaron, I hope it's useful!
Good job my friend!
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👍🏼🙌🏼
Very helpful. Nice one mate. Thanks
Good work sir👍🏻
Very helpful video, thank-you :)
Nice Presentation, Thank you
thank you.
You're very welcome!
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!
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.
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?
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!
Thanks a lot.
I am brazilian. I like your videos. Very good.
Obrigado Adriano, thank you for watching!
Very Very Good!
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?
Very useful video for beginners. Thank you for your effort.
You're very welcome, thanks for watching!
Hi Andrew, You have been a very good teacher.Thanks a lot for this tutorial.
very rare to watch this for free.From my experience, u can have it here only. Thank you 1000 times
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
Thank you for a well detailed presentation
You're very welcome Michael, thanks for watching!
7 Stars Tutorial. Thanks a lot. I already subscribed long time ago.
Thank you so much, I appreciate that!
Thanks for your efforts dear.
good teacher. I like the video . thank you so much
You're very welcome Grace, I'm happy that you enjoyed it!
When I choose reporting services and try and connect to the instance I created originally when installing SQL server, I get an error telling me "cannot connect to ......" What a fucking waste of time this was
nice tutorial ~ help more ~
Thanks!
Very well explained , Thanks
Thanks!
Another great video. Your youtube videos are better than most paid programs out there. I have been able to follow report creation and editing without any problems. The SSRS is working beautifully on my Visual Studio development area.
One thing that I got stuck is on the deploying part. When I go to the Server management Studio and try to open the Reporting Services, I get this message: "The Reporting Services Instance could not be found"
Before posting here, I try reinstalling, updating, checked the web for solutions and still nothing.
I even try doing the same installation on another computer and I get the exact same error!
What am I doing wrong?
I have Windows 10 on both computers and installed VS 2017, MMS 17.7, MMC 3, MS-SQL 2017, SQL SCM 2017.
I followed your first video on how to install everything, but when you show the SQL Server configuration Manager, I don't see the reporting Services there. I go to the Reporting Services Configuration Manager and it says: "Started". I can even test the connection successfully.
Again, I can create and edit SSRS reports in Visual Studio. I just can't access the reporting Services server.
Any help would be truly appreciated. 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!
I wish you were my high school math teacher! Your explanation and presentation in this video is top-notch!
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!
it is super helpful.thanks
You're very welcome, Mehmet. Thanks for watching!
The presenter's demonstration is so thorough and accentuates on all the points.Thank's a lot man
Hi, awesome video!!!
I'm having a trouble when i try to sort the values on the chart, can you give a quick tip to solve this problem?
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!
Amazing! Thank you so much for delivering such valuable training videos.
when i preview the report on ssrs 2019 its showing "An error occurred during local report processing"
This is gold. Flawless delivery 👏👏👏
Thanks! Happy to hear you enjoyed it and thank you for watching!
Thanks for your good work
You're very welcome, thanks for watching and taking the time to leave a comment!
Content is highly in order to get some beginner like me to get ssrs easily.
Really good refresher video on SSRS Thank you very soft spoken and easy to follow
Thanks! Happy to hear that it helped!
love you man. great
Thank you!
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
Thank you so much!
You're very welcome Suvradeep, thank you for watching!
Gr8 Video. It saved lots of time to learn SSRS :)
which is better to build a report? The Visual Studio or the Report Builder?
Thank you so much
You're very welcome, thanks for watching!
Dear Mr.
Do you know how to add a crystal report with the Server report service?
You are too good!
Ahh thanks!
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?
What do I need to do to keep different editions of a periodic report? Like for example: I want to have available to my stakeholders Monthly Sales Reports from a Sales Database and Id like each report to be interactive (toggle groupings, dynamic filtering, etc). But since all reports are supposed to be connected to a single and constantly evolving database (added, updated, deleted records), I can't imagine how I could do the above said multi-editions for the example Monthly Sales Report. Is there a method you could suggest?
Hi Sid! Scheduled report snapshots are what you need! docs.microsoft.com/en-us/sql/reporting-services/report-server/add-a-snapshot-to-report-history-report-manager?view=sql-server-ver15
I hope it helps!
what do I need to be good at SSIS and DataWareHouse?
Can you add a report like this to SSMS Custom Reports?
Very good video and explanation. Thanks
Damn anyoneone have a connection problem while creating dataset (20.24 on the video).
The connection is made but after I get that message error :"You have specified integrated security or credentials in the connection string for the data source, but the data source is configured to use a different credential type. To use the values in the connection string, you must configure the unattended report processing account for the report server.
Any help ?
BTW awesum video wiseowl !
Hi Jonathan! I'm not sure if this is the cause of your issue but in SSRS 2017 data sources have an annoying habit of resetting their credentials to the Don't Use Credentials setting when you first create them. Try opening the Data Source Properties dialog (double-click the data source in the Report Data window), head to the Credentials page and check that it's using the type of credentials you think it should be.
I hope that helps!
Fantastic... One of the best i have seen. So clear, concise and to the point.
Thank you for the kind words Hassan!
I'm getting a error..
Unable to connect to data source 'DataSource1'
While adding the data set I'm getting this pop-up
Please help me
Very well done. This s a great quick overview, really easy to follow even in high speed time ;-)
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
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!
WiseOwlTutorials thanks a lot, can we do a line and bar chart in same chart ?
well very nice explainantion ,thanks
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
Love, love it! Good refresher for me👍🏽👍🏽
Indeed
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....
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
Thank you very much for such great video. Indeed exceptional and usefull
HI! I am using SSRS reports. I am in a big throuble with table's layout and looking for it on internet i didn't found anything that can help me, then I am trying telling you my problem: I have to send MHTML in mail body for my boss, that has a GMAIL account. He reads mail on PC and on mobile. I can't use MobileReportingServices, but I need to fix the visualization problems: is there a way to make the layout flexible in SSRS? Using particular function maybe? Every research i did says that it's not possible, then I am asking you tha same thing. Please help me.
Hi there, I'm sorry but your research is correct, tables in SSRS aren't really very dynamic in the way you want them to be. One thing you could try is creating two tables in the report, one for viewing in normal HTML view and one for MHTML (I think that you can make SSRS distinguish between the two but I've not done this myself). You could then add an expression to each table's Hidden property which tests the value of the RenderFormat.Name property and makes the table visible when it's being viewed in the appropriate renderer. Here's a blog which shows the basic principle by hiding a table header when the report is displayed in Excel www.wiseowl.co.uk/blog/s373/excel-render-format.htm
Here's information from Microsoft on SSRS rendering extensions docs.microsoft.com/en-us/sql/reporting-services/extensions/rendering-extension/rendering-extensions-overview?view=sql-server-ver15
I hope that points you in the right direction!
@@WiseOwlTutorials Thanks. I'll study how to do it.
How do you change the web services URL if you are publishing to a shared server instead of local ?
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!
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.
Indeed, this was a very good tutorial. I will even donate a few bucks.
Hiya! I keep getting the following error message 'Unable to connect to data source Movies' when I click on Query Designer. When I click details to view the error is says the following:
You have specified integrated security or credentials in the connection string for the data source, but the data source is configured to use a different credential type. To use the values in the connection string, you must configure the unattended report processing account for the report server.
Do you know how I can fix this issue?
Thanks!
No worries I sorted it out :)
a lot of good tips but SLOW DOWN. and you need to zoom into certain areas that you cover.
Reportle..its brilliant 😄 Watching this for second time. Worth it
😀 thanks Bhavya!
very well explained. Simple.
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.
Bravo! A brilliant tutorial that worked perfectly! Excellent explanations and a pleasant voice.