Rb date/period manipulation

Never mind I found a good way to do it, thanks anyway.



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Keith Mailloux
Sent: Tuesday, January 24, 2006 2:04 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Rb date/period manipulation



I am trying to find a way to replicate the sales order backlog in Rb so
we can separate it by plant. I have a way to segregate the plant but can
not think of a neat way to break out the backlog into periods, without
hard coding the period dates. Hard coding the dates as variables solves
the problem but then each month we would need to change the periods
(month range). Anyone have a nice trick for creating consecutive month
ranges? Ideally I would like to just run the report and all past due and
current month backlog would be in column 1, next month in column 2 etc.



Thoughts?



Keith



[Non-text portions of this message have been removed]



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links




________________________________

YAHOO! GROUPS LINKS



* Visit your group "vantage
<http://groups.yahoo.com/group/vantage> " on the web.

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .



________________________________



[Non-text portions of this message have been removed]
I am trying to find a way to replicate the sales order backlog in Rb so
we can separate it by plant. I have a way to segregate the plant but can
not think of a neat way to break out the backlog into periods, without
hard coding the period dates. Hard coding the dates as variables solves
the problem but then each month we would need to change the periods
(month range). Anyone have a nice trick for creating consecutive month
ranges? Ideally I would like to just run the report and all past due and
current month backlog would be in column 1, next month in column 2 etc.



Thoughts?



Keith



[Non-text portions of this message have been removed]