Creating an Action Summary using Fuzzy Date fields

Options
Samantha Linton
Samantha Linton ✭
Ninth Anniversary
in Blackbaud Raiser's Edge NXT®: General Discussion
Hello out there! I am working on a Crystal Report that expands upon the canned Action Summary Report in RE. Basically I need to group the report by Action category/Solicitor, then get a count of the # of actions for This Week, Last Week, This Month, Last Month, This FY, Last FY. I cannot get the counts or date columns to work correctly - any suggestions? TIA!
Tagged:

Comments

  • Chelsea Powell
    Chelsea Powell ✭
    Eighth Anniversary Photogenic First Reply
    Hey Samantha!

    Have you got it to work yet? What immediately comes to mind is putting each one of those time frames in its own subreport in its on section. Then in each subreport create a running total field or maybe a formula that will sum each based on the data parameters you set. What's your crystal report doing now with the counts?

Categories