Data Summarization with multiple date fields...

[Scottpuck]

Hello everyone... I have a question that I really should be able to figure out, but have not been able to as of yet. I am attempting to create a report that summarizes the number of tasks that have been submitted and completed for a date range. All "tasks" have a unique ID, and are tracked by two seperate fields in different tables (date submitted, date completed). Essentially what I am attempting to do is display in columns, the number of tasks that have been submitted, and the number of tasks that have been completed for the date range. I have no problem summarizing one or the other, but when I attempt to combine them both on the same report I am unsuccessful. Would anyone have any suggestions on how to do this???

 

[kenhamady]

First you need a selection formula that includes all records that either started OR ended in the range:

( {SubmitDate} in {?start} to {?end} OR
{CompleteDate} in {?start} to {?end} )

Then you need two formulas for counting like:

if {SubmitDate} in {?start} to {?end} then 1 else 0

Then do totals of these two columns.
Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com

 

[Scottpuck]

Thanks Ken...