Crystal Reports Cross-Tab Conditional Formatting

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

Topic: Cross-Tab Conditional Formatting

Author	Message
abrown Newbie Joined: 15 May 2009 Online Status: Offline Posts: 9	Topic: Cross-Tab Conditional Formatting Posted: 20 Apr 2011 at 4:41am
	I have a Cross Tab. I want to set a conditional format to a summarized field. If the summarized field is less than zero I want it to show 0. Where do I do this? Thank you, A
	IP Logged

abrown Newbie Joined: 15 May 2009 Online Status: Offline Posts: 9	Posted: 20 Apr 2011 at 5:22am
	I figured it out. You select the summarized field, right click to Format Field-- Common tab-- Suppress-- Click on formula button and put in CurrentFieldValue<=0
	IP Logged

abrown Newbie Joined: 15 May 2009 Online Status: Offline Posts: 9	Posted: 21 Apr 2011 at 9:09am
	Now I got that part working but I now want to sum all of the fields up to get a total. Problem is that when I do a formula to sum the fields it also sums the negative numbers and I only want it to sum if the value is a positive number. Can I do that?
	IP Logged

Post Reply

Post New Topic

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

This page was generated in 0.016 seconds.