AccessHosting folks finally gave me an account. I published a test database into it after running the compatibility check with no issues.
In the web it does not work and I kept getting the message below.
Report viewer failed to set the report parameter defaults for this report. Select new default parameter values from the tool pane.
An error occurred during local report processing.
An attempt was made to set a report parameter 'SMID' that is not defined in this report.
I totally do not understand the message and appreciate if you or others can provide some in sight to overcome it.
The flow is as below.
- When the program launch, a form is displayed by Salesman.
- When you click the View Report button a report should open and be filtered to the selected SMID.
The macro behind the button as below.
<?xml version="1.0" encoding="UTF-16" standalone="no"?>
<UserInterfaceMacros xmlns="http://schemas.microsoft.com/office/accessservices/2009/04/application"><UserInterfaceMacro For="Command30" Event="OnClick"><Statements><Action Name="OpenReport"><Argument Name="ReportName">Sales History</Argument><Parameters><Parameter Name="SMID" Value="[Forms]![WT_Salesman]![SmID]"/></Parameters></Action></Statements></UserInterfaceMacro></UserInterfaceMacros>
I also understand that web query cannot do grouping or summing. What is the alternative?