Joined: 12 Feb 2015
Location: United Kingdom
Online Status: Offline
Posts: 1
Topic: 12 month report 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.
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
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
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
