Normal Topic Grouping a report on fiscal year (Read 304 times)
Amor
Full Member
Members
***
Offline


No personal text

Posts: 366
Location: Germany
Joined: Feb 7th, 2004
Grouping a report on fiscal year
Mar 12th, 2006 at 5:00pm
Print Post Print Post  
Hello!

When we print a group for each year, Sesame uses the calendar year.

How can we group the report by fiscal year rather than calendar year?

is the solution to create a formula that checks which fiscal year a Date or Date-Time value belongs to ?.

How we can then group on this formula instead of the Date field.

The  fiscal year begin in October. 

  

Dr. med. Amor Belhareth&&Medizin Labor &&Germany
Back to top
 
IP Logged
 
The Cow
YaBB Administrator
*****
Offline



Posts: 2530
Joined: Nov 22nd, 2002
Re: Grouping a report on fiscal year
Reply #1 - Mar 12th, 2006 at 5:05pm
Print Post Print Post  
You might try using ForceGroupBreak.

Page 170 of the Programming Guide.
  

Mark Lasersohn&&Programmer&&Lantica Software, LLC
Back to top
IP Logged