I have two lists, one is a project list, which has basicly every project we've ever done with a field for open or closed. The other is an issues list located within a specific project site (each project has it's own site). How can I create a report showing each project and it's associated open issues?

Thanks,

Wesley Ashworth

dear WesleyAshworth 

one way is to use sharepoint lists webservices

you must have one field common in both list for example you can use title field.
you can then return from another list using title field

 

thanks

Umer Jamil