Hi, I have 3 custom lists, I want to create a report that combined 3 lists. how to create a report? what is the best approach for that?

Use Access 2007. Creates tables in a new Access 2007 database that are each synchronized with one of the lists. Then use the Reporting function in Access 2007 to create the report. Hint: do not use the report wizard as this works well only with a single table/list so use the report editor SP 2010 "FAQ" (mainly useful links): http://wssv4faq.mindsharp.com/default.aspx WSS3/MOSS FAQ (FAQ and Links) http://wssv3faq.mindsharp.com/default.aspx Both also have links to extensive book lists and to (free) on-line chapters