Some tutorials are better than others. Some remarkably simplify complex topics; some are pleasantly presented; some are simply well explained. But the best represent all three qualities. This tutorial is one of them. Much appreciated Andrew.
Thank you. I needed to figure out why my Group Headings were not working as they should. Microsoft documentation didn't answer the question, but the first six minutes of your video got me unstuck and gave me a better understanding of how they work.
The best video on SSRS Report tables that I have seen. Helped me in Dec 2019! I understand data and grouping very well but this explains it in the context of SSRS tables which if you come with a purely SQL mindset is not easy to understand or get what you want. Well presented and articulated. I now understand the UI more clearly and can greater ease implement the nested groups in reports which was previously difficult to do - not by virtue of the data structure but by implementing them through on the UI.
Awesome tutorial. Had trouble working with groupings in Power BI Report Builder, took me some time to realize it's pretty much the same as SSRS and the tutorial you've made. Thanks!
Happy to hear that Ali! We also have a Report Builder tutorial which goes into more detail in some topics compared to the Reporting Services playlist th-cam.com/play/PLNIs-AWhQzcmEFHyxCRwA_gb29WOz5SJU.html I hope that you find it useful!
This video is one of the chapters of my SSRS Bible. Revisiting. I enjoyed watching this video and recommend others to watch Thanks for educating the world and appreciate your volunteership. Thanks a bunch
I realize this was a while ago, but you showed me what I needed to know within a few minutes. I was thinking of this in terms of a row span, but really a row group is what I needed. Thanks!
Easy to understand by explaining in a crystal clear ways. SSRS tutorial is all here . I would like to suggest one thing - could you increase you voice level from next videos !! Excuse me if sound level is already above pitch(may be fault with my system).
This man is absolutely brilliant.on reporting services...thank u very much..this videos helps me a lot ..while attending interviews..so small request ,could u please provide videos on report manager.
On the nested group, is it possible to have a page break on both groups? On the example database on this video, the country will appear in each page, but if that country has multiple authors, that same country will be broken down into different pages since this country has multiple authors. This is assuming that we do not use collapsible feature on the authors. Thanks.
Your SSRS tutorials are amazing and I especially appreciate your attention to detail. I have watched all 23 of them and am now reviewing individual lessons. I need to build a table or matrix where rows are locations and columns are months of the year. Each month is represented in 2 columns: Actual and Budget, e.g. January Actual, January Budget, February Actual, February Budget, etc. The Budget values are stored in one table; the Actual values are computed weekly and stored in a separate table. How do I go about this?
Can you nest a data table column with itself at least n>2 times? I am thinking about how this feature of grouping in SSRS can be used for creating reports for Indented Drawing Lists OR Family Ancestry Trees.
Hi Sid! You can create recursive groups to achieve the type of thing you're trying. Here's a video explaining how th-cam.com/video/CHbqIsw5X30/w-d-xo.html I hope it helps!
I liked the idea of Nested Groups. I went into the shared data source and added another column and grouping in my SQL statement. I Refreshed the data, but my report wouldn't work anymore. It would compile, but the data was all wrong. I was able to fix it only by deleting the report and re-making it with the updated data source. Is there a less painful way to update an existing report with a new SQL query? Thanks!
Thanks for these videos, one of them helped me solve a problem our programmers couldn't resolve! Wondering if you have a video showing more complex grouping structures. Groups within groups, sorting outer group, then inner group, and having multiple inner groups that may / may not have a linear relationship. Example: Jane & John Doe @ House 1 have Regular meds and PRN meds. I want regulars sorted in separate column. Jane's meds under her, John's under him, then sort by house @ top level.
Please answer for the below scenarios. 1) When the user execute the report he should only see his data only - how will it be possible..Because we have got single report for all users to execute? 2) for some other scenario for the same report - IF either 3333,4444 execute the report ,then they need to get only data relevant to the location US how this kind of ristriction is possible for business users?
3) I have not given any example here, however the question is If i ran the report then i need to check my data and the person who are working under me related data should be visible in my report and if my manager run the data he need to check my data and the person who are working under me data as well...How this can be done? Thanks for your kind help Regards
Hello Wonderful explanation... Thank you so much... I have one question:- How to apply arithmetic operation for example subtraction for two text box which belong to/come from two different table ? Can you help me to find the solution please ?
Hi Bhumika, you can reference a specific text box using the ReportItems collection which you can read about here docs.microsoft.com/en-us/sql/reporting-services/report-design/built-in-collections-reportitems-collection-references-report-builder?view=sql-server-ver15 There are some restrictions on which text boxes you can reference depending on the scope of the object you're referring to. If you need to match values between datasets you may need to use the lookup functions. We have a video on that topic here th-cam.com/video/lbd9hZggNXo/w-d-xo.html I hope that helps!
@@WiseOwlTutorials Thank you for providing information... I tried with "ReportItems" already but nit getting result. It should be implemented for the same dataset. I try to avoid using lookup because it is not giving desire design. Is there any other way to do this task ? If yes please let me know please thanks
@@bhumikapatel8835 Hi Bhumika, if you can provide more details on exactly what you're trying to do I might be able to suggest something. You may have more success posting your question at stackoverflow.com/questions
@@WiseOwlTutorials sure... Would you like to share your email id please so I can share some screenshots there...I tried to put questions on slacks but something happens wrong and My account is blocked for 2 days... And not found any similar problem on it... Thank you 😊
@@bhumikapatel8835 Hi Bhumika, I don't have a Stackoverflow account but you can post the link to your question here if you like. it's likely that someone else will answer it before I do!
Great video! Just one question, When I create a new data source, the Data Set folder is not automatically created. I'm using Visual Studio 2008 Version 9.0 with SQL Server 2008 R2.
Hi .. Great tutorial... Thanks :) .. Also, Could you please cross check your data in director's table... I saw the director 'Ang Lee' was available in both China and UK groups ... I think there is a duplicate row in your director's table ... :)
I need to report the below. What video do I watch to see how to do this. Owner - Owner details Motorbikes - multiple with details Cars = multiples with details Boats - multiples with details Next Owner - Owner details Motorbikes - multiple with details Cars = multiples with details Boats - multiples with details and so on...
Hello, Kindly help me with the following query, i have my a table as below, PID ID Date Value Weight 1 1 01-01-2014 10 0.5 2 1 01-01-2014 20 0.5 3 1 01-01-2014 30 0.5 4 1 02-01-2014 10 0.5 5 1 02-01-2014 10 0.5 6 1 02-01-2014 10 0.5 and i want the out put as, ID Date SUM_PROD 1 01-01-2014 30 1 02-01-2014 15 That is i want to do a product of the value * weight and then sum it on date, i m getting the answer when i follow the exact steps but then In between the unwanted column of individual values, i tried to hide the intermediate values, but it then leave unwanted space. any suggestion on how should i go about this? thanks in advance,
***** Hello, I tried your suggestion and i am getting the following output, Adam McKay 202 Akira Kurosawa 529 and so on for the complete data. While the epectation is Adam Mckay 202 Akira Kurosawa 529
This is exactly the tutorial I needed. Nothing else I've yet found explains grouping in SSRS as clearly as this does.
Happy to hear that you found it useful, Richard! Thanks for watching!
Using this to build a 2005 and 2008 report. This video has been invaluable to me getting the basics down
Some tutorials are better than others. Some remarkably simplify complex topics; some are pleasantly presented; some are simply well explained. But the best represent all three qualities. This tutorial is one of them. Much appreciated Andrew.
Thank you. I needed to figure out why my Group Headings were not working as they should. Microsoft documentation didn't answer the question, but the first six minutes of your video got me unstuck and gave me a better understanding of how they work.
Excellent . Clear, concise, well modultaed speech and superb delivery. Well done.
The best video on SSRS Report tables that I have seen. Helped me in Dec 2019! I understand data and grouping very well but this explains it in the context of SSRS tables which if you come with a purely SQL mindset is not easy to understand or get what you want. Well presented and articulated. I now understand the UI more clearly and can greater ease implement the nested groups in reports which was previously difficult to do - not by virtue of the data structure but by implementing them through on the UI.
My full regards to you . You have completely made the whole ssrs leaning so simple that it will change the way the people learn in future . Thanks
I stopped all other videos from other tutors, and started with only your videos .... Really really great. I love it. Many thanks. God bless YOU ALL.
same here
04:01 Editing Headings
07:49 Subtotals
10:12 Sorting Rows
12:21 Page Breaks Between Groups
13:31 Collapsible Groups
18:05 Nested Groups
Awesome tutorial. Had trouble working with groupings in Power BI Report Builder, took me some time to realize it's pretty much the same as SSRS and the tutorial you've made. Thanks!
Happy to hear that Ali! We also have a Report Builder tutorial which goes into more detail in some topics compared to the Reporting Services playlist th-cam.com/play/PLNIs-AWhQzcmEFHyxCRwA_gb29WOz5SJU.html
I hope that you find it useful!
This video is one of the chapters of my SSRS Bible.
Revisiting.
I enjoyed watching this video and recommend others to watch
Thanks for educating the world and appreciate your volunteership.
Thanks a bunch
Very good instruction on a complex topic in only 21 minutes.
This was the most informative instructions I've ever seen on this subject. Cheers!
I realize this was a while ago, but you showed me what I needed to know within a few minutes. I was thinking of this in terms of a row span, but really a row group is what I needed. Thanks!
Thank you so much! I was trying to figure this out all morning and within minutes of watching your video achieved the results I desired.
These tutorials are very useful and easy to learn from. Thank you!
Well done sir. Your way of teaching is very nice and full of knowledge
Really well broken down. Huge help with the details in SSRS
The best video about "Grouping in Tables"!
Thank you very much for your help!
Very happy to have found your tutorials
Easy to understand by explaining in a crystal clear ways. SSRS tutorial is all here . I would like to suggest one thing - could you increase you voice level from next videos !! Excuse me if sound level is already above pitch(may be fault with my system).
Congratulations for your videos. I'm from Brazil and i'm starting to work with Reporting Services now, your videos'll help me a lot.
Awesome!! Explained simply and to the point. Will definitely check out the other videos from you!! Thanks for posting this.
Wow man, what outstanding material you've shared!
Excellent stuff, really! All your videos I've seen so far have helped tremendously and I can't imagine how I would have learnt SSRS otherwise
Excellent video! Explaining grouping in a very pedagogic way, a subject which is not too easy to learn by yourself.
Thank you very much, regards from Mexico.
You're very welcome, thanks for watching!
Wonderful tutorials! I'm learning SSRS and find your tutorials very helpful! Thanks for sharing your knowledge.
Thanks for the detailed insights on grouping
You're welcome, thanks for watching!
Fantastic Explanation.. Straight forward and clear.
This was really great. I was having a hard time with grouping and this really made it clear for me. Thanks!
It helped me now even in 2018, thanks!
WiseOwl,
This video is perfect! Just exactly what I needed. Thanks for putting it together.
Wonderful tutorials! I'm learning SSRS and find your tutorials very helpful! Thanks for sharing your knowledge.Make a tut for SSAS please
Happy to hear that you're enjoying the SSRS videos! SSAS is on the To Do list but I don't know when it's going to happen.
This man is absolutely brilliant.on reporting services...thank u very much..this videos helps me a lot ..while attending interviews..so small request ,could u please provide videos on report manager.
Great video, Your clear instructions are very much appreciated .
Very good tutorial Andrew, got me out of the mire! Thanks!
Thank you for your clear and effective tutor.
Excellent, so easy to follow. Thanks!!!
Very helpful videos and great explanation! Good on you mate
You have the best tutorials in SSRS. Do you have any video tutorial on grouping by multiple fields?
Hi Swagata, happy to hear that you're enjoying the videos! There's a section about grouping on multiple fields towards the end of this video.
Thanks a ton Andrew. This is really helpful.
No words to say thanks for such a wonderful video .. best ssrs tutor :) :)
Well done sir. Exactly what I needed. Thank you
A very useful and descriptive video indeed.
Thanks you. Muchas gracias desde Huancayo, Perú
On the nested group, is it possible to have a page break on both groups? On the example database on this video, the country will appear in each page, but if that country has multiple authors, that same country will be broken down into different pages since this country has multiple authors. This is assuming that we do not use collapsible feature on the authors. Thanks.
you Da Best! hands down. Excellent teacher
Awesome, great help. Thanks for the great explanation, you really made it look simple.
your videos are so good, it helped me a lot
Enjoyed the video.
I liked Collapsible feature.
It is hard one but you explained well.
This video was very helpful. Thank you.
Many thanks, mate! Very useful!
Excellent explanation!
This video is awesome. I'm definitely going to the website.
Your SSRS tutorials are amazing and I especially appreciate your attention to detail. I have watched all 23 of them and am now reviewing individual lessons. I need to build a table or matrix where rows are locations and columns are months of the year. Each month is represented in 2 columns: Actual and Budget, e.g. January Actual, January Budget, February Actual, February Budget, etc. The Budget values are stored in one table; the Actual values are computed weekly and stored in a separate table. How do I go about this?
Thanks a lot! This helps me in my job.
Can you nest a data table column with itself at least n>2 times? I am thinking about how this feature of grouping in SSRS can be used for creating reports for Indented Drawing Lists OR Family Ancestry Trees.
Hi Sid! You can create recursive groups to achieve the type of thing you're trying. Here's a video explaining how th-cam.com/video/CHbqIsw5X30/w-d-xo.html
I hope it helps!
Great video! Is there a video showing date groupings within the tables?
Best tutorial. Thanks!
You are a Champion ... Seriously ...
I liked the idea of Nested Groups. I went into the shared data source and added another column and grouping in my SQL statement. I Refreshed the data, but my report wouldn't work anymore. It would compile, but the data was all wrong. I was able to fix it only by deleting the report and re-making it with the updated data source. Is there a less painful way to update an existing report with a new SQL query? Thanks!
Thanks for these videos, one of them helped me solve a problem our programmers couldn't resolve!
Wondering if you have a video showing more complex grouping structures. Groups within groups, sorting outer group, then inner group, and having multiple inner groups that may / may not have a linear relationship. Example: Jane & John Doe @ House 1 have Regular meds and PRN meds. I want regulars sorted in separate column. Jane's meds under her, John's under him, then sort by house @ top level.
Excellent! Crisp and clear! Thank you!
Its really helpful...thanks very much for the video!!!
Hi and thanks, what does the "add group header" and "add group footer"? in the tablix group?
Amazing Tutorial Video! Thank you!
Definitely great lessons!
Please answer for the below scenarios.
1) When the user execute the report he should only see his data only - how will it be possible..Because we have got single report for all users to execute?
2) for some other scenario for the same report - IF either 3333,4444 execute the report ,then they need to get only data relevant to the location US
how this kind of ristriction is possible for business users?
Thanks WiseOwl. Very handy.
3) I have not given any example here, however the question is If i ran the report then i need to check my data and the person who are working under me related data should be visible in my report and if my manager run the data he need to check my data and the person who are working under me data as well...How this can be done?
Thanks for your kind help
Regards
Thank you very much. That was really helpful to me.
Excellent. Thank you!
Great video! Thank you sir.
Hello
Wonderful explanation... Thank you so much...
I have one question:- How to apply arithmetic operation for example subtraction for two text box which belong to/come from two different table ? Can you help me to find the solution please ?
Hi Bhumika, you can reference a specific text box using the ReportItems collection which you can read about here
docs.microsoft.com/en-us/sql/reporting-services/report-design/built-in-collections-reportitems-collection-references-report-builder?view=sql-server-ver15
There are some restrictions on which text boxes you can reference depending on the scope of the object you're referring to.
If you need to match values between datasets you may need to use the lookup functions. We have a video on that topic here th-cam.com/video/lbd9hZggNXo/w-d-xo.html
I hope that helps!
@@WiseOwlTutorials Thank you for providing information... I tried with "ReportItems" already but nit getting result. It should be implemented for the same dataset.
I try to avoid using lookup because it is not giving desire design.
Is there any other way to do this task ?
If yes please let me know please thanks
@@bhumikapatel8835 Hi Bhumika, if you can provide more details on exactly what you're trying to do I might be able to suggest something.
You may have more success posting your question at stackoverflow.com/questions
@@WiseOwlTutorials sure... Would you like to share your email id please so I can share some screenshots there...I tried to put questions on slacks but something happens wrong and My account is blocked for 2 days... And not found any similar problem on it...
Thank you 😊
@@bhumikapatel8835 Hi Bhumika, I don't have a Stackoverflow account but you can post the link to your question here if you like. it's likely that someone else will answer it before I do!
Thanks,could you please let me know any of your video which covers this scenario please?
Great video! Just one question, When I create a new data source, the Data Set folder is not automatically created. I'm using Visual Studio 2008 Version 9.0 with SQL Server 2008 R2.
Best tutor out there. Thank you. Is it possible to hide columns based on Row Group Values?
Hi. I like to learn how to change the table in the video from top-down to sideways. Thank you.
Hi .. Great tutorial... Thanks :) .. Also, Could you please cross check your data in director's table... I saw the director 'Ang Lee' was available in both China and UK groups ... I think there is a duplicate row in your director's table ... :)
Im happy to have found your tutorial too!
May the lord bless you so much
Very Much useful videos.. Thanks for sharing...btw do you have any vidoes on SSIS..Pls help
Great session..
That was really helpful, thanks !
hi
can some one help how to group the data from multiple excel sheets and generate a single SSRS report??
I noticed a line spacing between each Country, how would you remove this extra line spacing?
I'm running out of ways to compliment your work. :o)
Very good tutorial for learners
I need to report the below. What video do I watch to see how to do this.
Owner - Owner details
Motorbikes - multiple with details
Cars = multiples with details
Boats - multiples with details
Next Owner - Owner details
Motorbikes - multiple with details
Cars = multiples with details
Boats - multiples with details
and so on...
just GREAT!!!! love it!!!!! THANK YOU !!!!
HIHow to adding the two columns
Hi,
Thank you so much for your reply.
Could you please elaborate on this else could you make a video so that everybody will be benefited.
can you display two recordsets in one table?
Thanks Andy
Well, at least I know, which makes it less painful. Thanks again!
You are awesome!
Thank you very much!!!
Hello,
Kindly help me with the following query,
i have my a table as below,
PID ID Date Value Weight
1 1 01-01-2014 10 0.5
2 1 01-01-2014 20 0.5
3 1 01-01-2014 30 0.5
4 1 02-01-2014 10 0.5
5 1 02-01-2014 10 0.5
6 1 02-01-2014 10 0.5
and i want the out put as,
ID Date SUM_PROD
1 01-01-2014 30
1 02-01-2014 15
That is i want to do a product of the value * weight and then sum it on date, i m getting the answer when i follow the exact steps but then In between the unwanted column of individual values, i tried to hide the intermediate values, but it then leave unwanted space.
any suggestion on how should i go about this?
thanks in advance,
***** Hello, I tried your suggestion and i am getting the following output,
Adam McKay
202
Akira Kurosawa
529 and so on for the complete data.
While the epectation is
Adam Mckay 202
Akira Kurosawa 529
***** Yes, Got it!! many thanks will post a video for the same soon
Great videos... thanks!
Nice video on Grouping..