Monday, February 12, 2007 4:37 PM
Has anyone found a way to have SQL Server Reporting Services dynamically generate reports of SharePoint 2007 lists based on the onscreen filtering/sorting and the underlying SharePoint View (columns, groupings)?
We like the flexibility to give power users a way to set up their own custom views of SharePoint lists but we need to find a way to let them produce reports based on their views.
Unfortunately, our users still have a requirement to generate professional looking paper reports. The print capabilities of IE7, although much improved over IE6, are still not good enough for reports that are sent outside of our company. Specifically missing from IE7 are customization of page headers/footers (for company names/logos); and the abillity to save the configurations done within the IE7 print preview window.
Monday, April 02, 2007 12:22 PM
Did anyone found a solution to this problem? I want to generate a report from two SharePoint lists (MOSS) that are joined by a common lookup field.
Friday, May 04, 2007 6:53 PM
Did you find any soulution to this? I want to create SSRS Reports using SharePoint Lists.
Tuesday, May 08, 2007 1:02 AM
Did you try exploring the database? For simple lists I use it all the time, I am not sure how you go about capturing the context.
You might also explore using SOAP and XSLT, you could make the query based on the page, then format it any way you like.
Tuesday, May 08, 2007 2:41 AM
We couldn't find any easy way out, so we're creating our own solution which writes an .rdl file based on the current list and view to the wss site's report library, then starts SSRS with the .rdl file as input. Wish we didn't have to do this, but it seems like the only option. The solution is invoked through a "PrintView" option we added to the Action menu.
Wednesday, May 09, 2007 2:10 PMthis might be well-known already, but you guys tried the report part provided by WSS 2.0 to be used WSS 3? see http://msdn2.microsoft.com/en-us/library/ms159772.aspx , this is how you could show it in your sharepoint site. But can you guys tell me how you use the sharepoint list data in your report except directly reading from database? Cheers.
Friday, June 01, 2007 12:59 PM
Can you poist a sample of an RDL file that you are generating...Unfortunately, this is a problem many (if not all) of us folks deploying SharePoint (and MOSS) are dealing with. I had hopes that the SP2 release of SQL Reporting Services would help us, but sadly no.
If you can't post a good sample, I can send you my e-mail.
Thanks for your help,
Tuesday, June 19, 2007 2:58 PMI am using this http://www.enesyssoftware.com/Products/EnesysRSDataExtension/Overview/tabid/72/Default.aspx to report from SharePoint lists. Very easy and successful.
Monday, June 25, 2007 8:16 AMYes ,how easy to use it!
Monday, June 25, 2007 3:48 PMI have looked into this software at their website. Does it give you the ability to have a print me function from the list for users? That was the most intriguing thing about the earlier post. We have lots of sharepoint lists and users want to go and create a print friendly view that doesn't require IE7. It appears the software you linked to just gives you new options within Visual studio report designer. And it also looks like you must create xml queries to put in (ie, it doesn't have a query builder).
Monday, June 25, 2007 6:43 PMI am using this to create SQL Server Reporting Services reports based on SharePoint lists. By creating SSRS reports based on SharePoint lists, I can create reports in HTML/PDF/Excel, with company logo and other info in headers/footer. Using SSRS, I can print from HTML or PDF and have consistent results.
There is no query builder for using this extension, but they provide plenty of examples on what to do.
Thursday, October 18, 2007 10:09 PM
I found decent free instructions here:
I'm more of a T-SQL guy so the XML Querying is very new for me. So from the instructions in the link above I was successful (in development) in Querying my list as a XML source and got my list items from a single list back alright.
Also some thought:
One of the commentors Thock shows a unique way to get the XML source by referencing the RSS feed. But for me I need more XML Querying knowledge I was only able to get a few columns to show and not the ones I wanted.
Also can anyone point me in the right direction like a secret decoder key to convert my old school T-SQL querying skills to current XML, CAML and what not skills?
Tuesday, May 13, 2008 4:59 PMThis is a product that covers SharePoint printing that we just implemented. It might be of some help.