Folks , need to generate weekly reports from sharepointlists(around20) and display it on a page? can you please give your insights and thoughts how to accomplish this task. Thanks in Advance!Share Knowledge and Spread Love!

There is two suitable way on my mind: 1. You can create a custom webpart and use sharepoint object model to generate the reports. Refer below links to create custom webpart: http://devpinoy.org/blogs/willydavidjr/archive/2008/03/18/creating-complex-web-parts-in-sharepoint-2007-using-web-user-control.aspx http://msdn.microsoft.com/en-us/library/ff649867.aspx 2. You can use SSRS for reporting purpose. This will give you good look and feel to your reports. Refer below link to configure SSRS with your server: http://blogs.msdn.com/sharepoint/archive/2007/02/19/microsoft-sql-server-2005-sp2-reporting-services-integration-with-wss-3-0-and-moss-2007.aspx Hope this info will help you and let me know if you need more help Cheers, Hemendra-MCTS

You can also synchronize the Lists as Tables in Access 2007 and use the Access Reporting system to create ready-made reports (from one list or combining several lists). (Not a customization question so moving to the Admin forum : Moderator)FAQ sites: (SP 2010) http://wssv4faq.mindsharp.com; (v3) http://wssv3faq.mindsharp.com and (WSS 2.0) http://wssv2faq.mindsharp.com Complete Book Lists (incl. foreign language) on each site.