Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
pulling months from two dates
- Thread starter dg3249
- Start date
Use something like:
-------------------------------------------------------
Join(["Jan", "Feb", "Mar", "Apr", "May",... "Dec"][Month({start_date})to Month({end_date})], ", "
;
-------------------------------------------------------
Of course, complete the rest of the month names instead of the "..."
Cheers,
- Ido
CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.
-------------------------------------------------------
Join(["Jan", "Feb", "Mar", "Apr", "May",... "Dec"][Month({start_date})to Month({end_date})], ", "
;-------------------------------------------------------
Of course, complete the rest of the month names instead of the "..."
Cheers,
- Ido
CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.
- Thread starter
- #3
The TGML processing deleted some characters.
Here's a correct version:
-------------------------------------------------------
Join(["Jan", "Feb", "Mar", "Apr", "May",... "Dec"][Month({start_date})to Month({end_date})], ", "
-------------------------------------------------------
The internal stuff returns all the array elements betrween start and end month.
The join() function then turns the resulting array into a single string (comma separated).
Cheers,
- Ido
CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.
Here's a correct version:
-------------------------------------------------------
Join(["Jan", "Feb", "Mar", "Apr", "May",... "Dec"][Month({start_date})to Month({end_date})], ", "
;-------------------------------------------------------
The internal stuff returns all the array elements betrween start and end month.
The join() function then turns the resulting array into a single string (comma separated).
Cheers,
- Ido
CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.
- Thread starter
- #5
It seems to have worked, sort of.
When I insert this formula into my report it pulls all the orders and displays them as follows.
Apr, May, Jun
Order 123
Apr, May, Jun, July
Order 122
Order 124
How do you get it to group so that it shows all orders per month instead of the way it is above.
When I insert this formula into my report it pulls all the orders and displays them as follows.
Apr, May, Jun
Order 123
Apr, May, Jun, July
Order 122
Order 124
How do you get it to group so that it shows all orders per month instead of the way it is above.
Group your report on either Start_Date or End_Date.
Select "for each Month" as the grouping option in the create/change Group dialog.
Cheers,
- Ido
CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.
Select "for each Month" as the grouping option in the create/change Group dialog.
Cheers,
- Ido
CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question