Using Access 2010 and Access Services with SP 2010
Has anyone had success with the sample in Chapter 13?
I have an exisiting SP site with some relations set between lists - trying to use Access to create reports with joins. I created the Access db with SP list data (connected), created a query and report. I was then able to publish to SP 2010 - an Access Services site was created with the tables, query and report listed - however the links are dead.
I was hoping to have the report launch from the brower within a Reporting Services webpart - I have been able to create similar lists and publish with Report Builder v3 under SQL 2008 R2?
Any suggestions appreciated, thanks