Rock U - Reporting - Reports - Other Reporting Options

Transcribed Video Content

Okay. So we've looked at data views, we looked at reports and several different options of of how to configure those. But there are other reporting options in in Rock if you, want some other options. One is this block called the dynamic data block. And so what you do is you add a page, this block to the page and you give it a SQL statement. And then whatever the SQL statement returns will be rows and columns on a page. The other option with this block is the same block. Instead of doing the rows and columns for you, you can basically give it a Lava template and it'll go ahead and just transform that into any markup that you want. So it's really powerful. You can basically create rich websites with just this capability. It does require that SQL and in if you wanna do more designers type interfaces, some Lava and some HTML. If those two languages, you can do almost anything that you'd want. Another one is the dynamic heat map block. So you add this block to a page and it basically looks at a data view and create a heat map for you of the city. So it shows you where everybody lives and it can take, , thousands of data points and make a nice map out of it. This is really nice when you're looking at, , drive times to your campus or maybe thinking about adding another campus. You can kind of see spots where people are living and where your campuses are and aren't. It does have a setting too to show, your current campuses. So it's a really good strategic planning tool. There are some analytics blocks too that are actually easier than than creating some reports when it comes to giving analytics. So you can look at patterns of giving and report back to you those the names of those folks that you can then do communications, you can export in Excel, all kinds of stuff. giving analytics, there's an attendance analytics. And so you can look at patterns and attendance and you can do all kinds of what if analysis with this. those other two, there's actually another one that's very similar for pledges. So this will allow you to report on pledges and and how many of them are complete. And of course, there's always Lava. So with using some of the entity commands within Lava, you can do some really cool reports, and you have basically all the HTML, for your results. So those are some other options, within reporting with Rock.