where have my parameters gone?
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.
November 18th, 2010 7:45am
Hi there,
Could you please close the project, and re-open it to check if the issue is gone?
Thanks,
Jin ChenJin Chen - MSFT
Free Windows Admin Tool Kit Click here and download it now
November 24th, 2010 4:13am
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.
November 29th, 2010 8:34am