where have my parameters gone? RRS feed

  • Question

  • Just upgraded to SQL server 2008 SP2 and now the Parameter drop downs on the "Subreport Properties" dialog no longer show a list of all available parameters - expanding the drop down (under 'Name') reveals only 1 item. If I change the subreport (by changing the "Use this report as a subreport:" drop down) and then change it back, then the parameter list expands to show all parameters. Almost as if the list of parameters isn't normally refreshed...

    Removing SP2 fixes the issue, but I installed SP2 to fix another problem, so would like to find a solution that allows me to use SP2.

    Thursday, November 18, 2010 12:38 PM

All replies

  • Hi there,

    Could you please close the project, and re-open it to check if the issue is gone?

    Jin Chen

    Jin Chen - MSFT
    Wednesday, November 24, 2010 9:02 AM
  • unfortunately restating or rebooting doesn't help. The problem isn't limited to my PC either, my colleagues also have the same problem after going to sp2. To expand a bit on the explanation of the error,

    if I add a new subreport, or change the subreport then the list of parameters is visible

    if I edit an existing subreport, and try to add a parameter then list contains no values

    if I edit an existing subreport, and try to change an existing parameter, then only that parameter appears as an item on the drop down list.

    Monday, November 29, 2010 1:18 PM