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!
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
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:)
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.
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 ua-cam.com/play/PLNIs-AWhQzcmEFHyxCRwA_gb29WOz5SJU.html I hope it helps!
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!
That's great to hear! Thanks for watching and taking the time to comment!
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
You're very welcome, I'm happy to hear that the video helped! Thanks for watching and taking the time to comment!
Nice tutorials, that addressed many details and helped me gain skills with the report builder much faster.. I can't thank you enough!
Thanks Rahim, happy to hear you found the videos useful!
Great video. Helping me 5 years later
3 years later and I am still referencing this video when I have to group things in a report.
Happy to hear that you've been finding it useful for so long!
04:12 Viewing Group Properties
05:02 Applying a Group Expression
05:55 Creating Aggregates
10:43 Sorting by an Aggregated Value
Liked and we're watching the show ;-)
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:)
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.
From where can I get this data?
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!
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.
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 ua-cam.com/play/PLNIs-AWhQzcmEFHyxCRwA_gb29WOz5SJU.html
I hope it helps!