"Dynamically Changing" Variable SORT for Manual Cross-tab?
Posted on 2006-03-22
I'm using variables to pass summary counts down to Group Footers.
My groupings are:
>>>>>FILE OPEN DATE (BY MONTH)
My summary at these levels looks like this:
NO.LIT.NEEDED LIT.STARTED LIT.COMPLETED
01/2005 1 1 2
02/2005 1 1 2
03/2005 1 1 2
04/2005 1 1 2
05/2005 1 1 2
Client #: 1000 5 5 10
What I would like to do is to SUPPRESS the VERTICAL display of the counts and show them HORIZONTALLY at the CLIENT ID goup level. The main reason is for EXPORTING purposes to EXCEL. Here is what I would like to achieve:
01/2005 02/2005 03/2005 04/2005 05/2005
CLIENT # NLN LS LC NLN LS LC NLN LS LC NLN LS LC NLN LS LC
1000 1 1 2 1 1 2 1 1 2 1 1 2 1 1 2
I know that I can accomplish this by manually building a separate Variable that will take the MONTHLY summary counts and move them to a HORIZONTAL position at the CLIENT ID group summary level.
But my main concern is the ONGOING need to be creating NEW variables for EACH new month that is to be reported on. My secondary concern is the actual LAYOUT of the report.
Is there a way to us VARIABLES so that they are used "dynamically?"
An example would be if I created a variable for EACH month for EACH COUNT. ie. one variable is "Jan05-NoLitNeeded Cnt", another is "Jan05-LitStart Cnt" and so on.
Is there a way to set the variables so that regardless of what REPORTING DATES I use...that the Variables would print in the correct alignment, instead of ME having to manually code the alignment? Perhaps just setting the FIRST COUNT column to JANXX?
Example: The above data layout example is hard coded to print the Jan05 totals, then the Feb05 totals etc. But if I run the report for Jan06-Mar06...my layout would be totally thrown off....not only that I would need to create variables for the 2006 months that I don't have created.
So, I'm hoping someone might have some thoughts on how to accomplish this. I'm thinking maybe I need to somehow create my VARIABLES by MONTH (JAN) and not take into account the YEAR. AND only run my report for a CALENDER year at a time???
Sorry if this sounds confusing, but your help is much appreciated.