Hi all.
I got a dataset with a person and a date and i need to make a report on this.
but i want it like this:
day(date): 1 2 3 4 5 6 7
initials x x . . x x x
I have this now:
day(date): 1 2 5 6 7
initials x x x x x
Problem is i dont have a record from the 3rd and 4th, but they need to be in
the report aswell.
So i need the report to show a " . " the days they havent been there.
Can someone help me?If you don't have any data rows with values 3 and 4, they will not show up
in the matrix grouping. To ensure that certain groups/data values are always
present, you will need an outer join in your dataset query e.g. with a
simple table that just has 7 rows with one column and these values: 1, 2, 3,
4, 5, 6, 7
Details on how to use outer joins are available here:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/acdata/ac_8_qd_09_0zqr.asp
http://msdn.microsoft.com/library/en-us/acdata/ac_8_qd_09_1h6b.asp
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Christian Larsen" <ChristianLarsen@.discussions.microsoft.com> wrote in
message news:E5AEA9A4-0E2A-40ED-B11A-FE0839C3DF04@.microsoft.com...
> Hi all.
> I got a dataset with a person and a date and i need to make a report on
this.
> but i want it like this:
> day(date): 1 2 3 4 5 6 7
> initials x x . . x x x
> I have this now:
> day(date): 1 2 5 6 7
> initials x x x x x
> Problem is i dont have a record from the 3rd and 4th, but they need to be
in
> the report aswell.
> So i need the report to show a " . " the days they havent been there.
> Can someone help me?
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment