I started VBA with you and improved my excel skills when I started my professional career. 6 years later I have been implementing Power BI in dozens of companies and have been needing more paginated reports recently. Your videos are saving me once again!
@WiseOwlTutorials Жыл бұрын
That's great to hear! Thanks for watching and taking the time to comment!
@exogendesign4582 Жыл бұрын
I'd been looking this for like 2 days now. I have a new project that uses SSRS and forgot how to Group rows effectively with tables, coz others uses a list method. I got to remember that name WiseOwl. Thanks again man
@WiseOwlTutorials Жыл бұрын
You're very welcome, I'm happy to hear that the video helped! Thanks for watching and taking the time to comment!
@user-yy6nf2iq2j Жыл бұрын
Nice tutorials, that addressed many details and helped me gain skills with the report builder much faster.. I can't thank you enough!
@WiseOwlTutorials Жыл бұрын
Thanks Rahim, happy to hear you found the videos useful!
@alxvseti4 жыл бұрын
04:12 Viewing Group Properties 05:02 Applying a Group Expression 05:55 Creating Aggregates 10:43 Sorting by an Aggregated Value
@stefanventer575 Жыл бұрын
3 years later and I am still referencing this video when I have to group things in a report.
@WiseOwlTutorials Жыл бұрын
Happy to hear that you've been finding it useful for so long!
@melissajones1727 Жыл бұрын
Thank you my king
@WiseOwlTutorials Жыл бұрын
😀you're welcome!
@Giovanni-vx8xl5 ай бұрын
how do you show grouped by month if no data for a particular month? I do not want the to just disappeared but to show zero instead.
@ukaszpawlak48545 жыл бұрын
Liked and we're watching the show ;-)
@kklip Жыл бұрын
How do I group the rows together with a pagebreak when value for one of the column is different than the rest? Example, whenever the release date of a movie is different for a particular genre, I need to group them after a break. Been pulling my hair for a while. Thanks:)
@resiliencerealm242 Жыл бұрын
From where can I get this data?
@WiseOwlTutorials Жыл бұрын
Hi! Take a look in the Getting Started section of the video - it tells you where to get the sample Movies database. Hope it helps!
@edjohnson11672 жыл бұрын
Hello have been watching you MS report builder videos which are great, but not finding what I need and hope someone can point me to the right one or suggest how to address issue. I am trying to do a report on the number of new accounts on our website by day. if date_created =08/08/2022 do a count of those. trying to do a report to show last months worth of new accounts.
@WiseOwlTutorials2 жыл бұрын
Hi Ed! If you have a date_created field then you can group your table by this field and add a Count expression to the second column. The Count function will automatically count values in the field for the date displayed on each row, so you won't need to test if the date is a specific value. If you need to show only the last month's worth of results you can add a filter to the table or dataset to limit the rows returned. If you do, for some reason, need to create a CountIf style expression then you can combine the Count and IIf functions. We have videos on all those topics in this playlist kzbin.info/aero/PLNIs-AWhQzcmEFHyxCRwA_gb29WOz5SJU I hope it helps!