Print Page | Close Window

YTD formula and Page Header

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=21334
Printed Date: 18 May 2024 at 9:53pm


Topic: YTD formula and Page Header
Posted By: RichardCrone
Subject: YTD formula and Page Header
Date Posted: 10 Feb 2015 at 8:47am
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


Replies:
Posted By: DBlank
Date Posted: 10 Feb 2015 at 9:47am

Question 1 maybe

datepart('m',dateadd('m',-3,currentdate))%12
 
question 2
Can the sub reports be on more than 1 page?

Posted By: RichardCrone
Date Posted: 12 Feb 2015 at 3:46am
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.

Posted By: DBlank
Date Posted: 12 Feb 2015 at 4:28am
pagenumber=totalpagecount


Print Page | Close Window