Crystal Reports running total to a stop date

Technical Questions

Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions

Topic: running total to a stop date

Post Reply

Post New Topic

Author	Message
walkitinkid Newbie Joined: 16 Jun 2011 Online Status: Offline Posts: 16	Topic: running total to a stop date Posted: 22 Jun 2011 at 9:12am
	Im trying to edit a report I didn't make. it has a "running total" in it Summary: Field to Summarize: ado.uscode Type of summary: count Evaluate: use a formula: {ado.EventType} LIKE "Vacant Rented*" and {ado.Type} = "Occupancy" please help.
	IP Logged


Keikoku Senior Member Joined: 01 Dec 2010 Online Status: Offline Posts: 386	Posted: 22 Jun 2011 at 9:55am
	add the date condition to the evaluate formula. ... and {ado.date_field} < the_date_it_should_stop Then it will not add anything after to the total.
	IP Logged

walkitinkid Newbie Joined: 16 Jun 2011 Online Status: Offline Posts: 16	Posted: 22 Jun 2011 at 10:30am
	it did not work, with or without the 3rd "and" statement I still get the same results. I also tried to copy the "running count" and so I have duplicates, with the only difference being the date, they both equal the same. Edited by walkitinkid - 22 Jun 2011 at 10:32am
	IP Logged

kostya1122 Senior Member Joined: 13 Jun 2011 Online Status: Offline Posts: 475	Posted: 22 Jun 2011 at 11:01am
	if duplicates then probably linking problem. try connecting date fields or other field which could logically be connected in tables that you use for this report.
	IP Logged

Printable version

Printable version

Forum Jump

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum