jaz

jaz

  • NA
  • 3
  • 0

sql server report service parameters

Apr 1 2010 8:47 AM

I want to add report parameters to a sql server report service 2008 that has been generated by the report wizard and have the parameters work.
I can get  the report parametes to look like they work by doing the following:
 1. select view then report data then right click parameters in the report data window.
 2. I then select add parameters then enter a 'name' then enter a prompt name and then select data type.
 3. I then right click on the dataset and then click dataset properties and then click on parameteres in the dataset properties window and add
the parameters I want.
 The above looks ok, but the parameters do not work.
 What do I need to do get the report parameters to work either after a new report has been setup using the report wizard and/or adding the
report parameters to work at a later time.