Multi-Value Report Parameters Issue

• rfalagan

  SSChasing Mays

  Points: 601

  More actions

  February 24, 2009 at 10:53 am

  #218694

  Suppose I have a Report Parameters drop down with the colors:

  Available Values/Non Queried

  Label Value

  ------- ----

  Red 'Red'

  Black 'Black'

  White 'White'

  Blue 'Blue'

  Green 'Green'

  The user checks the Red, Blue and Green

  What is being passed to the report?. Is the string "'Red', 'White', 'Blue'" passed to the report...?

  Actually. My report stored procedure sp_rpt_getcolors( ) is expecting a parameter @colors varchar(500);

  I have a select @colors to display what's being passed and I get blank.

  Thanks,

  rfalagan

• ab5sr

  SSCarpal Tunnel

  Points: 4056

  More actions

  February 24, 2009 at 11:49 am

  #949565

  Have you run profiler to verify what is being sent?

  Lee

  http://www.texastoo.com