Good Afternoon,
I have created a report with a Drilled down (SalesByBatch). The first page has fields as:
AccountCode, Name, Total Order, Total Lines, Total Selling.
In the AccountCode field i have set the Text Box Properties set as;
Name:AccountCode
Action:
I have specified my drilled report as: SalesbyBatchDrilled
I have added parameters to run the report
Name: Value:
[AccountCode] [AccountCode]
[StartDate] [@StartDate]
[EndDate] [@EndDate]
Action: Go to report (SalesbyBatchDrilled)
On my drilled down report (SalesbyBatchDrilled) page I have the following fields:
AccountCode ProdDesc OrderNo OrderDate BatchCode ExpireDate
In a textbox on the page I have the accountfield set to [AccountCode] so as to pass the parameter for the accountcode.
When i run the report: SalesByBatch a list of AccountCodes is returned
ie
A1008
A1009
A1010
The user is then able to click on the AccountCode and click through to the drilled report:
SalesbyBatchDrilled
When the user clicks on the account code we keep getting the error:
An error occoured during local report processing. An attempt was made to set a report parameter [AccountCode] that
is not defined in this report.
Has anyone come across this and does anyone know how to fix it?
Regards