I added a slicer off the Pivot Table for each of the event categories at the bottom of the report.I created a PivotTable that showed the list of events.I created a column for each type of event I wanted to display
Then I got to thinking… I like the way the slicer looks, I wonder if. I could have pulled this into a PivotTable and put it on the report, but I didn't really like the look of it. I really wanted something to put on the bottom of the report that looked nice, and gave the users appropriate information. Jimmy's code pulls down the key pieces I needed and places it all in a nice table: I had to make a very simple change to the article in order to make it work on a shared calendar, but that was it. Lo and behold, I found an article by Jimmy Peña that does it all! Sweet! (Thanks Jimmy!) (I pulled all appointments from to, and was getting appointments from 2010!) Apparently Outlook doesn't actually store the dates of the recurring appointments at all, only the first and the recurrence pattern.Īfter a couple of days fighting with this, (on and off,) I happened to hit Bing looking for help. Run the code to get the recurring appointments and it gives them to you, but with the date of the first recurring appointment… even if you select a recurring appointment from within a date range. It seems that if you run code looking for appointments it ignores the recurring ones. Outlook has a weird way of storing appointments… especially when you get into recurring appointments. So it's just a matter of getting the appointments out of the Calendar and into Excel. We have a shared Outlook calendar that we use for recording all of our events. It's not like we don't have the information, either. Combined with the weather, this makes it a forward looking document that should be really useful. What's the chance we could also have the events coming up over the next week listed?" We put out a prototype of the Dashboard report, and our Director of Golf said "This is cool. The intention is that our managers will be able to see where we've been over the past week, as well as look at the key measures that will allow us to staff appropriately for the next week. It's got some historical information in it, but we've also pulled in things like weather forecasts. Over the past while we've been building a Dashboard report for our golf course.
0 kommentar(er)
