Print Page | Close Window

12 month report

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
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=21341
Printed Date: 02 May 2025 at 10:01pm


Topic: 12 month report
Posted By: Davy
Subject: 12 month report
Date Posted: 18 Feb 2015 at 11:54pm

I am trying to write a report that has to pick up the previous 12 month data and display each month's data in a cross tab. So if an account is loaded on January 23rd it will go under the January column of the report, and if it were loaded on the 9th March it goes under that column.

Any guidance would be hugely appreciated.


Replies:
Posted By: DBlank
Date Posted: 20 Feb 2015 at 6:37am

I am not really following what  you are asking for but in general you can use a select condition to get only 1 year of data (if you need full months you would need to account for that)

select criteria example:
table.datefield in dateadd('yyyy',-1,currentdate) to currentdate
 
then in your crosstab group on the date field set to per month


Print Page | Close Window