Parameters - help

• Bzeebee

  SSC Enthusiast

  Points: 188

  More actions

  September 22, 2005 at 6:41 am

  #115172

   

  Hi ,

     I need help with parameters..this may be a basic question but i am a newbie to MS reporting services.

  A breif explanation of my problem

  I have a report that requires 10 parameters, one or all of which can be selected for determining criteria.

  Within VS, Under Report, I created the parameter @column1

  I created 10 datasets for this and after this i dont know how to proceed.

  I am a new to reporting services...Please help

  I suffixed my sql string in the DATA TAB with "where column1 = @column1 and column2=@column2 ........

  but i get this error:

  Must declare the variable '@column1'.

  .

  .

  .

  where do i declare these variables????

  will appreciate any help...

   

  thanks

  -newbie

• Donald P Strasburger

  Grasshopper

  Points: 15

  More actions

  September 22, 2005 at 9:33 am

  #592290

  Within VS, Under Report you will find Add Parameter.  This is where parameters are defined.

• Bzeebee

  SSC Enthusiast

  Points: 188

  More actions

  September 22, 2005 at 2:59 pm

  #592414

  I did that and only after that I get

  Must declare the variable '@column1'.

  My SQL query = "Select column1,column2 from test"