Hi

I’m a very rusty Crystal user, only recently coming back to it after 7 years absence.  I’ve got two issues that are frustrating me:

1  I’m looking to write a formula field that counts the number of months back to the start of our financial year (1 April), and then to express it as a percentage.  Thus, for my YTD report to end January 2015 (which I run early February) I want to display 83.33% (ie we are 10 full months through our financial year), and for end February 2015 I will want to display 91.67% (11 months).  Clearly it’s very easy to do the manual calculation, but there has to be a way of automating this and remove a task which could get overlooked.

2  I’ve got a Page Header which I want to suppress before the Report Footer starts, and can’t get the right formula in Section Expert.  If it’s relevant, the body of my report is in Group Headers, with Details and Group Footers both suppressed.  The Report Footer contains subreports which show different information from the various Headers and the Page Header isn’t relevant to the Footer reports.

Thanks in advance, and as my memory comes back I’ll be on here to help where I can.

Best wishes

Richard

Thanks for your reply.

Q1:  I'll try that when I'm next in the office, it looks like what I need.

Q2:  there are two subreports, which total 3/4 of a page at most and don't need more than one page.  They can be on a separate page from the main report.