Reporting Services (SSRS) Part 6 - Grouping in Tables

[@richardbradley3684]

This is exactly the tutorial I needed. Nothing else I've yet found explains grouping in SSRS as clearly as this does.

[@WiseOwlTutorials]

Happy to hear that you found it useful, Richard! Thanks for watching!

[@tlalimsg]

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.

[@Canvis1984]

Using this to build a 2005 and 2008 report. This video has been invaluable to me getting the basics down

[@ericfleet9602]

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.

[@craiggers3300]

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.

[@adarshtewari9102]

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

[@rmarikar1]

Excellent . Clear, concise, well modultaed speech and superb delivery. Well done.

[@krismaly6300]

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

[@MohamedSuleiman]

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.

[@valijoneshniyazov3859]

same here

[@AliVaseghnia]

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!

[@WiseOwlTutorials]

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 kzbin.info/aero/PLNIs-AWhQzcmEFHyxCRwA_gb29WOz5SJU I hope that you find it useful!

[@joestocker660]

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!

[@ryanj2743]

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.

[@alexfriant3235]

This was the most informative instructions I've ever seen on this subject. Cheers!

[@rafaelaraujodynamics]

The best video about "Grouping in Tables"! Thank you very much for your help!

[@danrandolph8517]

Very good instruction on a complex topic in only 21 minutes.

[@awoconsequence]

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

[@daniel0carrasco]

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.

[@eriksper]

Excellent video! Explaining grouping in a very pedagogic way, a subject which is not too easy to learn by yourself.

[@claucworc]

Really well broken down. Huge help with the details in SSRS

[@rajeshreddy3469]

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

[@dreamitso]

This was really great. I was having a hard time with grouping and this really made it clear for me. Thanks!

[@alxvseti]

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

[@sniperwolfpk5]

Well done sir. Your way of teaching is very nice and full of knowledge

[@paulohsgoes1959]

Wow man, what outstanding material you've shared!

[@TheMrJBH]

These tutorials are very useful and easy to learn from. Thank you!

[@MrSaiAarya]

Awesome!! Explained simply and to the point. Will definitely check out the other videos from you!! Thanks for posting this.

[@user9757]

Very happy to have found your tutorials

[@HealthPlusWealth]

Wonderful tutorials! I'm learning SSRS and find your tutorials very helpful! Thanks for sharing your knowledge.

[@murthymamidi6054]

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.

[@fadwa2413]

Wonderful tutorials! I'm learning SSRS and find your tutorials very helpful! Thanks for sharing your knowledge.Make a tut for SSAS please

[@WiseOwlTutorials]

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.

[@rudrapandya3299]

It helped me now even in 2018, thanks!

[@gakshay9537]

Thanks for the detailed insights on grouping

[@WiseOwlTutorials]

You're welcome, thanks for watching!

[@zaras3558]

Great video, Your clear instructions are very much appreciated .

[@TheParkerBrother]

WiseOwl, This video is perfect! Just exactly what I needed. Thanks for putting it together.

[@hamzakhanzada2729]

Fantastic Explanation.. Straight forward and clear.

[@sebulva]

Thank you very much, regards from Mexico.

[@WiseOwlTutorials]

You're very welcome, thanks for watching!

[@liamdodd4921]

Very good tutorial Andrew, got me out of the mire! Thanks!

[@inspired7606]

Thank you for your clear and effective tutor.

[@irenefloyd4574]

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?

[@krismaly]

Enjoyed the video. I liked Collapsible feature. It is hard one but you explained well.

[@GlobalFlier]

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!

[@taab84]

your videos are so good, it helped me a lot

[@aynellrodriguez7348]

Excellent, so easy to follow. Thanks!!!

[@vishalinnoida]

No words to say thanks for such a wonderful video .. best ssrs tutor :) :)

[@bastoshaqq]

Well done sir. Exactly what I needed. Thank you

[@rachitgarg1016]

Awesome, great help. Thanks for the great explanation, you really made it look simple.

[@juancarlosm5746]

you Da Best! hands down. Excellent teacher

[@swagatapramanik-mhec-6643]

You have the best tutorials in SSRS. Do you have any video tutorial on grouping by multiple fields?

[@WiseOwlTutorials]

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.

[@vivekvinita]

Thanks a ton Andrew. This is really helpful.

[@eduardog6805]

Thanks you. Muchas gracias desde Huancayo, Perú

[@akshayheroor3396]

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

[@mkuse2011]

This video is awesome. I'm definitely going to the website.

[@jaynguyen8777]

Great video! Is there a video showing date groupings within the tables?

[@RajatNaraini]

Excellent explanation!

[@muhammadnadeemmn]

Very helpful videos and great explanation! Good on you mate

[@AliUmairCh]

A very useful and descriptive video indeed.

[@mrn2kin]

Excellent! Crisp and clear! Thank you!

[@vchandm23]

You are a Champion ... Seriously ...

[@danicaconway2063]

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.

[@mustafasaber2337]

Best tutor out there. Thank you. Is it possible to hide columns based on Row Group Values?

[@EdwinMiller]

This video was very helpful. Thank you.

[@gdesilvapdb]

Thanks a lot! This helps me in my job.

[@DarthVanBlunder]

Many thanks, mate! Very useful!

[@ctbeh1483]

Hi. I like to learn how to change the table in the video from top-down to sideways. Thank you.

[@karthikeyan-mq4lv]

Very Much useful videos.. Thanks for sharing...btw do you have any vidoes on SSIS..Pls help

[@SnowyHime]

Im happy to have found your tutorial too!

[@Ferruccio_Guicciardi]

Thanks WiseOwl. Very handy.

[@onatsolek8171]

Best tutorial. Thanks!

[@cnubabu]

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?

[@Ryuku692]

Amazing Tutorial Video! Thank you!

[@den3v]

Definitely great lessons!

[@mohanreddy6788]

Great session..

[@rickmemmer5625]

I'm running out of ways to compliment your work. :o)

[@bhumikapatel8835]

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 ?

[@WiseOwlTutorials]

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 kzbin.info/www/bejne/opPHapuQnMyBjtE I hope that helps!

[@bhumikapatel8835]

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

[@WiseOwlTutorials]

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

[@bhumikapatel8835]

@@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 😊

[@WiseOwlTutorials]

@@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!

[@yakulting]

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.

[@muralikanna83]

Its really helpful...thanks very much for the video!!!

[@tzvis2]

Excellent. Thank you!

[@khalidz1981]

Thank you very much. That was really helpful to me.

[@ApostleDrGeorge]

May the lord bless you so much

[@syedbilal]

Very good tutorial for learners

[@cnubabu]

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

[@simonm1229]

just GREAT!!!! love it!!!!! THANK YOU !!!!

[@dsmithprogrammer]

Great video! Thank you sir.

[@GlobalFlier]

Well, at least I know, which makes it less painful. Thanks again!

[@flyflh]

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.

[@sravanibollu5460]

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.

[@cnubabu]

Thanks,could you please let me know any of your video which covers this scenario please?

[@ugurdal]

That was really helpful, thanks !

[@benzimegido747]

Hi and thanks, what does the "add group header" and "add group footer"? in the tablix group?

[@robertetheredge4448]

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

[@ramamujula]

You are awesome!

[@sidc.3817]

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.

[@WiseOwlTutorials]

Hi Sid! You can create recursive groups to achieve the type of thing you're trying. Here's a video explaining how kzbin.info/www/bejne/eXnFonyprJqLaZI I hope it helps!

[@Nopadet]

Thanks for the help!

[@pattabhikadari]

Nice video on Grouping..

[@xlucioflavio]

Thank you very much!!!

[@OmarMeza]

Great videos... thanks!

[@Ethionetics-IT]

Thanks alot !

[@erpdevelopmentteam9808]

it is really useful

[@padmateja9203]

Thank you soooooo much......:)

[@karaorhan1]

Very good.(thanks)