Hello all
Please help me out for this. Here is the report that I wish to do:
c1 c2
2/01/04 2 2
2/08/04 4 5
2/15/04 10 7
2/22/04 15 10
However, this is what I have right now.
c1 c2
2/01/04 2 2
2/08/04 4 4
2/15/04 10 10
2/22/04 15 15
The reason is because I group the count with c1 and it seems it also effect the count for c2.
The condition that I am looking for is "where c1 and c2 between paradate1 and paradate2".
It seems the group feature does not work well in this case. I am using Win 2000, Crystal Report 9, Oracle 8.1
Please help me. Thanks.
HP
Please help me out for this. Here is the report that I wish to do:
c1 c2
2/01/04 2 2
2/08/04 4 5
2/15/04 10 7
2/22/04 15 10
However, this is what I have right now.
c1 c2
2/01/04 2 2
2/08/04 4 4
2/15/04 10 10
2/22/04 15 15
The reason is because I group the count with c1 and it seems it also effect the count for c2.
The condition that I am looking for is "where c1 and c2 between paradate1 and paradate2".
It seems the group feature does not work well in this case. I am using Win 2000, Crystal Report 9, Oracle 8.1
Please help me. Thanks.
HP
