• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 417
  • Last Modified:

YTD vs last YTD

Crystal reports XI
Whats the easiest way to do a year to date vs last year to date report?  Run a date parameter with a range and then what to get the last years data?
0
ThomasBallardIT
Asked:
ThomasBallardIT
1 Solution
 
mlmccCommented:
Two ideas.

Use a date parameter for filtering the data as

{DateField} in YTD({?YourParameter}) OR {DateFIeld} In YTD(DateAdd('y',-1,{?YourParameter})

Then build the report using the information.

The other would be to build the report to use this year's data and add a similar subreport to get last year's data linking on the date parameter.

mlmcc
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now