Shading Details for last 7 days

[Dross]

I am using CR XI and have detail information by a date. I need to shade the previous days based on day 1, day2 etc.
So this week (days 3,2,1) would be nocolor, but the last week (days 7-1) would be silver. Then the week before that would be nocolor again. Any thoughts?

So this is what it looks like:
Week Day Date Data
3 3/24 55
2 3/23 456
1 3/22 747
7 3/21 562
6 3/20 232
5 3/19 652
4 3/18 323
3 3/17 854
2 3/16 457
1 3/15 235

 

[IanWaterman]

In section expert click color

In formula box on background colour

If {datefield} = lastfullweek then crsilver else crwhite

Ian

 

[Dross]

Thanks Ian. That worked for the previous 7 days, but I need it to alternate from shaded to not shaded all year for alternating weeks. Does that make sense? So last week is shaded and the week before shouldn't, but the week before that should...

 

[IanWaterman]

Try this instead

if remainder(datepart("ww", currentdate),2) <> 0 then
(If remainder(datepart("ww", {datefield}),2) <> 0 then crsilver else crwhite)
else
If remainder(datepart("ww", {datefield}),2) = 0 then crsilver else crwhite

Ian

 

[Dross]

That did it, thanks! You are tha man!

 

[Dross]

Now they want something added and maybe you can see how. I can't seem to get my head wrapped around this project (doesn't everyone love floating requirements?) now that I can shade every other week, they want to do a comparison of weekday to weekday. So this Monday VS last Monday, but every day to every day from the beginning of the year. Since there are no groups I am having a hard time making that happen. Any thoughts on that?

 

[IanWaterman]

You can use a variable.

Split deatils into two sections, leave all your data in upper one and suppress lower one

@MondayComparison

whileprintingrecords;

global numbervar ThisMonday;
global numbervar LastMonday;

if dayofweek(datefield) = 2 then ThisMonday:= valuefield;

ThisMonday-LastMonday

In format field set suppression to
dayofweek(datefield) <> 2

Create similar formula for each day and place on top of each other in upper details section

Place this in lower detail section
@setvars

whileprintingrecords;
global numbervar LastMonday;
global numbervar LastTuesday;

etc

if dayofweek(datefield) = 2 then LastMonday:= valuefield;
if dayofweek(datefield) = 3 then LastTuesday:= valuefield;

etc

Ian

 

[Dross]

I only have 1 detail section. 1 row per day

 

[Dross]

Sorry, misread the 1st part

 

[Dross]

Didn't really work as expected, but thatnks for the idea, I was coming at it a different way. I think I attached a pdf of what I am doing so that maybe you can see what I am working on

 

[IanWaterman]

YOu attachment is still on your C Drive!

Need to post on something like

http://www.box.net

Ian

 

[Dross]

http://www.box.net/shared/u7b3uzzu1n

 

[IanWaterman]

The results look OK, or am I missing something.

Ian

 

[Dross]

It should be comparing
3/21 - 1282 to 3/14 - 1451
3/20 - 1035 to 3/13 - 1141
etc

 

[IanWaterman]

The data is correct

3/21 - 1282 to 3/14 - 1451
Difference is 169 which is what is showing against 3/14

Ian

 

[Dross]

I think it is the order I have the math in. the 169 should be at the 3/21 line, not the 3/14 line

 

[IanWaterman]

Sorry did not spot the order. Doh!

YOu can only use vars as the data flows, you would have to reverse order of data to get difference to show against 3/21

Ian