Issue with NULL values-preview tab

• RG-801534

  Mr or Mrs. 500

  Points: 546

  More actions

  July 7, 2009 at 8:45 am

  #206671

  I have an issue with NULL values.

  I am working with timesheets.

  If a person do not have any entries for a week, ssrs is simply skipping his name from the list.

  But I want it to display his name and assign '-' for the days which he has not worked

  this is what I could see in data tab:

  employeename 6/21 6/22 6/236/246/256/266/27

  amanda

  brandon3.003.003.006.005.005.503.50

  chris8.005.005.004.002.00

  dennis3.504.002.001.503.00

  elaine

  francis5.503.758.509.50

  This is how it's appearing in preview tab:

  employeename6/216/226/236/246/256/266/27

  brandon3.003.003.006.005.005.503.50

  chris-8.005.005.004.002.00-

  dennis3.504.002.001.503.00--

  francis5.503.758.509.50---

  Please let me know how I can acheive this.

  Thanks,

  RG.

• Luke L

  SSC-Dedicated

  Points: 35547

  More actions

  July 7, 2009 at 9:21 am

  #1021149

  Please do not cross post. This duplicates efforts and fragments replies and data needed to actually answer your question.

  More data requested here.

  Thanks

  -Luke.

  To help us help you read this[/url]For better help with performance problems please read this[/url]