Use Reporting Services to print SharePoint lists?  
Author Message
Gerry2007





PostPosted: SharePoint - Business Intelligence, Use Reporting Services to print SharePoint lists? Top

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.



SharePoint Products and Technologies1  
 
 
Anonymous





PostPosted: SharePoint - Business Intelligence, Use Reporting Services to print SharePoint lists? Top

Hi,

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.

Thanks,

Soumitra


 
 
kvenkat





PostPosted: SharePoint - Business Intelligence, Use Reporting Services to print SharePoint lists? Top

Soumitra,

Did you find any soulution to this I want to create SSRS Reports using SharePoint Lists.

Thanks

-Kiran


 
 
Braden Callahan





PostPosted: SharePoint - Business Intelligence, Use Reporting Services to print SharePoint lists? Top

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.



 
 
Gerry2007





PostPosted: SharePoint - Business Intelligence, Use Reporting Services to print SharePoint lists? Top

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.


 
 
Jian Zhang





PostPosted: SharePoint - Business Intelligence, Use Reporting Services to print SharePoint lists? Top

this 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.

 
 
dave c (dmc)





PostPosted: SharePoint - Business Intelligence, Use Reporting Services to print SharePoint lists? Top

Gerry,

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,

Dave C


 
 
Andy Potter





PostPosted: SharePoint - Business Intelligence, Use Reporting Services to print SharePoint lists? Top

I am using this http://www.enesyssoftware.com/Products/EnesysRSDataExtension/Overview/tabid/72/Default.aspx to report from SharePoint lists. Very easy and successful.


 
 
pccai





PostPosted: SharePoint - Business Intelligence, Use Reporting Services to print SharePoint lists? Top

Yes ,how easy to use it!
 
 
Rickey Whitworth





PostPosted: SharePoint - Business Intelligence, Use Reporting Services to print SharePoint lists? Top

I 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).
 
 
Andy Potter





PostPosted: SharePoint - Business Intelligence, Use Reporting Services to print SharePoint lists? Top

I 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.


 
 
bmchan





PostPosted: SharePoint - Business Intelligence, Use Reporting Services to print SharePoint lists? Top

I found decent free instructions here:

http://rockstarguys.com/blogs/colin/archive/2006/11/10/accessing-sharepoint-list-items-with-sql-server-2005-reporting-services.aspx

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:

http://jasondotnet.spaces.live.com/blog/cns!BD40DBF53845E64F!142.entry

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