Cmonth is a function that returns the character month of a date expression. For example CMONTH(DATE(2005,6,1)) will return "June."
Let me start by saying custom reports in fund accounting can be very difficult. You are limited to very simple reports. We have hundreds of lines of code we use to create things like the balance sheet and income & expense statements. Trying to recreate those reports in the custom reports is not practical.
That said though, I assume you are looking for the month range that was entered when going in to the custom reports in fund accounting. Those months are stored as a two fiscal month objects and I just checked are still in scope during the report layout.
1. Add a field object to the report layout.
2. In the expression enter the following:
- Code: Select all
m.pofrom.getchardate() + ' - ' + m.poto.getchardate()
If you added the field object to the title band, you should now have the text like "January 2005 - June 2005" on the top of your report. Keep in mind this is a very advanced topic and because you are referencing internal variables in the program, this may change in future version of PowerChurch Plus.