Crystal Reports Dynamic Suppress

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

Topic: Dynamic Suppress
	<< Prev Page of 2

Author	Message
GunChild Newbie Joined: 27 Sep 2011 Location: Philippines Online Status: Offline Posts: 9	Posted: 28 Sep 2011 at 7:04am
	it's on the detail
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 28 Sep 2011 at 7:08am
	Please show some sample row level data from the sql_DB_1.fld_Grump field, explaining in each row why the image on its related row should be suppressed or why it should be shown.
	IP Logged

GunChild Newbie Joined: 27 Sep 2011 Location: Philippines Online Status: Offline Posts: 9	Posted: 28 Sep 2011 at 7:13am
	I had one image and one field which is fld_grump. if the fld_grump has an output of klp I want to hide the image.
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 28 Sep 2011 at 7:22am
	still not anwereing my question for some sample data but i will try again. right click on the image select format graphic select common tab select the formula box (X-2) to the right of the 'Suppress' option enter the suppression criteria here *{sql_DB_1.fld_Grump) like "klp"*
	IP Logged

GunChild Newbie Joined: 27 Sep 2011 Location: Philippines Online Status: Offline Posts: 9	Posted: 28 Sep 2011 at 7:30am
	{sql_DB_1.fld_Grump) like "klp" if the field is equal to klp then image will suppress?
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 28 Sep 2011 at 7:41am
	if the field has 'klp' anywhere in the string examples: "I am a klp row" - suppresses " I am a kl p row" - does not suppress "abcdeklpwxy" - suppresses "klp" - suppresses if it is always just klp with no other letters before or after you can use {sql_DB_1.fld_Grump) ="klp"
	IP Logged

GunChild Newbie Joined: 27 Sep 2011 Location: Philippines Online Status: Offline Posts: 9	Posted: 28 Sep 2011 at 7:50am
	left ({sql_DB_1.fld_Grump,3)="klp" much better if I used this Thanks for your help sir
	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.031 seconds.