Tuesday, May 3, 2016

Tuesday, May 10--Tamar E. Granor--Crosstabs and Pivots: Turning Data on its side

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.