Hello.
I am creating a report, and i need some help with date ranges.
If i put in a date range of Jan. 1 2010 - Jan 31 2010
I would like the Jet Report to replicate a week date range.
For instance
Jan. 1 - Jan. 7
Jan. 8 - Jan. 14
Jan. 15 - Jan. 21
Jan. 22 - Jan. 29
Any idea how I can do this?
Date
Votes
5 comments
-
Jet Reports Historic Posts I would like to add to this. I do not want to include weekends.
so monday - friday
monday - friday
monday - friday -
Jet Reports Historic Posts C3 = #1-1-2009#
C4 = #31-12-2009#
C5 = NP("DateFilter",$C$3,$C$4)
C6 = NL("Rows","Date",,"Period Type","Week","Period Start",$C$5)
D6 = NF($C6,"Period Start")
E6 = $D6 + 4 -
Jet Reports Historic Posts This works almost 100 %. (By the way, thank you very much, i never knew 1..7 meant monday - sunday)
One thing to point out, If i put in a date range of Jan. 1 2010 .. Feb 28 2010
January 1 2010 falls on a friday.
So when i run the report, i get.
Jan.4 2010 Jan.8 2010
Jan.11 2010 Jan. 15 2010
Jan.18 2010 Jan.22 2010
etc
etc
So actually, I am missing Jan. 1.
Would you know how I can get Jan. 1 in there ? (I am not too worried about it though, I will just let the client know of this slight limitation…) -
Jet Reports Historic Posts C3 = #1-1-2009#
C4 = #31-12-2009#
C5 = NP("DateFilter",$C$3,$C$4)
C6 = NL("Filter","Date","Period Start","Period Type","Date","Period No.","1..5","Period Start";$C$5)
C7 = NL("Rows","Date",,"Period Type","Week","Period Start",$C$6)
D7 = NF($C7,"Period Start")
E7 = $D7 + 4
http://community.jetreports.com/viewtopic.php?f=7&t=927#p2761 -
Jet Reports Historic Posts I still get the same thing.
check out my report, I have it attached.
Please sign in to leave a comment.