I have 2 lists I need to create reports out of including pivot like reports. What's your recommendation for doing so and still present it on a SharePoint site?
look up list
Sample List A 1 X 2 Y 3 Z
Sample List B 1 John X 2 John Y 3 Jay Z 4 Jay X 5 Ipsum Y
John 9 Jay 5
Name x y z SQL Column John * * 9 Jay * * 5 Ipsum *
If I had this data in SQL, I would be done with it. But it's unfortunately/fortunately in SharePoint. Are you using Microsoft Reporting Services, Excel, etc? What has been the experience when having to do inner joins? I know you can do some joining with XSLT, but it's more troublesome than what it should be at times.