Friday, August 17, 2007
Finally fixed the problem w/ reporting over WSS3/MOSS lists
Sorry that this took so long. Many people have reported that using the Reporting Services Extension for SharePoint Lists gives an error when used against WSS3 or MOSS 2007, the latest incarnations of SharePoint.
For a long time, I couldn't find the time to fix the problem. I did not have a developement environment with Reporting Services anymore, so setting everything up again was not something for a spare 30 minutes.
Anyway, I found the problem (I explain below). You can download a fixed reporting extension here. Note that this is a version for SQL 2005. I do not have the tools anymore to compile one for SQL 2000.
So what was the problem? The extension uses the "Display Name" of a list column as its internal name. The problem arises when two columns have the same Display Name. It turns out the all lists on WSS3/MOSS2007 have several columns named "Modified". In the new version these will show up as "Modified" and "Modified_1".
I also made sure that in the future the error messages will be more meaningful. Enjoy.
