Database Views - Using PowerPivot with Problem Databases Part 2

In the previous post I mentioned the use of views to simplify querying your database in general and PowerPivot in particular.

What are Database Views?

Views are virtual tables, which you can create with a SQL statement. Some of the advantages of using views are:

Simplified Data Access – The view hides the data structure from […]

M2M Permissions. Please Provide Some Input

In my free time, I’ve been working on the permission problem I wrote about a few weeks ago. I’ve managed to get the permissions to output correctly and created a system to report from them in Integration and Reporting Services (more on that in a later article).

I’d like your input on it before it’s […]

I, for One, Welcome Our New .Net Overlords (Reporting)

In a previous post I recommended the use of Crystal Reports and listed some of the advantages of doing so. One of the primary reasons I am looking forward to the Made2Manage .Net future is my fervent hope that VFP Reporting will go away. Visual FoxPro reporting must die. In this […]

Quality Reporting on a Budget

Approximately 4 years ago at a National User Conference, a Made2Manage customer gave a demonstration of Crystal Reports. It is my understanding that at the time, Made2Manage was in negotiations with Crystal to license it as a partner to provide a quality alternative to Visual FoxPro reporting. Well, that demo made an impression […]