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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Summing / Counting field based on Field (after printing)

Status
Not open for further replies.

ricolame

IS-IT--Management
Nov 9, 2005
82
CN
Hi,

I've use a summary field in my report which pulls out a maximum date from my list of records.

On top of that, instead of using selection to select my records (since it could not work due to 'reqd after printing') , i perform a suppression of field based on a condition such that {@maxdate}< {?date}.

Now, is there any get away that i can do to perform a distinct count of records that fit in {@maxdate}< {?date}?

I tried another way, but same error prompts again for 'reqd after printing'

any guidance here?
 
Post specifics:

Crystal version
Database/connectivity used
Example data
Expected output

You may be able to create a formula to do this, such as:

numbervar MyTotal;
if {table.date} < maximum({table.date}) then
1
else
0

Then in a section subsequent to the details display the results by using a sum of the above.

-k
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top