multi-value parameter not reporting NULL values when using a left outer join

• ksedlak

  SSC Rookie

  Points: 26

  More actions

  October 13, 2010 at 9:15 am

  #229635

  my stored procedure (from SQL server) includes a left outer join. results show in SQL management studio as NULL values, but my report is not pulling this data because i have a multi-value parameter that does not allow null values...... can someone help?

  example:

  select c.custid, s.department from calllog c

  left outer join subset s

  on c.custid = s.custid

  i want to return the customer even if they have no department valued on the subset table.

• ksedlak

  SSC Rookie

  Points: 26

  More actions

  October 13, 2010 at 9:27 am

  #1236315

  i also tried to define a dataset with visual studio 2005 (for the SSRS report) like this:

  select NULL as department

  union all

  select distinct upper(department) from subset

  order by department asc

  DOESN'T WORK!