David, If you mean writing reports against SharePoint Lists and Document libraries there is a tool for reporting services by a French company. Or you can use the Reporting Services 2005 xml datasource. You need to know xpath and query a list or two.... For rollups you would need to write a web service to rollup lists and then do the same by using the xml datasource. We've done this for clients who wanted to rollup and rollin lists.... (rollin by that we mean rollup differently named lists into one versus rollup the same list name in different sites.) SQL 2008 might have some more adapters but don't know as yet. There's also an open source linq to SharePoint if you are using Visual Studio 2008.... Can't wait to play with this! Has anyone done anything funky with this? FYI - Matt's reply seems to be the unsupported way of doing a backdoor query against a list.....which is a quick fix This is what we did a lot of with WSS2 but now one can do it with rs2005 and xml datasources, that is passé... Regards, Tom Bizannes MacroView Business Technology From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Matt Lynch Sent: Friday, 30 November 2007 3:36 PM To: [email protected] Subject: RE: [OzMOSS] Tools for writing Reports against MOSS data Hi David, I did something like this a while back at Avanade. You can actually use any reporting tool you like, you just need to be able to get the data out of sharepoint, usually using a ODBC connection. If I remember correctly, The driver you want to use is "Microsoft OLE DB Provider for ODBC Drivers". Then you just query the data as you normally would and make reports until the cows come home.
It's been a while, so you'll have to do a bit of research, but that's the crux of it. Cheers, Matt From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Prior, David Sent: Friday, 30 November 2007 3:12 PM To: [email protected] Subject: RE: [OzMOSS] Tools for writing Reports against MOSS data Yes that would be correct, but surely there's some other options. A Live Search doesn't seem to be returning much for me. Cheers, David ----------------------------------------------------------------------------------------- This communication may contain confidential information and/or copyright material of KAZ Group Pty Ltd ABN 25 002 124 405 and its related bodies corporate. It may also be the subject of legal professional privilege. If you are not an intended recipient, you must not keep, forward, copy, use, save or rely on this communication and any such action is unauthorised and prohibited. If you have received this communication in error, please reply to this e-mail to notify the sender of its incorrect delivery, and then delete both it and your reply. ________________________________ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Hodges, Kristen Sent: Friday, 30 November 2007 3:08 PM To: [email protected] Subject: RE: [OzMOSS] Tools for writing Reports against MOSS data I believe the Microsoft answer to that is Reporting Services. From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Prior, David Sent: Friday, 30 November 2007 3:06 PM To: [email protected] Subject: [OzMOSS] Tools for writing Reports against MOSS data Does anyone have any suggestions of tools to use to create reports against data stored in MOSS? I then want to be able to generate and view those reports in MOSS as well. Cheers, David ------------------------------------------------------------------- OzMOSS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com - List managed by www.readify.net
