Why not add a field (or a related table) that contains the accounting year month value (1-12) for the calendar month? This is essentially your idea to call the columns "periods" but I am sure you can come up with a way to replace that poor nomenclature with the actual month and year. No?
Also, it should not be your problem or job to explain to the rank-and-file why your reports suddenly look different. Whoever is making up these rules should be explaining it to the constituency. HALinNY -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Wednesday, August 02, 2006 13:39 To: ProFox Email List Subject: Re: [SPAM]::RE: Switch From Calendar Year to Fiscal Year >You don't mention if mgmt wants to preserve the old (calendar year) >reporting system and also implement the new (fiscal year) system, but >you'll probably want both for one reason or the other. Yes they want both and they want the report to know how to order the months. For instance, picking a report and choosing year 2004 they want the months in the heading ordered using the old calendar Jan 2004 - Dec 2004. If the user chooses 2006 output the columns as Jul 2005 - Jun 2006. Confusion comes when the report includes multiple years from different calendars. For instance, show project activity for 2004 and 2006. For 2004 they want July to be in the 7th column of months and for 2006 to be in the 1st column. In the same file. OK for printed version I can play with the columns based on the year. But if they send the report to file, right now I just copy the table to XL5. Maybe I can't do that anymore and have to post-process the Excel file by adding blank rows between years and repeat the headers with the month names ordered properly. The other issue is there'll be a big learning curve since the company's been on a calendar year since the early 1900s. In the report selection form I have a combobox to pick a year (1992 thru 2007) and months (Jan thru Dec). I'm not sure on-screen how to make it clear if they pick 2006 + July they'll get the fiscal period July 2005 not the calendar period July 2006. -- Andrew --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
