I’ve just learned that Reports are not included if one is using an Access 2013 web app.
I’ve been experimenting with an app built in Access 2013, running as a SharePoint 2013 app in Office 365. It’s a small proof of concept with 5 tables, one query (so far) that joins 3 of the tables and then the results are surfaced in a view. So one could say that “reporting” in this case is simply real-time.
But the reality is that users still want to be able to have a local copy of data. Not all of the data, but a report, or a spreadsheet, or some means of having the key bits available to view and discuss even if offline.
So far I’m not finding a means of exporting this data. I’m fairly new to SharePoint. Any suggestions or places to look / research?
And if you go the BCS route, you can probably leverage what Sigitas Limontas referenced above…
Joe,Â
You COULD create a BCS connecting to your Access DB, then tap into the External Lists created in SharePoint from that BCS.
Or, you can use Excel (http://blogs.office.com/b/microsoft-access/archive/2013/01/22/visualize-access-data-in-excel.aspx)
Or native Access reporting (http://office.microsoft.com/en-us/access-help/introduction-to-reports-in-access-HA102749545.aspx?CTT=5&origin=HA102809525)
Or SSRS (SQL Server Reporting Services)Â http://lemingtonit.com/services/Microsoft_Access/Access_Database_FAQs.aspx#47
Or anything that can connect via SQL Azure or ODBC …
If your lists are somehow accessible from SharePoint, and report in docx format is OK, maybe I could be able to offer some solution as soon as MS will fix some issues with App publishing to app store …
