Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Can one Crystal Report could contian Current Month, YTD and ITD data?

Hi,

I am trying to build a crystal report and be able to show data in summarized format on single report containing data for the current month, year to date and Inception to date.

The difficulty that I find is the date ranges. Current month date range is different from YTD and ITD date.

what would be the best way to show such data on crystal report? is there a sample report available that can help me to produce such report?

your help will be highly appreciated, thanks!

regards,

Mansoor

Former Member
Former Member replied

Create two formula fields: MTD and YTD as follows (respectively; basic syntax):

if {date} in MonthToDate then
  formula = {value}
else
  formula = 0
end if
if {date} in YearToDate then
  formula = {value}
else
  formula = 0
end if

These can be summed over whatever grouping you have and will show the MTD and YTD totals. Summing will give you the ITD total.

HTH,

Carl

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question