Crystal Reports Format Colors

Report Design
Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design

Topic: Format Colors
	<< Prev Page of 2

Author	Message
rculbertson Newbie Joined: 31 Mar 2018 Location: United States Online Status: Offline Posts: 7	Posted: 06 Apr 2018 at 10:06am
	if {TrainingObjectiveHistory.tohobjTitle} = "iso facility use hours" and {TrainingObjectiveHistory.tohseshrs} <18 then crred
	Rculbertson
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 06 Apr 2018 at 10:15am
	dis you make the formula field for the conditional sum?... Create a formula field you will use to get the sum where only title = 'iso facility use hours' call it something like "iso_facility_use_hours_only". it will be if {TrainingObjectiveHistory.tohobjTitle} = "iso facility use hours" then {TrainingObjectiveHistory.tohseshrs} else 0
	IP Logged

rculbertson Newbie Joined: 31 Mar 2018 Location: United States Online Status: Offline Posts: 7	Posted: 06 Apr 2018 at 10:50am
	if {TrainingObjectiveHistory.tohobjTitle} = "iso facility use hours" and sum(@iso_facility_use_hours_only)<18 then CrRed else CrBlack Is still saying "The ) is missing
	Rculbertson
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 09 Apr 2018 at 3:56am
	if {TrainingObjectiveHistory.tohobjTitle} = "iso facility use hours" and sum({@iso_facility_use_hours_only})<18
	IP Logged

<< Prev Page of 2

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

This page was generated in 0.016 seconds.