Hi All,
I have created a Asset database using MS Access 2010 & the same was published in SharePoint portal. Post publishing, all the "Query & Forms" are working as excepted but the "Reports" are not working.
Issue:
The "Reports" is designed with the help of "Group & Sort" option. Post grouping am able to see the "=Sum([Expression])" (i.e. Sum of the Value) value in MS Access Locally but not in SharePoint. Once i published in SharePoint, am getting "#Error" message for all the below expression wherever i have used in my reports design.
Please note, I need your assistance in resolving this.
Expression Used:
Below expressions are works fine locally & getting #Error in SharePoint.
1. =Sum()
2. ="Page " & [Page] & " of " & [Pages]
3. =Now()
4. =Date()