Fast development of technology and quickly spreading fast internet with new devices and technology open new ways for us to connect our homes with other family members. Windows Home Server is product that needs heavy refresh and one thing that Windows Home Server team must take seriously is changing current very limited licensing scheme. Here is the overview of situation and what needs to be done to get better licensing that fits for families better today.
In one of my current projects I have some pivot reports that show count of issues in different states. Grouping depends on report. States are dynamic – admins can define new states and save them to states table. This means that I cannot hardcode names of states to queries. Instead I need dynamic pivots. In this posting I will show you how to write reporting procedures that offer dynamic pivoting capabilities.