We'll begin meeting again next Tuesday, March 14 with a special treat, a tour of the Smooth-On plant in Macungie, PA. The meeting will begin at 7 PM, but come as early as 6:30 PM for dinner, which the group will provide. (If you’re coming for dinner, please email firstname.lastname@example.org, so we get enough food.)
The address is:
Smooth-On Inc. 5600 Lower Macungie Rd Macungie, PA 18062
Abstract: Smooth-On is a large chemical manufacturer that
recently moved into a new facility just south of Allentown. Prior to the
move, we used VFP to do Order Entry, Inventory Control, Purchase Orders,
Formula Management and Batch Scheduling, among other things. When we made
the move, we took it to the next level and used VFP to Automate much of the
manufacturing process. This tour will be conducted by the COO and explain
the process, show examples of the types of things are made with our products,
and discuss the benefits and challenges of the transformation.
After this meeting, we’ll meet on the 2nd Tuesday of every other month through November, so mark your calendar for May 9, July 11, September 12, and November 14.
Our next meeting will be next Tuesday, December 13 at 7 PM
in room 122 at Devry University. Dinner will be provided beginning at 6:30 PM and there will be no charge for
Given the recent dip in attendance, we’ll discuss the future
of the group. Please consider ahead of time what you’re hoping to get from the
group and what you can contribute.
In addition, we’ll have a brief presentation from member Jim
Connolly titled “Amazon EC2 – A Free Web Hosting and Development Tool.”
Abstract: Are you looking for a web server for development? Review
of theAmazon EC2 web server product as
a free service for a year!
year ago, I signed up with the Free Web Server offering from Amazon. At this time,
I would like to share my experiences with the group. I’ll present a review and
evaluation of the Amazon EC2 web server. What can the Amazon service do for you
as a developer! I can show you how to sign up and create your own web server.
If you will be joining us for dinner, please let us know (email@example.com), so
we have enough food.
Our next meeting will be next Tuesday, September 13 at 7 PM in room 121 (note room change). Our speaker will be Kevin Goff and his topic is “SQL Server Reporting Productivity Tips.” He'll be raffling a $50 Amazon gift card, too.
Abstract: In this presentation, I'll show over a dozen different SSRS topics, and allow attendees to select which topics to cover.
- Advanced charting (sparklines, heatmaps, performance gauges)
- Subreports/drilldown reports
- Matrix (crosstab) capabilities
- Page/Group Control Features
- Data Driven Subscriptions
- Cross-chart filtering ("hot-linking" from one section of a report to another)
- Column visibility and hiding columns from users
- Parameter handling
- Aggregations and running totals
Kevin S. Goff
- Microsoft Data Platform (SQL Server) MVP
- Microsoft MVP since 2005
- Frequent community speaker in Mid-Atlantic region
- SQL Live/VS Live conference speaker 2012 to 2015
- Database developer/architect since 1987
Our next meeting will be Tuesday, August 9. It will feature Menachem Bazian’s
postponed-from-February session titled “Map It With Google.”
Abstract: Google maps is a tremendously powerful service
that can really add useful functionality to your apps. This session will
introduce the Google Maps API and show an application that was built around it.
We'll be in room 128, which is a computer lab, so if you're coming for dinner, meet us in the seating area in the far hallway.
Our next meeting will be Tuesday, June 14 at 7 PM in
room 128 at DeVry University, 1140 Virginia Drive, Fort Washington, PA. Feel
free to come as early as 6:30 PM and bring some dinner. However, because the
room is a computer lab, food and drink are not permitted. So, we’ll meet
for dinner in the seating area in the far hallway and move to the meeting room
Member Bill Fitzgerald will present “A VFP programmer looks
at .NET – again”
Abstract: Since I first started using C# .NET in
2005 both the platform and the way I use it have evolved in several important
ways. I’ll walk through three existing production .NET/SQL Server data
processing applications which I wrote over a period of ten years and show how
the language and the techniques I use with it have changed.
Finally, I’ll show my first attempt at using the
recently-released multi-platform .NET core.
Our next meeting will be Tuesday, May 10 at 7 PM in room 128 (note change of room). Because the new room is a computer lab, food and drink are not permitted. So, we’ll meet for dinner in the student cafeteria and move to the meeting room at 7.
Speaker: Tamar E. Granor Topic: Crosstabs and Pivots: Turning Data on its Side
Abstract: While normalization is the best choice for storing data in tables, there are lots of reporting tasks that require you to turn some data into column headers and accumulate results in those columns. In this session, we’ll see how to do that using crosstabs in VFP and the PIVOT clause in SQL Server. For VFP, we’ll take a good look at an alternative to VFPXTab, the crosstab generator that comes with the product.