Dynamic reports

[Acade]

I'm not sure where to post this but here we go:

I have designed a sales report that basically takes the information out of my database does some calculations and drops all of the information into a form which I created, which in essesnce looks like and Excel spreadsheet. Accross the top of each column are the months and the rows are labeled as separate sales categories. What I want to do is have the report print out normally Jan-Dec, then the following month I want the report to start with Feb and go to Jan. Is there an easy way to do this without changing all of my field definitions along with making 12 separate layouts? Thank you

[SteveB]

To me, you have to reverse what is one the axis...that is, records should be months. This way, you could do a trivial serch for Jan thru Dec, Feb thru Jan, etc.

Steve

[lakeside]

I had a similar situation, and here's the calc I used for the month headers:

the first header is Month(Status(CurrentDate)). Subsequent headers are:

If(

Month(Status(CurrentDate)) + 1 > 12,

MonthName(TextToDate( (Month(Status(CurrentDate)) + 1) - 12 & "/" & Day(Status(CurrentDate)) & "/" & Year(Status(CurrentDate)))),

MonthName(TextToDate( (Month(Status(CurrentDate)) + 1) & "/" & Day(Status(CurrentDate)) & "/" & Year(Status(CurrentDate))))

)

You would do that for Month(Status(CurrentDate)) + 2, then +3, and all the way up through +11.

Then you'll need to make similar adjustments to the data you're displaying. Self-relationships were the key to that.

HTH