Start of the year in crosstab

[nb4884]

Hi All,

Wanted to know if i can have my own start of the year in cross tab report.

For example if i have projent in row and start date in column of a cross tab and i want to summarize the data based on years. If i select year in the drop down , is there a way i could get the data starting from a particular month ie 1 april to 31 march data to be in one column since our fiscal year is 1april to 31 march . And similarily data of next fiscal year in next column?

Kindly suggest

 

[Madawc]

You could use a formula field to adjust the date, subtract three months using DateAdd.

Madawc Williams (East Anglia, UK). Using Crystal 11.5 with SQL and Windows XP

 

[HowardHammerman]

Sure, you just need to create a formula to contain the fiscal year and then use that in your cross tab. For example, for a fiscal year staring april 1:

if month({table.datefield}) >= 4 then year({table.datefield})+1
else year({table.datefield})






Howard Hammerman,
Crystal Training and Crystal Material
On-site classes and one-on-one coaching
Low-cost telephone/email support
FREE independent Crystal newsletter
howard@hammerman.com

http://www.hammerman.com

800-783-2269

 

[lbass]

Or you could use:

"FY "+totext(year({table.date}+275),"0000")

-LB