Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
biliboaca
Starting Member
1 Post |
 Posted - 2004-11-25 : 06:15:17
|
| We have a report that uses a pivot to show the total hours worked by employees on different companies/each day of the week. The problem is when no employee worked on a specific day (like sunday), then that day is not shown in the report, even that we want to be shown and the data (total worked hours) to be 0. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-11-29 : 12:34:44
|
| You can handle this in your query. Just put a fake row for that day in the result set, then have your report look for the fake row and replace it with what you want.Tara |
 |
|
|
|
|
|
not all columns shown in pivot