Report Error message

• jman76

  Hall of Fame

  Points: 3388

  More actions

  May 28, 2012 at 9:46 am

  #258785

  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

• Daniel Bowlin

  SSC-Dedicated

  Points: 34566

  More actions

  May 29, 2012 at 7:55 am

  #1494186

  You say you have the parameters set up like this:

  [AccountCode] [AccountCode]

  [StartDate] [@StartDate]

  [EndDate] [@EndDate]

  Shouldn't it be like this:

  [AccountCode] [@AccountCode]

  [StartDate] [@StartDate]

  [EndDate] [@EndDate]