Hello everyone, thanks for attending today. My name is Ryan Minook and I'm a Solutions Consultant here at FileMaker. Joining me is Rosemary T.G., a Consulting Engineer who will cover some best practices and tips for creating FileMaker reports. But before we begin, let's spend the first minute or two going over some brief housekeeping notes. It's strongly recommended that you participate in this web seminar with at least a broadband connection. If you have any problems or require online assistance at any time, please contact Citrix Technical Support at<PHONE_NUMBER>. Now throughout today's presentation you'll have the opportunity to type in and ask questions, so let's talk about briefly how to do that. Go to the control panel, click on the question section, enter your question and click send. Now we'll try to enter as many as time allows at the end of our presentation, but remember you don't need to wait until then to submit a question. The FileMaker training series is FileMaker's official training curriculum focusing on increasing your knowledge and level of comfort with the features and benefits of the FileMaker platform. And it's broken down into easy to follow modules as shown on your screen. But for today's webinar, we're going to take sample files provided by the training series and take a deeper dive into the best practices and tips covered in the reporting module. And with that, it is my pleasure to introduce FileMaker Consulting Engineer Rosemary T.G. Good morning, everyone. Thank you, Ryan. And today I'm going to talk about, as Ryan said, the report section of the FileMaker training series. And just to go over a high-level outline of what I'm going to cover, I'm going to start with why do we report and then talk about some of the ad hoc reporting you can do with FileMaker right out of the gate. And then I'll take a deeper dive into the most common reports we see in FileMaker users and customers creating the basic subsummary report. And then I'll talk a little bit about quick charts and give a demonstration of those and wrap up with the Q&A and point you to some additional resources if you want to take a deeper dive into learning more about reporting. So we report so that we can get meaning out of the data and the information we store in our FileMaker systems. So here's an Excel spreadsheet. This is a screenshot of the spreadsheet that I'll be using throughout the demonstration, and that is part of the materials provided for the exercises in the FileMaker training series basics. And it's a bunch of records, about 30 rows of asset information. But if I want to dive in and find out, well, how many computers do we have, or what's the value of each category of asset that we have, it's really hard to do this in Excel. With FileMaker, we can quickly create a report that shows us that in the Appliances category, we have $600 in assets. In the Camera category, we have $1,200 and so on throughout all the assets in the system. And that report will be flexible and it will grow as the assets in our inventory grow. In addition, you can create a visual representation of that same information and get even a deeper look and do a quick category comparison to see just very quickly how many cameras do we have versus how many computers or how many pieces of office furniture and get that very quick visual representation and build a dashboard or other report that you can hand to management or executives. So, again, to wrap up, we create reports because we have all this data. We have this information locked up in a FileMaker system and reporting lets us get meaning from it, which will then let us take action and make better business decisions. So, I'm going to start by talking a little bit about the ad hoc reports you can do in FileMaker in TableView. With TableView, you can quickly find records and quickly drill in and get some information out of data. So, let me jump over to FileMaker and dive into that. So, I'm going to go ahead and open the asset spreadsheet. Here it is in Excel. And as you can see, there's about 30 records here and I've got a header row. And I'm going to just drag and drop this onto FileMaker Pro. And FileMaker Pro, when you convert in Excel spreadsheet, first says, asks you, is the first row column headers or field names or is it data? And in this case, as you saw, it's field names. So, what FileMaker is going to do now is create a new file for me and name the fields based on those column headers in Excel. And I'm just going to call this assets converted and save it in my documents folder. And here it is. So, for these quick ad hoc reports, I can do things like a simple control click or right click in a field where I want to find all the espresso machines. So, I'm just going to go down here and select find matching records. And I now see that out of my 29 assets, I have three espresso machines and each one of them costs $100. But imagine if I had a lot more records, I may not be able to quickly add up in my head that I have this many espresso machines. So, I want to get a total. So, I'm going to add a trailing subtotal of the espresso machines. And now I got a row at the bottom of my TableView report here that shows me that the total value of the cost for my found set is $300. Now, if I go and show all my records again, you'll see now I've got $10,425 in my total. So, that total is going to be flexible. It adds up whatever is in my found set. I can also sort right here in TableView by simply clicking again in the header arrow and choose sort ascending by category. And then once I've got things sorted, I can add a group or an extra row. So, I'm going to go ahead and add that group. And I can take that group by again, control-clicking or right-clicking and change the color. So, maybe I'll just make that a pale yellow so it stands out. But now you see my subtotal, because I already had that total in the cost column, it has picked up the subtotals for my categories. So now I've got that report my boss asked me for of what's the total cost of our assets by every category. And I can quickly, I could print this out or I could say this is a PDF. But, you know, I may want to make this something that looks a little neater. It doesn't so much look like TableView or look like Excel. I want something that looks nicer, has a little more formatting, and also is something that my boss can do on his own. And that's where the basic FileMaker Summary Report or Sub-Summary Report comes in. So, with Sub-Summary Reports, I'm essentially, I'm going to group data by a single field value or variable. The FileMaker materials frequently call that a break field. And over time, you'll be able to make many reports from the same layout just by changing the found set. And I'll talk more about that toward the end of the demo. And then with the Sub-Summary Report, you've also got the option to include totals if you need them. And that final thing about Sub-Summary Reports is it's really important to be reporting from the right context or the right table. And you set that up when you create the layouts for your Sub-Summary Reports. And so again, here's my spreadsheet, my starting point. There's no organization, it's just a list of assets with their purchase dates and costs. With a little bit of work in Excel, I can start to create that Sub-Summary Report. I've just moved the category column over to the left and made that into a break field. But I don't have any totals yet. And managing this over time would be really difficult, especially if I have many people doing data entry, because you'd need to automatic, like I can't just add now to the end of the list in Excel. I need to insert my new rows under the right category in order for this to be a useful report. And if I jump over and create this in FileMaker, now I have that flexible report where I can add a new record and it will automatically then sort into the right category of the report, automatically be added to the totals. And I don't have to do any additional work. So let's now talk a little bit about the anatomy of the FileMaker Sub-Summary Report. So this is the report, this is sort of the top half of the report. And that is a leading Sub-Summary part, which is my category where all I've got in there is the category label or the field that is that category appliances in this case for the first group. And then down below that, I have a trailing Sub-Summary part, which includes again that label, that category field, and also the total or the subtotal for the cost of all of the assets in the appliances category. At the very top of the screen, when I'm looking at this on a computer or at the very top of the every page, if I print this report, is the header. And in this, I've got a label telling me what is this, this is the asset report. And then all of my column headers. And then finally, if I were to scroll my screen down to the bottom, you'll see at the very bottom of my screen, I have what we call the footer row, or the footer. And that would print at the bottom of every page or stick at the bottom of the computer screen if you're viewing on screen. So let's talk a little bit more about the Sub-Summary parts themselves. Those parts are used to group the records and reports, and they only display when the records in the found set are sorted. If their records are not sorted, you'll just see the body and not any Sub-Summary reports. And as you saw in those previous, that previous example, it can be very helpful to have two Sub-Summary parts for every field you're sorting by on the layout. You have that leading Sub-Summary part to start your subgroup and provide the category label or other information about that category. And then you also have a trailing group to end that Sub-Summary subgroup and contain any subtotals or counts that you want to add. And a little bit more about what field data is displayed in Sub-Summary parts. If I have a leading Sub-Summary part, I'm going to display the data from the first record in my subgroup. If I have a trailing Sub-Summary part, I'm going to show the data from the last record in each subgroup. So it's really important to only include your category data or the data that's the same across the entire subgroup in each Sub-Summary part. And a final point is you don't want to allow users to edit data in those parts because they're not actually going to be editing across the entire category, they're just going to be editing in either the first or last record. And including other data can really cause confusion. In this screenshot I've added the purchase date to my leading and trailing Sub-Summary parts. And as you can see now in the leading Sub-Summary row or part, I've got appliances, which is my category, but I've also got the purchase date of that first record in the subgroup. And then in the trailing Sub-Summary part, I've got the purchase date for the last record in the subgroup. And then the common information of the appliances in the sub-total. So again, including those fields that are not common across the entire subgroup can lead to confusion simply because you don't know instinctively or users aren't going to recognize that that additional data is not coming across the whole subgroup, it's just coming from the adjacent row. The other key element of a Sub-Summary report is the summary fields themselves. And a summary field is a special field type in FileMaker that aggregates data across a group or subgroup of records. Calculation fields do math across a or do a calculation or operations across all the data in a specific record or row in FileMaker, whereas summary fields aggregate in a single column or field across all of the records in a found set. The most commonly used summary field types are total, average and count. Total and average can only be performed on number fields or date fields and count can be used on any field type and will count up any field that has data in it. One other tip I have is that you only need to have one summary field per data field in your database because the way summary fields work is depending on where they're placed on a layout they behave a little bit differently. If a summary field is placed in the header, footer, body or a grand summary part it will aggregate all the records in a found set. And if you place it in a sub summary part it will aggregate only for that subgroup. So now let's dive in and work through the exercise in the training series. And again I'm using the exact steps that are outlined in the FileMaker training series basics. Exercise are example 16.1 and I'm using the files that are provided as part of the training series basics. And I think later on we'll make the link to download both the training series basics and these activity files for you. So the nice thing about FileMaker 13 is the wizard walks you through all the steps when you create a new record and or when you create a new layout. So it will create your sub summary parts automatically. It will help point you to how to create a summary field if you need it and it will also create a script so that your report will always display the way you expect it to. Now I had it hide so I'm going to close up my assets converted and I'm going to go ahead and open up the equipment rentals example. So when I start you know I'm looking at the asset details so here's all my assets and I'm more nicely organized layout and I'm just going to go into layout mode and create a new layout or report and for this I want to show records from assets and I'm going to call it my asset report and I'm going to choose to display this on a computer and as you see if I choose computer I should get options down here at the bottom that tell me what do I want it to be and for some reason FileMaker is not cooperating with me. I can also select printer and here you'll see I've got options for labels, vertical labels, envelopes or report. So if you ever do need to print mailing labels you can go ahead and use the wizard to walk through the steps to create labels and it will ask you questions like what fields you want to include on the labels and what label template are you going to use and a little properly size them for a vast array of commonly available labels. But in this case I'm going to select report and choose continue and now the report wizard starts and it asks me questions like do I want to include sub totals and grand totals and of course yes yes I do and now I'm going to specify the fields I want to include in this report by simply double-clicking I'm going to move over asset ID, the item, the purchase date, the in-service date, the cost and the category and if I get these not in the right order I can use these little arrows to move things up and down in the order and this is going to be the order they appear on my report left to right in columns. I can also say oh I don't actually want to include this and go ahead and click clear to pull something out that I didn't mean to include. Once I have my fields selected I'm going to go ahead and click next and now I'm going to specify the category so I'm going to go ahead and categorize this report by category and this checkbox right here will turn on or off including the category field in the body of my report as well. So I would see it in both my subsummary part and also in the body. In this case I'm going to pull the category out of the body because I don't want to repeat it in every row and again I'm going to click next and now I'm going to choose additional sort fields. So because I'm sorting by category and summarizing by category I need that in my sort order and I'm also going to add in-service date for this report. I'm going to go ahead and click next and now I can specify the subtotals or the summary fields I want to include in my report. So I'm going to go ahead and click specify and look and I see there's no summary fields specified in this table yet so I'm going to add one and I'm going to call this cost total and my tip what I like to do when I name my summary fields is I name them by what is the field I'm summarizing in this case cost and then what is the summary I am doing the total the average the count etc. And that way it will if I show my fields in alphabetical order cost will be immediately followed by any summary fields in this case cost total. I'm going to go ahead and click OK and click OK again and now I'm saying okay I've got a summary field cost total summarizing category and I want to put that subtotal below my record group and I'm going to go ahead and add that subtotal. It's the only one I need for this report right now so I'm going to click next and now I'm going to choose that same summary field I just created my cost total and add it as a grand total at the end of the report. So now I'll have all my subgroups and then I'll have a grand total at the bottom of my report. I'm going to go ahead and click next and now I can specify any additional information beyond the field labels or the column heads that I want to include in my header and footer. So in my header I'm going to also include my layout name which is asset report in the top left and down in the bottom right on the footer. I'm going to include a placeholder that will always display the current date and again I'm going to click next and the last step is do I want a script for this report? And you almost always are going to want to script because it will give users a way to quickly get to that layout and sort the records properly to display any summary parts you've included and if I check automatically it will run always if a user just navigates to the asset report layout and I do want that to happen. So I'm going to go ahead and click finish and now FileMaker leaves me in my report in layout mode so I can do some tweaking. So as you can see I've got some things that are cut off. My asset report is cut off and since I had to choose a print layout because of something weird happening I'm going to go ahead and also change the theme from enlightened print to enlightened just because I think that looks a little bit nicer and it's a little easier to read on screen. I'm going to drag out this and I'm just going to do a few more things to line things up. So I'm going to grab all my fields make them taller so that I can see everything in them. I'm going to move over my cost and my cost column, the label and the subtotal. Just base things out a little bit more so that it looks a little bit nicer and then the last thing I'm going to do with the cost is format this as currency since it is currency data and to get to that formatting I'm going to select the data tab of the inspector and scroll down to the data formatting area and choose to format as currency with two decimal digits and the thousand separator to make this easier to read. Then I'm going to go over to the appearance tab and choose write paragraph alignment for that cost column and the the total and sub and the two totals and that's simply because that's how we expect to see numbers displayed and the last thing I'm going to do is move that category label over at the bottom so it's closer. I'm all done so I'm going to save that report and go into browse mode. Now you can see my report but I don't have my some subsummary parts. What happened? It's because when you move from lambo to browse mode I don't run that script so I can just go ahead and run my asset report script now that FileMaker so kindly created for me and now I have my report so I've got my header I've got my leading subsummary part I've got my body of all the record data that falls under the appliance category and then at the bottom I have my trailing subsummary for appliances with the label and the subtotal and then the same for the camera group same for the computers group and so on and as you see my header is staying up at the top stuck my footer down here at the bottom is staying stuck with today's date if I scroll all the way to the end of this you'll see there's my grand total of ten thousand dollars in all of my assets so that's how to create a basic subsummary report and of course you could probably do it much more quickly than I did if you're not talking about what you're doing every step of the way so now you've got your layout set up and you may want to go back and edit your parts you may decide well I don't really need that trailing subsummary part I just want to move my total up or you may want to add additional subsummary parts so you can also go back and edit layout parts after the fact and if you're in layout mode that use the layouts part setup dialog box which looks like this and it shows you all the parts that are included in your layout and anything with a lock has to be in the order it is and anything with the arrow you can move up and down and then I can click the create button to create a new subsummary part if I need it and that brings up the part definition dialog and so in this example I've said oh I want to add a subsummary when sorted by customer name and then you have a few other options as well you can choose to put a page break before every occurrence of a subsummary part and that lets you do things like print a report for invoices overdue for all salespeople and then distribute them by salesperson so you hand each salesperson that report or I've done examples where I'm creating a whole lot of classroom rosters for students enrolled in a group of courses and I want to be able to sort by either the course or the instructor name so I can hand that roster to each instructor so I can print everybody at the same time rather than having to do each class individually and I'll let's talk a little bit more about summary fields you can edit and create summary fields via the managed database dialog box or via adding fields in the new file maker 13 field picker and then once you add that summary field you'll see the options where you can choose which summary field you want to what type of summary field you want to create and then what field it is you want to summarize just as you do when you're using the layout or report wizard so that I hope is a good introduction to file makers most common report type some summary report and now let's talk a little bit about charting so as you can see in this iPad dashboard image it's very nice to have that visual display of information and it's possible to put many charts in file maker on a single layout for this example though I'm going to use quick charting to create a simple chart and put it on a layout so as we talked about earlier charts really give you a visual display of data and aggregate it up to do something informative to make it easy to understand your data and to show relationships in data things like price changes over time or relative performance of people or you know a breakdown of assets and the easiest way to get to charts in file maker is by working with the quick chart set up quick charts are great because they give end users the ability to create charts on the fly ad hoc right at their fingertips and I like to use quick charts as a starting point for a chart I'm going to put on a layout either as a standalone chart layout or as part of a bigger dashboard quick charts can use you can start from any view in browse mode it can be a list view a table view or a form view and to get to quick charts you just simply right click in the field you want to chart by and quick charts is easiest for setting up simple charts like column and bar charts pie charts line charts or area charts so let's dive in and do a quick chart demo of creating a simple column chart so I'm going to be I'm back in my equipment rental solution and I'm already looking at my asset report and I want to see the relative number of assets that I have in each category so I'm already sorted by category so this is great so I can just click right into any any field actually I need to do this where I can click into the category field which I cannot hear so I'm going to go back to my asset details layout but my data is already sorted so I'm going to now click into my category and right click and you see down here in my contextual menu I have the option to chart by category I'm going to go ahead and select that and I've now got a preview of what my chart is going to look like if I have a really big data set or really slow network connection back to a server I can choose to use sample data instead of actual data but most of the time I choose to use it's actual data and as you can see I've got these hot zones on my chart preview where I can set things I'm related to that part of the chart you know what labels do I want to use on this x-axis what do I want to call my x-axis title well I want to call my chart not category count I want to call it assets by category and so if you saw when I clicked on that it gave me the area in the chart inspector where I can type in the new title and so I want to use this I'm going to keep this as a column chart but as you can see we have many other options as well and then I've got some other options so once I've got the basic information my chart set up I can go ahead and close that part of the inspector and bring up the styles so when I'm looking at the styles I can choose well what do I want my chart to look like do I want the solid flat lines or do I want you know solid 3d columns or shaded 3d columns and so on I can choose the background fill if I want to change the background color and I can also change the color scheme so FileMaker will usually select a color scheme that you know matches well with on the theme you have selected but you can always change that to a different color scheme and then I'm going to go ahead and if I'm an end user and I don't have layout creation privileges in a solution I can go ahead from here and just choose to print that chart print it to paper or save it as a PDF and I've got that snapshot view of a chart as a database administrator or developer I can also go ahead and save this chart as a layout because it's something that other people may want to use or may want access to so I'm going to go ahead and do that and save this chart as a layout and included in the layouts menu so now what I've got is my new chart my new layout here with a chart as you can see it it's all there I have to scroll it a little bit on my screen but there it is it's a new layout and when you create a chart FileMaker creates a charts folder and then drops all those new layouts into that charts layout folder so as you can see I've got that chart set up and one tip about charts is if I go in and unsort these records I get something that really doesn't look like what I expected and so one tip for troubleshooting charts is if you see a chart where you've got a whole lot more bars than you expect and they're all the same height that implies that you're doing some sort of chart based on summary fields and in order for those summary fields to give you the subtotals or this that you're looking for you need that data to be sorted so I'm going to go ahead and click sort sort by category and in service state just like I was before and as soon as I sort you'll see my chart comes back I'm going to go ahead and close that window and go back to the presentation so just a few closing thoughts as I wrap up the demonstration portion of this seminar always begin with the end in mind when you're building reports think about what's that end result you want to get to I want to see a summary a categorization of my assets by type I want to see invoices by salesperson or invoices by quarter and it's also helpful to just kind of pencil and paper map out the report you're looking for or if you've already got reports that are produced in Excel or in another format look at those reports and then mimic them or recreate them in FileMaker and it's a lot easier to start with that roadmap of where you want to go than with a completely blank screen one other tip is play to the strengths of FileMaker FileMaker is really good as you saw at subsummary reports things like crosstab reports or pivot tables are possible to do in FileMaker but they require some calculates some calculation skills and a little bit more heavy lifting and if that is something you're interested in doing the FileMaker training series advanced reporting module has some exercise in is an examples of how to set up that kind of report and finally when you're thinking about reports separate the presentation or the report layouts from the data that's presented in those reports and what I mean by that is the same layout can frequently give you many different reports simply by changing the found set that you're looking at you know so for example I created this report of all our assets for my boss he said oh that's great but one thing I'd really like to know now is how many assets are we going to need to replace in the next couple of months because we have a business rule that says we have a three year replacement cycle from the purchase date of an asset so can you show me all the assets that we have right now that are already three years old so yeah I can do that I can find those records I'm gonna go into find mode here and on my purchase date I'm just gonna say find everything where the purchase date is less than three years ago which is 8 20 2011 and I'm gonna go ahead and perform that find and now if I switch over to my asset report layout that asset report is only going to show the 10 records in my found set right now so I go over to that asset report I see that well we have you know those 10 records and we have you know two appliances with a total value of $250 and so on and the total that we need to replace is $2,350 so that's what we need to plan for in the budget as we go get ready to replace and he may also say well how many assets are in each category this is a short enough list I can probably do it just by counting but if I had hundreds of assets if I had a hundred in my found set instead of just 10 that's where my chart can be really helpful I'm gonna go over and look at that and now I see well the biggest category we need to replace is office furniture followed by you know telephone's camera and appliances all the same and then computers luckily we only have to replace one of those those are the most expensive asset that we have in our inventory so with that I'm gonna turn the control back over to Ryan and we'll answer all the questions that I'm sure you have all been busily entering as I've been talking thanks Rosemary has a fantastic presentation we covered a lot of information here so if you have a question go to the go to webinar control panel click on the question section enter question and click on send so let's go ahead and get started and the first question that we have is Rosemary can you go a little bit more in-depth in the difference between the pivot tables and the cross tab reports so pivot tables and cross tab reports are essentially synonyms for the same thing I mean it's essentially it's a report where you're looking instead of in a sub summary report I'm looking at a list and I'm grouping things together in a pivot table I may be doing a secondary categorization you know so I'm thinking a common common when we we do in our in our everyday work is we look at sales by salesperson and quarter so down the left edge of my report I have all my salespeople and then my in a traditional sub summary report I then have subgroups for each quarter under that salesperson and in a pivot table or a cross tab report I actually pull those subtotals up to the top so across the top I will have q1 q2 q3 q4 and then I'll just include the totals there and get rid of the body data of the specifics of each invoice and again the best way to learn how to do those is to use the example that's in the file maker training series advanced excellent okay the next question can you lock a report so that other users cannot sort it so can you flock a report so that other users cannot sort it what you can do is you know have it sort by default but users are always going to have access to the sort command in file maker so they could resort that report and get you know a different result as you saw the summary parts are just going to go away if they unsort or sort it in some other sort order than the one provided for your report okay the next question can I create reports on two different categories yes that's a great question and let me show you how you would create a report on two different categories so I'm going to go back to my equipment rentals example here and as we saw we made our asset report and here our categories were appliances or I mean the category was the asset category if I actually have in addition to the things I'm showing on this report right now is I also have customers so maybe I want to see my assets broken down by the first first by the asset category and then also by the customer so I can see you know which customer has which category and how those categories are broken down by customer so let me go ahead and show you how to do that so I'm going to go edit my report layout here and here I'm going to bring up that part setup dialogue I mentioned earlier and I'm going to create two additional subsummary parts when I sort by customer ID so there's customer ID I'm going to create it once and say printed above my body and there you can see it now and now I'm going to create a second one to be my trailing so I'm going to sort by the same customer ID and print below and then one other tip for best performance of subsummary reports you want to have the pairs of subsummary parts going out kind of in order stacked like layers of an onion from the body so first I have the body in the middle and then the next layer out I have my two customer ID subsummary parts and then out from that I have my category subsummary parts you want to have them stacked in that mirror image order as it turns out it doesn't matter what order they are in the part setup they're only going to display in the order based on how you sort your report so I'm going to click done here and then I'm going to do a little bit of work here I'm going to add my subtotal I'm just using the option drag command to duplicate it and put that into my subsummary when sorted by customer and I'm going to bring up the field picker and bring out a couple more fields I don't need any labels here so I'm going to bring out the customer ID field right here and then also go grab the company name for the customers get rid of the field picker and then I'm just going to bring again I'm going to bring that customer name down here so it's in that trailing subsummary part as well so now I've got my data picked up and the other thing I'm going to do is maybe I want to change just for clarity I'm going to change the background fill color of this of my customer subsummary parts to just be a little bit darker blue and I'm going to do that for both the leading and trailing parts so we have a little so you can see a little bit better what's happening in my report so now when I go back into browse mode you'll notice you'll remember when I was first sorted I was only sorted by category so I'm only seen my category so I'm going to go ahead and show all my records and sort this again this time by category and then customer ID and then in service state so now when I sort this you'll see I have my my subgroups my secondary categories coming in so first I have my appliances group then I have my customer subgroup and then one espresso machine at Mountaineer wine shop then I've got my next customer and their appliance assets and so on and as you can see I have a little error here that my customer IDs are showing as currency but that's easy to fix later and I'm going to go ahead and sort again this time I'm going to pull category completely out of my sort order and just sort by customer and now I can see assets assigned to each customer and you see now I've only got my customer subsummary parts my final option is to change that sort again I can sort by customer and then by category and if I do that what I'll see is I'll see my customer parts on the outside and then broken down by assets broken down by category inside of each customer subgroup and so again if I go up to the top first customer is Westside antiques they have computer and a telephone thousand dollars worth of assets assigned to them next is the Mountaineer wine shop and they have a whole bunch of assets assigned to them next is Abbott securities and so on and so again you can use a single report layout to create all kinds of different subsummary reports simply by varying the sort order and including or not including specific categorization fields in that sort order and then also as we saw earlier by changing the data in the found set or the records in the found set to change the data that's presented on that report perfect explanation thank you okay so our next question do you need to create a separate report layout for printing and viewing on a computer so you do not need to create a separate report layout for printing and viewing on a computer but you may want to simply because you know this report layout would print fine to a color printer but you're going to use a lot of toner and it's sometimes hard to read a printed page that has a lot of shading happening so we do generally recommend creating separate reports for printing in and computer but it's not a requirement if you do want to use the same layout for both my recommendation would be to stick with a print friendly layout that doesn't have you know that black black shading in the header and so on simply because then you'll get something that is easier to read when printed as well as on screen and kind of in the same vein do you have to create multiple layouts for you know an iOS device for example or will FileMaker automatically take the reports that you created and resize them so FileMaker can resize the reports for an iPad pretty easily if it's created for an on-screen view for the iPhone you're probably going to want to create a specific layout for that tiny form size you know but one thing to think about is you know in general when you're out and about with your iPhone you're not going to probably want to look at the full report of all the assets you may want to see a quick chart of you know how our assets distributed amongst our customers or you know a quick you know high-level view but you're not going to be looking at this full complete report one one other solution for showing reports on iOS devices is to rather than trying to show them in FileMaker go use a print layout and save a PDF so then you can quickly send out your reports from your iOS device and get them distributed to your customers for example for a service contract or a work order or an invoice you can just because you can't see it well on FileMaker go you can still create a PDF from FileMaker go that is a more standard eight and a half by 11 inch piece of paper size and then attach that PDF to an email and send it out from FileMaker go excellent and our last question of the day Rosemary can I use portals on my reports so you can use portals on your reports but it's not really recommended and the reason for that is when you set up a portal on a report or on a layout you have to specify I'm going to include five rows so now what do you do if your portal has more rows than five in your report when you're thinking about context for reporting you want to always go down to the deepest or the deepest record level or the deepest table level for that report and base your report on that table you know so for example if you want to do an invoice report where you include line items from that invoice you'd want to base your report on the line items table rather than the invoices table you know or if you're looking at student data where you have three tables one for students one for classes and then a table in the middle what we call a join table for enrollments you'd want to print your class rosters from that enrollments table and then categorize or summarize based on you know either students if you're printing a student schedule or bait or you know the class title or the course number if you're printing a roster excellent and before we continue just I wanted to direct everyone's attention to the go-to webinar control panel in the chat section we've posted the link to the filemaker training basic series where you can download the activity files that Rosemary used today and so just to wrap up again I want to thank everyone for coming I just want to talk about some of the resources that that I've mentioned as part of the presentation and then also some additional resources that are great for pointing you toward best practices for reports and charts I'm first again the filemaker training series basics covers quick charts and the simple subsummary report in the reporting section and then the filemaker training series advanced reports module goes it but into much deeper detail on creating more advanced subsummary reports where you do multiple levels of categorization and then also creating pivot tables and other you know other tips and tricks for reporting and charting and training series basics is free you've now got the link to download both the ebook and the exercise files and advanced is available for a small charge and you can learn more about that from the website on your screen another excellent resource for anyone doing filemaker development or learning more who wants to learn more about filemaker is the free filemaker technical network on this is our developer community there are extensive forums where you can get tips from expert users from around the world I know back in the day when I was a filemaker developer I'd post a question before I left work on the east coast of you know I'm trying to solve this problem how do I do it and when I came back in in the morning early morning I'd frequently have an answer from a developer in Australia or New Zealand or somewhere in Europe who'd seen my question when I was asleep and you know very kindly taken time to answer that question in addition there's a bunch of free resources available to tech net members only including technical briefs like our very extensive technical brief on charting and that tech brief covers all the different chart types available on filemaker and when you'd best want to use them and then how to set them up and then how to go from creating a simple chart on a layout to a more complex dashboard where you include many charts and other performance indicators on a single layout and we also have many members only educational web seminars like this one but on a deeper technical level and we also release periodically recordings of sessions from our developer conference so again it's free to join at fmdev.filemaker.com and finally some additional resources on filemaker.com forward slash support forward slash webinars you can see information about upcoming web seminars and also see recordings of all the prior seminars that we've done like this one and also in addition to the filemaker training series training resources we have partners all around the world who teach courses in a classroom based on the training series materials and some of them also do coaching so the classroom training is great if you're trying to learn the basics and the you know intricacies of filemakers use for things like reporting and charting and the one on one coaching can be great if you have a specific reporting problem or challenge that you're trying to solve and you want an expert to point you along the way to how would you solve this problem best and then give you the skills at the same time so you can do that again with other reporting challenges and in addition some of our training partners have done online video training for the websites linda.com and vtc.com and when I talk to people who are learning filemaker they report to me that linda.com and the vtc.com videos are some of the most helpful things they've have looked for or they have used as they learn about how to do things in filemaker so that's you know the end of the content we have today I want to again thank all of you for coming and spending about an hour with us and I hope this material was helpful and I would ask you to please send us feedback and let us know if this was a valuable session and we actually did this reporting seminar based on feedback from some of our other seminars we've done over the last year when it turned out that reporting was the one question everybody had the most about so we decided to pull together some resources and present this as a seminar based on that feedback so thanks again for coming and have a great day


It's very hard when you have war in your country. It's like a dream or it's not a good dream. Before 10 years, we had a good life. We never, never, never had things to go outside Syria. My heart is very hard, but I tried my best to just explain to my children always to talk about Syria before the war. I remember when I was a child, I was a boy here. It's my school, it's my work. We have like a car dealership and a sweets factory. And when the war started, it's very hard, very dangerous. And I lost everything. First, we were in Syria. Then when the bomb came on our house, my dad, he got our car and started driving. So then they stopped us. They said, give us the car and we'll let you go. We gave them the car and they let us go. When my husband just turned on the TV to see news, please stop, please, I can't. I know it's hard because I know what's happened in Syria. Inside the war, how many people need food? How many people need home? How many people, their children, they lost their parents. We are the human. It's very important to support people, for the children, for their lives, their future. So when I first came to school, lots of people in my school were Syrian and knew how to speak Arabic. So they came to me and were like, here I'll show you around and everything. I had lots of, lots of friends. Because when I first came to Canada, I'm like, I'm different. Now I fit in.


You need a financial advisor with the freedom to focus on your specific needs. Whatever your goals, Reeve Potter can create a game plan tailored to you. Call Reeve at 432-0777 at Pikeville, Kentucky to learn more. A creative call-out is being held in downtown Williamson at downtown Yogo where artists, crafters, educators, musicians, and other community members are invited to voice their opinions on ways to grow the regional arts community. Creative call-outs are open meetings. We invite the public to share their ideas on how to grow the art community. The best way to find out what the community needs is to actually ask the community and if they want to take the time to come to these meetings. We'll listen to any ideas for events or for city verification that they have and we end up using a lot of them. The goal for this creative call-out is for local artists and artisans to form a co-op to support those who may be vending as a side business. We're hoping that the more artists we have that are interested in form a co-op, it just makes it strong. It can help them either through resources or sharing ideas, help them make that next step to where they want to go as far as relying mostly, trying to grow their business from a side business to a more permanent thing. The meeting will take place at Downtown Yoga on Thursday, February 9th at 6 p.m. For more information or updates on future events, you can visit the Heart of West Virginia Facebook page. For Mountain Top News, I'm Kelsey Deem.


What's good y'all it's your boy Ross back at again with another video and I don't know what the intro was about But happy New Year's to you guys. We are in 2020 now. This is the very first video on my channel for the new year I just want to say thank you so much for all the love and support Last year wrote the 10k this year and beyond so y'all like the last video y'all was really rocking with it last week So we're gonna continue this best moves of 2006 a great time for wrestling in WWE actually He actually has all the parts up. So we're just gonna go through one by one and check him out man So hopefully everyone's having a fantastic New year so far, you know I'm saying we just got a lot of great things Coming to this channel and in the clutch page and we're just trying to keep their positive mindset throughout the year man So let's get into it. Hopefully y'all enjoy your holidays and let's check it out This was a good WrestleMania, I want to say this is WrestleMania What WrestleMania is this I really feel bad that I don't know what WrestleMania. This is hold on Well, let's do some research. I believe that's 22.  Yep. April 2nd, 2006 WrestleMania 22. I had to check man I ain't I ain't want to be the one of those people that didn't know and just said a random number So sorry about that. I'm getting old man. I'm getting over telling you she'll the Benjamin was Full This was a good WrestleMania I Think this was the first WrestleMania with the money in the bank ladder match. This was the very first The inception of that match money in the bank I miss it when it was just at WrestleMania.  It doesn't have the same type of Like mystique to it because we get it all the time now. So now this was a good match this This hardcore match, this was hardcore My god, y'all this was Edge was this was oh my y'all edge Mick Foley, they really They really put it all on the line, bro to entertain us. That was Hello, hello dope The spirit squad Dobs Ziggler fun fact, I don't know if y'all know Dobs Ziggler was a part of the spirit squad. I don't know if y'all know about that. So This was a nice nice little visual, bro That was dope. Look at that. That was dope That was a good. This was a good match, too. This was a really good match Ray Mysterio Kurt Angle and Randy Orton Fantastic wrestling match. Oh Young Randy Orton in his prime and The legend killer That's when they were wrecking shop as tag team champions the big show and came God damn Hope it's this lawnmower y'all Wow, bro shame, man RPU Maga man That's a lot of weight, bro Someone had mentioned on the last video that even Michael Cole's commentary was way better than what it is now And this is true Taz and Michael Cole on commentary for Smackdown. It was pretty good at the time. It was still like, you know saying It wasn't the same as JR in the king, but Taz Michael Cole on commentary actually worked back in this time period It was it was actually actually good commentary They had a nice balance between each other. It's not much You don't really hear that nowadays when it comes to Cole commentating because it comes off so cringy and lame But back then it It just worked it worked. It was it was suitable for the time period Wrestling in the threes this is this got to be backlash that feud that was having Shawn Michaels and the big man's going against each other. That was a pretty decent few. Oh Yeah Yo Tag team and tag team division was pretty oh Jesus nuns. Yo Look like I was in the tag team division at that time. It's pretty good. Oh Geez, bro, don't share shots I hated the spirit squad Oh He sold the kicker JR with the no no now that was a nice move Man angle slam the table didn't break table didn't break. I got you Squared his head with a chair. Oh my god, bro So many good memories. I don't know how Mick foley even has any news left That's a lot of hype, bro Yo Kurt Angleman he was the guy on SmackDown, bro Oh This is around the time they were really pushing umaga as a as a very serious threat in WWE Bro, Ray Mysterio was that guy too and RVD Ray Mysterio was that guy Look at this, bro Yeah, that wasn't supposed to happen that definitely was not supposed to happen Oh My god, bro, it's just dog the Mexicals It was pretty cool bear Not gonna lie man. They when it came to wrestling. It was pretty cool bear Oh So blue is a savage too. Oh ECW one night stand man.  Oh my I don't know Oh Man, oh man brother this you don't get this you don't get much stuff like this Much anymore, bro. Like this is insane. Look at this Bob. Nick foley is a god of my man.  I'm not advocating for guys with their hands on women But I'm just saying that everyone was treated from the most part equally so Women weren't safe when it came to getting into the ring. It's just they just weren't so Look at the dent This is one RVD won the championship Nobody wanted John Cena to win this Nobody cuz he had cashed in his money in the bank To he cashed in his money in the bank briefcase to win it here This is when they started with the ECW brand which ultimately didn't really go Where should I went like it? It was it was riddled with WWE's like DNA all over it They didn't it's not like NXT NXT has his own feel ECW was supposed to have his own field But it's basically it was just another brand they added to to I believe it was on sci-fi at the time So it didn't have its own identity even though it was a different brand they gave its own championship But it just it couldn't It couldn't really like match up Cuz ECW has always been its own thing That's what made it what it was and then they tried to bring it to the mainstream Didn't really last as much as it could have or should have They built some decent stars on there.  Yeah, that is that takes a lot of strength, bro Even raw had some pretty good Pretty good matches pretty good segments, but I still feel like SmackDown just was the The better overall show in my opinion. Oh He caught the corner of the table, bro. So that boo Just didn't care it didn't care about his body Most of people that was in ECW they didn't give a damn about their body. It was all about Carnage and destroying yourselves for the entertainment of us. So oh, man Like Mick Foley don't care about his knees. So who didn't care about his neck or his back or his body in general Telling you bro. It's spirits quite like everybody hated the spirits quite The bounce on the green There's definitely some weird moments around this time too Oh man Very entertaining very entertaining. This is only just the second part I hope you guys enjoyed that video comment down below What was your favorite part from this video? a Moment that stood out to me and it will always stand out to me WrestleMania 22 that hardcore match edge Mick Foley going through a flaming table seeing that was like Yo, what am I watching? This can't be real. They literally just set themselves on fire That was intense. It made edge It pretty much catapulted edge even more than where he was it catapulted him into somebody that can really hang with the legend and The fact that Mick Foley was all about putting people over that was dope I enjoyed that Mick Foley is all about making sure the proper talent and everyone You know benefits from it because he's had his time So for him to put edge over as like this new hardcore Individual I'm all for if that was a memorable moment for me but comment down below What was another memorable moment from this video some of the clips we checked out in part 2 or just a memorable moment from? 2006 in WWE so that was one of my favorites, but I appreciate all the love and support 2020 road to 10k. Let's get it. I'll see y'all on the next video. Peace


Hi everybody, and welcome to the Lakeland locker room. Once again, I'm John Weber, joined today by Jim Zabrowski, the head football coach at Lakeland College. Jim, as usual on the show, we like to get right to it, no messing around, of course. Well, first off, congratulations on your first victory as a head coach, first victory at Lakeland College. The season-opening win over Tri-State from Indiana, what a great game, a 30 to 13 victory. Yeah, well, it was fun, you know, almost to say I was, you're nervous, you're excited, all the above, and all of a sudden, and everything happened, and thank goodness we came out of the win, the kids played exceptionally hard. We had a few too many penalties in the game, fell all over ourselves, but the kids played really hard, the effort was great, I thought the crowd was great, I thought the excitement was there, the stadium looked great, I think it was just a fun atmosphere back there, and the kids, I think enjoyed themselves playing, which is a big thing, and we came out victorious. Of course, Tri-State's had a legendary program, very successful the past few years. A new coach this year, and Bob Fry, the former coach at McMurray College, how did you prepare going into the game? I know we talked a little bit about this on our last show. We watched a lot of tape where Bob was at McMurray, thank goodness they stayed primarily on the stuff they showed. That first couple of games, you never know what you're gonna see, they could throw stuff at you, so Bob stayed a lot on what they did on the tape we saw from McMurray, and we kind of, I mean, we're pretty good friends, so we talked a little bit about what each one of us does, so we were not totally blind on the deal, so we actually kind of knew what was gonna happen, and then all of a sudden he's got a lot of the kids playing, I didn't know if our kids would, I didn't know, I didn't know what happened, I didn't know, you can't tell on tape how big kids are, how fast kids are, and I was really pretty aware, I thought our kids played physical and fast, I think that helped us out, because once we had preparation, you know how it is in baseball too, you can prepare all you want, sooner or later the kids just gotta play, and they played it pretty well. And preparation is key, how do you guys prepare for that before the game, and this is a 1.30 start on Saturday, and of course next week versus Carter's is gonna be completely different, but how do you guys do it on a Saturday morning, what do you do personally, and what do you do with the team? Right, Saturday morning, this week we ended up, our coach was out there, Coach Crickard, defense coordinator was climbing up a scaffolding in a shirt and tie, trying to move that back a bit too close to the end zone. We had a lot of game day preparation to do before, sometimes you love playing at home, but the things you have to do before the game takes a lot of time, more than I thought it would take, so we were doing our preparation, getting stuff ready, making sure the field was ready, getting the kids at breakfast by 9.30, have a little meeting, I think what we try to do here is what we did where I've been in the past, is if you don't know what you're doing by Friday or Saturday, you're in more trouble than you could imagine, so we don't say a lot, we don't want to give them a lot of different thoughts, we just say, eat breakfast, quick meeting, we just wanted, I just told them, play our models, reach your full potential, I said, play hard, play fast, play physical, let the scoreboard take care of themselves, we didn't really give them a lot of different thoughts, we just said, go out there, I think our kids were so excited, hot day was like 87, 88 degrees I think, I think some of our kids were like, got so juiced up, they started cramped early, but I think as a game wore on, our conditioning helped us out, because I think we kind of wore on them as the game went on, but we didn't do a lot, just kind of get them loose, get them going, I think excitement just took over so fast for them. Let's talk about you personally now, where were you at as far as the game goes? In a lot of spaces, it's your first head coaching game, or first game as a head coach, so you got to feel a little bit of excitement, a little bit of nerves, but it sounds also that you were so busy, and so getting so prepared that maybe some of those things were secondary. Yeah, that's what I told my wife too, I said, I go, Heather, this game is awesome, you just show up at 1.30, the whistle's gonna blow, I'm gonna be like, whoa, it's game time, because of the preparation, cause all the things you do as a head coach, behind the scenes and stuff, you never have to do an assistant coach, you can watch tape, relax, get ready for the game, I have one little side of offense, or at that time, when I look at both sides of the ball, I make sure your special teams are okay, and all of a sudden the game just came upon me, so I don't know if I was so much nervousness, or maybe I just blew off the nerves that I won't get nervous, but it was exciting, and I think you were talking after the game, and I said, how did your first game go, so on, and it's not so much you're hoping you have more victories somewhere along the line, but just, you felt comfortable that kids were prepared, and you really said, I've done all I can do, I think, not only I just let the kids play, don't overcoach, don't get nervous, I didn't want them to show that I'd be nervous, or get too excited, or to whatever you wanna call it, so I wanna make the kids realize that, hey, have fun, I told them, I go, just have it, I try to have fun, it's tough having fun, I mean, you're getting nervous, you just have fun, it's a great experience, it's great, I'm blessed to be in this profession, I said, kids, just have fun and play, realize how lucky you are to be a football player at a college and play on Saturday afternoon. That's a few and far between to get that opportunity.  We went three and out that first drive almost, and we got the fourth down, and what we have seen on tape was they do something where we just set up a fake, if they line up in a certain formation defensively, we just run the fake, and all I have to say is tell the personal protector, yeah or no, yes or no. I told Matt, it was like fourth and 10, I think fourth and nine, we're on our 43 or 44, so it wasn't that terrible. Whereas I said, hey, if it's there, Matt, take it. And he took it, and I think it added, I think it got the kids to realize, man, this guy is, if it's there, he's gonna take it, I'm not gonna practice stuff and I'll run it, so they pull it off, we can see how they went about, oh, great call, but it's not a great call unless a kid's execute. So a good thing I've erupted so much, the kids felt comfortable. I think we have action set up here on tape, if you wanna explain it. Yeah, Matt Bairinger took it, we had to pull in both of our big guys, Nick Zeck, who's a basketball player, and Shane Shrimp, and we gassed it for 35, and you can see the excitement on the sideline, and they were set up, they had six guys on one side of the field, and we just took it the other way. Here's the second play, right after that, you guys went to the fullback out of the backfield, why don't you go and explain that? Yeah, we were pretty successful running in between the tackles. Travis Jervis played an exceptional game, dumped in the flat, they kept trying to stop the run, got our fullback in the flat, so I gained about 14. That play was really, we probably ran that play eight times in the game. This is gonna be our fullback again, Travis Jervis on the belly, sorry about that, I forgot what I put in there. Travis gained 10, Travis had an exceptional game of fullback, our old line just played outstanding. Here's Nick Hunter, ran up with 129 yards in the game, running power for about 17 yards. Power is just our bread and butter, pull the backside guard, we down block, and like I said, I picked kids play well. We rushed for almost 300 yards, which I think was a pretty good start to our season. Here, the play, the reason I love this play, not so much the touchdown pass from Brent to Courtney Gatlin. Courtney played about five, six plays a whole game. We tell our kids, be ready. We ended up playing, they ended up blitzing. We got lucky, we got fortunate in what they did, and we threw a touchdown. Brent did a great job, but I love how our kids were always prepared. Courtney played six plays, also one of the plays got out there, you never know when it's gonna come to you. It came, but the game, it's thought we saw some of the bigger runs, and we had, I think it just went over, it's six runs over, five runs over 15 yards. We had two passes over 20 yards, we call it explosives. We wanna try to get seven explosives, we got them. Nick Hunter played exceptional, marked us down for a freshman game of almost 50 yards. Travis Jervis, our fullback game, almost 50 yards, and we're alive, and I think we averaged about 5.6 yards a carry, and rushed it for 292 yards or whatever it was, really, got the numbers right here. 53 carries for 291 yards for 5.5 yards a carry, not bad. Yeah, a lot of people laugh after the game, some of the old guys who played here, I don't mean old and bad, but the guys who've been here the last 10, 20 years came back to me, I was, you know, I was great. They guys got bummed, and what we just tried to do is instill the kids, just be physical, and just believe what we're trying to do here, and I think when I started, when I got to run for the Catery after the game, and the kids were all excited, I think that's when I kind of broke down a little bit, and I said, wow, these kids really believe what we're trying to do.  So I find this guy's really pleased with the effort, the running game, you know, we missed some big plays in the past game, we have to get better at that, and we had three holding calls by wide receiver, so I'm only gonna throw a negative at you, John, just to make it real, but we got a touchdown call back, we had a 220 yard play that's called back because our wide receiver held, so we had a chance to go 400 yards off, and it's just rushing. Well, your first score, of course, there, we saw the first two plays, I went up to it, the fake punt, and then Jervis out of the backfield, and then Lukey punched it in. Right, Lukey, for my six yards.  What we're seeing here is a little bit different, and no offense, or pros or cons, what was done in the past, or what's done now, but what we're seeing a little bit, is a little bit longer drive, you get the offense on the field a little bit more, rest your defense, and I think it showed, because your defense played such a strong game. They did, they had six plays, Coach Crewe was laughing, we had six plays, Roosevelt more than summer for seniors, like, what's going on? Because last year, I think that caused the situation where they had some three in the house, they were back out there, and it's going to happen sometimes, it's going to happen this week, but I think we have the ability to sustain a drive when we need to. I think you have to, on both sides of the ball, defense needs to get in and out quick. Sometimes the offense has to go out there and sustain, and I think we ran the ball 13 times, and that drive, or 12 times, I think we threw the ball twice that old drive. It was just a Nick Hunter, Travis Jervis show, with those guys up front just doing an exceptional job, first time round, and actually run blocking for a while. Tri-state came back and scored late in the second quarter to make it 13 to seven at halftime. What did you guys say to your team at halftime at this point? That drive they scored on was, I think, and I'm wrong, but I'm going to throw out the number, I think it was 50 yards in penalties. It was two, we ended up, it was 15 penalties, like 190 or something, or 150 yards, so I thought we are disciplined, believe it or not, we are disciplined, they had two retaliation hits, we pushed the kid back, we got pushed, which is, we stopped that, there were none in the second half. Two pass interference calls, one was good, I thought one was debatable, but it happened, and we had two offsides by D-Line line offsides, we had six penalties, one drive, so honestly at halftime I told our guys, man, we can run the ball, which makes me feel good, and they have not done one thing on offense besides us giving them penalties, so I really told the kids, let's cut out the penalties, I was pretty stern, saying we can't retaliate, that it's just as bad, it doesn't look good, it's just not the way you play football. Stop retaliating, play football, it's supposed to be played, and I wasn't nervous, because I just thought we were in control.  Exactly, we're trying to sit back and being lazy. They were trying, our receivers were trying to get down, the other receivers didn't block a lot last year, because they were always thrown, so they ended up, we just got to work on that kind of thing, but it was aggressive, and the retaliation hits, where's the push, it was just, I just can't do it, because the second guy always gets called, and the late hit, I think we knocked our kicker out, we blocked the ball, though I thought it was a bad call, because we tipped the ball a few ago, and that was a late hit on the kicker, and then the quarterback, Nick's that question, well, got him late, but it was right out there, he is, he threw it, but you know, refs are gonna protect quarterbacks, but I love Nick's effort. We ended up having 10 sacks or something, so that quarterback, I think, might still be feeling it, come today. The third quarter, Tri-State came back and tied it up. Two things happened in this drive, I think that were very important to mention. First off, they only gained about 170 yards of total offense on the day, and I know one of them was 75 yards on one play. On that drive, yeah. Exactly, and that was one play that happened, and also I think after they scored, they had to miss extra point, which I think was very key, because instead of taking the lead, it was just 13 to 13. Yeah, because I wanted to see, we never got behind in this game. Being 13-13, I think we drove down, we scored a touchdown, which would have put us up 27, we got a holding call in the end zone, then we missed a field goal.  So now our kicker, like, jeez, what's gonna happen now, is this, and they missed that experience, and now the kids are like, hey, it's 13-13. Doesn't sound big, but I think sometimes the player, and it's like, hey, we're still even, but I kept telling the kids, they aren't stopping us. If they were stopping us, I think it would have been like, I didn't feel like they were stopping us. When we came right back, I think drove all the way down, and that next drive, I think we scored a touchdown, the next drive, answering their score, and kind of got the momentum back, because I thought their kids were tired, I kept telling our kids, they're the ones tired, you know, we're not tired, and so that's what made me feel good. And that's hard to tell sometimes in practice, translating for practice, to game, and see where you guys are conditioned wise. But I think one other thing too, again, you mentioned that it was nice, is how you guys responded. They missed the extra point, and the very next drive, you guys came back, and of course that was the play we just showed a little while ago when Loopke hit... It hit a quarter of a gallon, and it was like a five-player, on our short of five-player drive or something, yeah. Yep, so that made it 20-13, going into the fourth quarter, and we're gonna talk about the fourth quarter here, and then talk about, of course, your standout defense on the day when we get back. We gotta go to break right now, but when we come back, we're gonna talk about the last part of the game, and then we'll talk about the stellar defense, and upcoming game versus cartridges weekend. So stay with us, we'll be right back with more on the Lake Hill locker room. This is the story about a group of kids who volunteered. Doing something nice for someone. We fixed up. Did some art projects with the kids. We fixed up his house. We worked in the woods. Made up the park. Did something for the planet. We just did it. No other reason. And you know what? It was great. At first, they didn't know each other. Well, that didn't last long. This guy is really funny. We ace our new friends. Are you into it? Call for agent, check out our website at ruintuit.com. Before you know it, she talks. Before you know it, she walks. Before you know it, she knows you. Before you know it, she has a heart.  Before she's a twinkle in your eye, that's when you need to take folic acid every day. After that, it's too late to prevent some serious birth defects. Take folic acid now, before you know it. Hi, everybody, and welcome back to the Lakeland locker room. Once again, I'm John Weber, joined today by Jim Zabrowski, the head football coach at Lakeland. Jim, we were just talking about the game recap here. Let's talk about the fourth quarter. You enter the fourth quarter with the 20-13 lead. First off, what are you thinking right at this point? Feeling pretty good. And the reason I was feeling pretty good is I thought they were tired. I thought we were controlling the line of scrimmage. I didn't really care about score right at the moment. I thought we were controlling the line of scrimmage. So if we needed to do something, that fourth quarter in terms of eat up clock or get a turnover stop, I thought we could. So I felt pretty comfortable. I was always, you're always nervous when you're only up a score, because you always know one play could do it. But I really thought the momentum was on our side. I think that big play according to Gallant kind of knocked the last gasp out of Tri-State. And hopefully, we had a chance to put it away in the fourth quarter. And it looks like you did early on again. Oh, it's kind of midway through the fourth quarter. Cooked nail a 27-yard field goal to make a 23-13. I don't think that was a nail in the coffin yet, but it kind of gave you that little edge. It gave us a two-point. It gave us a two-score cushion. I'm nothing against kickers. I hate field goals, because we're kicking field goals a lot. I mean, we're not doing well in the red zone. And that drive, we bogged a little bit down there, but Matt came through. And we missed an extra point earlier, and a field goal. So I wasn't very happy with the kicking concept, not so much just the whole concept of the kicking game in that term. So we ended up getting it, though, pushed up by 10, ended up kicking off, stroking them on defense, getting the ball right back. And then we ended up with really a full-back laden. Vince Cooper, who came up for that drive, and drive and service just kind of took over. And we just ran the ball right at him. I think the biggest thing about that, too, is, again, it was just a rally-killing, game-ending drive. I mean, the fact that you scored was almost pointless, because at that point, you guys put a six-nother almost six-minute drive up on the board, and they had no chance at the end. Yeah, we talk a lot about it. There's two types. There's a two-minute off, and everybody knows you're behind, or at the end of the half, and you need a touch, and you need a field goal. And we call it a four-minute offense. A four-minute offense to us is there's between four, five, six minutes left in the game. We had the lead. Now, our job is to hold on to the ball, eat up clock. So we worked on that. We said, hey, man, ball security, and let's move the chains. And there was a couple, I think, third downs in there that we got, which helped us out. I think early on in the game, it would help us out. I think we went four-on-four down two or three times, and we got it. But that drive was just third. It was like a first and 10, second and six, third and two, first down. I kept looking at the clock, and I'm like, by the time I got inside the 10-yard line, it was less than two minutes. It felt pretty good, unless you turned the ball over and they returned it, that you were gonna get this thing done. Right. Well, let's talk about your defense. Again, just to stand out, play 178 total yards in the day, and the amazing thing is only 10 yards were rushing, which is obviously unbelievable. I think we have some highlights that we're gonna go to here in a minute, but anybody individually that really stood out for you. You know, we talk as a coaching staff, even an offensive, Andy, but we said, we're not gonna have that one. And this is no offense to our kids, we have great kids and they're a very good player. We don't have that.  I think it makes our whole union. The guys know, the guy next to him has to do his job. I mean, they trust each other.  You can go to lineback in Core Rosie and Vig had a sack or two rows above more. I had a good amount of tackle, Ryan Bannaloo played well and Sam Scherner was running wild. Secondary played well, he got a couple passes in fairness, cause it hurt us, but they got nothing in the pass game besides that one tight end pop pass when we missed two tackles.  They all just played as a unit very well. I just thought I kept seeing these bunch of blue and yellow jerseys just running after the ball care and seeing five, six, seven guys and the happiest I was, and this is gonna sound bad, but I always tell the guy that the quarterback makes it through the game without getting, if he wants to throw the ball without getting dinged or without taking at least punishment, you know, physical clean hard hits, you know, you're not doing your job and I think with 10 sacks and that kid ended up leaving a little bit, I had a mild concussion or we at least put pressure on him and did it clean and just play it hard, physical flip. I think that was an attribute to the whole defense. Great covers and great, we didn't blitz a ton. Yeah, but when we blitz, we got home. Well, let's go ahead and take a look at the highlight reel here. I know we had a couple of defensive plays that we put together here for you. And here's here, this is me. When you watch this, you're just gonna see 11 guys out there. I think this is the one, their play-actioning pass and they ran a lot of three-man routes on us. So they tried to max protect, here we're blitzing a little bit.  Jacob's special with six, three, 235 pounds out there. He's gonna make some running backs missed plus he can run and run back over if he needs to. So we ended up bringing six. Okay, you know the time we bring six, we never brought more than six on a blitz. Here, great pressure, we twist. We get great pressure from the back side. David Benz running about 100 miles per hour on the back side, forces the quarterback to throw the ball into the dirt with a great coverage. Here, they're in their pro side, not a play-action pass. End up getting a, one of the few passes they completed but the second they did a great job rounding that ball mark. Edmund Mats Wayne stroked that kid. If they're gonna complete a pass, he might as well stroke them once they complete it. Here's an outside run, players say they had a little, not much success with, that's really about more. And Sam Schoener and Vandal do on the outside is making plays. And I think when he was having Murray goes fry. They're an outside zone, inside zone running team. And he came in and you may talk a little bit about this. I had no idea what he thought. Did he think that, hey, we're NAI, we're tri-state, we're just gonna be able to go in there, do what we do at McMurray and be successful. Like I didn't talk to him much before the game or after the game, it's pretty short. Just kinda like, congrats Jim on your first win. I'll see you later. So he didn't say much about the effort and so on. So not knowing what to expect, not knowing what was going on and they couldn't run the ball on us. And then they had to try and throw it. And the quarterback completed a few passes but when he completed them either he got hit, like Kido Kai took a pretty good beating. And that's what we have to do. If we can keep control in the run game, and that's Coach Cree, Coach Mateer, Coach Kalsich, Coach Roberson, the defense staff did a great job preparing. And I just say, stop the run. Let's stop the run, make him throw the ball, they want to throw it. We gotta rally the ball and get the job done. So very happy with that side of the ball. Sometimes as a new coach, you may have seen this when he came to Lakeland too, the personnel fitting the system is important too. And I think that fry was always a custom. He always had that unbelievable running back at McMurray. And it looked like this time he had the strong arm quarterback but maybe didn't have the back of the field. And that's what some of the people said last year, I talked to Coach Freyman last year, he said the defense at McMurray was very good. Very, very good. He said he had won. His passing was average. He thought last year he said he had won stud running back. So I think he'll get the stud. And we'll play him next year. I guarantee you he'll have a stud, whatever back there. But they didn't have that one guy that could just break it. Take it to the house. I think the one key to score two touchdowns was a stock year kid did a good job in short yardage form. I think we played fast. But most important present thing on defense was I felt like we were running very well and they looked a little slow. No offense to them. I just think we had more speed. And our kids up front won the physical battle. And once you win the physical battle, you got a chance. You won't always win the game. You win the physical battle, you get a great chance to win a football game. I'm both sides of the ball. That's all I tell the defense, be physical. Yep, and you guys obviously won the statistical battle. I'm gonna read some of the stats here. You guys had 22 first downs compared to 13. We already mentioned the total yardage. You guys had 410 total yards compared to 178 for tri-state. Time of possession is another one that stands out, which is something we haven't seen in the past. We had 36-24, 36 minutes to 24 minutes, which is really amazing. And of course we mentioned the sacks. You guys had just an unbelievable defensive performance. Pretty good all-around. What do you think you guys have to work on before we talk about cartage? Double thing, we got a minimum. We're like the Oakland Raiders right now. We have 15 pounds or 50 yards.  And that's no offense to the kids. They know they can't retaliate and they know we can't hold downfield wide receiver. We've got to move our feet. We've got to work on penalty. We can't line up off-sides twice. We've got to work on penalties. Number two is, offensively wise, we have to be able to make big plays in the past again. Because I actually believe the way the game panned out, no disrespect to Tri-state. But as the game was going, once we controlled the offensive line, we controlled their defensive line, we missed James Hayes' open up post for a touchdown. We missed Sean Barron up for a touchdown. We had guys open that could have got the quick score. Because I think to become a very, very explosive offense, which I hope it will become sometime, you're going to have some sustained drive. We also need a one or two-play ban, see a 70-yard plays to get a rolling. And we missed those.  We had two guys open and Brent threw a bad ball and we didn't get a good play. We have to work on quick strikes. When we do throw it, we got to be able to get the job done and get some home run shots. Because people now have to put a lot of guys in the box. They bring guys down. We got a chance to play action and go home run. So that's a big thing. Defensively, we got to work. We can't miss tackles. It's a big play they had. We didn't miss very many, but big play they had. You can't have an offense pinned down inside the 10 and give up a 75-yard pass. So they know that. And that's sort of the thing. Making sure once we get them down there, if we don't do something well on offense, keep them down there so they have to punt. And of course, the P.A.T. field goal team. Just as a unit. And when I talk about that, you'll never hear me once ever saying about a person or a player or whatever. It's just as a unit. We got to get that whole group together and play better. Yeah, it's got to be an automatic team. Yeah, exactly. So that's it. Maybe the hole wasn't great or the snap or the protectors. There's a lot of different things. So we harped on. We thought we were pretty good at it.  So we got to do better with that unit. When I got a new team coming up here, you got Cartage College this week. And it's a new situation as well. You got a night game, seven o'clock, which kind of throws things off. Yes, it does. But it's going to be completely different too, because you got Tim Ruxes, the head coach down there, but he has a totally new system. He has a new offensive coordinator, new defensive coordinator. I don't know if it's a new system, but you've got to imagine that these guys coming in are going to bring in something different.  I try to say it was a little bit, we have an idea whether we'll do offense and defensively. New coordinators, they never know what they're going to do. I think what helps us, in a sense, is we're going to get better at what we do. Whatever they do, we're going to have to, we've got to get better at what we do. Now, worry somewhere. I think as the year goes on, you're going to see us not worry so much about everybody else and worry about how can we make Lakeland better? Now, how can we beat Cartage? Let's play the best game we can. The biggest improvement should come between week one and week two. Now, with that hold, I don't know. But I think we can correct the mistakes we made and we can have an opportunity. You know, hopefully play better, because I tell the kids a 10-step season. Each step is as important as the next step. So we're on step one, trying to get step two. And hopefully, as we will do it, I don't know what's going to, I think we're going to need to run the ball, of course. We're going to have to play action. These guys, I think they'll play a lot of men. Covers could open up big plays in the passing game. Offensey, we've played Cartage. We've been on that Milliken for three years. They're a two-back team, some one-back. They want to get, they're all geeked up and hyped up, night game, first game. You know Cartage, they have 160 kids on the sideline. All their black or whatever uniforms they have, all the money they have down there. They get all excited about their facilities. It's a great opportunity, because one of the goals for our program is we want to be one of the best teams in the state of Wisconsin, and the way it is, play at Wisconsin schools. So the next two weeks, we have that opportunity. So we're going to have to get ready for the first road trip, besides I think the scrimmage helped us. But a night game throughout your schedule, you've got a different deal. I think our kids will be excited to go down there and a quote-unquote power, you know how it isn't, but I apologize John. They're a CCI, they're supposed to be a power conference team.  I'll play at those guys, you know, whenever we want, the schedule and every year we'll play them. Well maybe the artificial turf will help you guys, like you said, we play fast. Could be, and that's why I think it's going to help. Hopefully that rubberized tub will make us look even faster. That's right. Well we got it, you're getting a sign here that we got to wrap it up. We're going to have to recap a little bit of what happened this week. And of course the football teams, we just talked about 130 to 13, getting off to a great start over Tri-State. The volleyball team had a great tournament. They finished in fourth place in their tournament, but they had a nice young team playing against some of the nationally ranked teams and it's going to help them in the long run. And finally of course the men's and women's soccer teams. The men's team went one-on-one this weekend when the women's soccer team lost two overtime games in thrilling fashion. But if you get a chance, make sure you join us next week for the next edition of the Lake and Lock Room and we'll see you next time.


I am standing outside the old Blackberry Elementary School, and I know this looks a little bit different, but we're having to film tonight in the dark, and we're filming in the dark for a reason, because the old Blackberry Elementary School is now called Hantophobia. We're coming into our second season, and I literally cannot see anything around me right now, so I'm hoping that you can see me. We just had a snake peek, and it is really scary. I talked to the owners of Hantophobia, and they say, if you went through this last year, that you need to come through it again this year, because they say nothing is the same, and in fact, it may be quite a bit scarier. Last year, we really tried to give the community and give Haunted House love, or something they've never seen before. We don't look for pretty, we don't look for just flashy in colors. We want to go from getting you scared, having fun, to living a nightmare. We want you to feel like you're in the nightmare, and you're part of the scene. Whenever you go into a room, you just feel like you're part of a horror movie. That's what we wanted, especially as you get deeper into the haunt. Our goal is for them to quit. We don't want them to finish it. We want them to come through and be so scared that they can't finish the haunt. That's our goal. And the people that can finish it, we want them to walk away saying, man, that was something. It's Friday, Saturday, from this weekend, all the way through the end of October. The last weekend of October will be our final weekend. We open this Friday. We start selling tickets at seven o'clock, and the doors will open at 7.30.