Adding a date-spectrum to field-data within one record
When within a record , there is a Filed containing some "date" information, one could use this data to 'filter' on a selected date.
However, I do have a record containing some Financial data seperated over all the different fields (in total this would be at least 40 fields):
IncMonth1
IncMonth2
IncMonth3
…
SumToMonth1
SumToMonth2
SumToMonth3
…
Year
10
15
25
10
25
50
2009
7
345
55
7
352
407
2010
the fields
SumToMonth1 etc are actually calculated field that could be dropped if nessesary (and be recalculated within my report).
Current fields include "íncome per month", "expences per month"etc, Field names could differ in length.
However, no actual date information/ or perspective / view is available within a record except for the year. One single record containes all financiela data for one year.
I would like to show this financial data using my standard date/month selection, I think I have to add a date-component to this tabel.
E.g. Selecting March within my calendar, would have to show me the data of month 3 and SunToMonth3…
How could a ‘date’component be added for presenting this kind of data without having to use a if the n else (nested for all possible situations)?
Maybe i have to split this structure on a horizontal base :
Date
IncMonth
SumToMonth
31-01-2011
7
7
28-02-2011
345
352
A user should be able using this report to compare the income for a selected periode over several years...
How could this be done in scripting code? Is this suggestion for a solution correct?
