July 7, 2009 at 9:05 am
Hello all,
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/23 6/24 6/25 6/26 6/27
amanda
brandon 3.00 3.00 3.00 6.00 5.00 5.50 3.50
chris 8.00 5.00 5.00 4.00 2.00
dennis 3.50 4.00 2.00 1.50 3.00
elaine
francis 5.50 3.75 8.50 9.50
This is how it's appearing in preview tab:
employeename 6/21 6/22 6/23 6/24 6/25 6/26 6/27
brandon 3.00 3.00 3.00 6.00 5.00 5.50 3.50
chris - 8.00 5.00 5.00 4.00 2.00 -
dennis 3.50 4.00 2.00 1.50 3.00 - -
francis 5.50 3.75 8.50 9.50 - - -
Please let me know how I can acheive this.
Thanks,
RG
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply