Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Display data outside search criteria 1

Status
Not open for further replies.

crachic

Technical User
Dec 27, 2007
46
US
I am trying to display a running total that displays information that is outside of the search criteria. For example I only want to list the referrals that fall inside my search criteria but there is one field that I want to use the entire database for and not limit the calculations to just the search criteria. For example

Referral Name Referral Phone # Contact # of referrals
John Doe 123-456-7890 Bill Smith 5
Jane Doe 123-789-4560 Joe Hamilton 2

I want the Referral Name, Phone # and Contact to display within the parameters of the search criteria but I want the running total (# of referrals) to calculate from the beginning of time to the end date parameter.

I have a grouping and it is grouped by the referral name so I know that the reset feature of the running total would be to reset on group # 1.

I am using crystal 11.

Any thoughts?

-crachic
 
Conditionally suppress these records rather than excluding them from the report with selection criteria.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

"What version of URGENT!!! are you using?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top