SQL Server Performance

SQL Server Reporting Services Question: Error in report preview due to parameter

Discussion in 'Getting Started' started by sqlbegin, Feb 16, 2014.

  1. sqlbegin New Member


    I'm getting this SSRS 2010 error in PREVIEW after plugging in parameter (CustomerId) value on main report: "Warnings occurred while executing the subreport_1. An attempt was made to set a report parameter 'CustomerId' that is not defined in this report"

    I don't understand this message. I'm having two sub-reports in the main report. Both these are passed the same parameter 'CustomerId'. The second sub-report is a table being populated with a number of rows and the first one above it, is a form being populated. Both these are working fine independently after I plug in the 'CustomerId' numeric value in the PREVIEW parameter. In the main report preview, I can see the second sub-report but not the first one because of the above ERROR. I've verified that the same parameter is being passed to the (FIRST) sub-report after right clicking it and adding parameter 'CustomerId'.

    I would really appreciate some quick help on this.

  2. sqlbegin New Member

    Found issue ... resolved!!

Share This Page