Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: Dynamic Suppress Post Reply Post New Topic
Page  of 2 Next >>
Author Message
GunChild
Newbie
Newbie


Joined: 27 Sep 2011
Location: Philippines
Online Status: Offline
Posts: 9
Quote GunChild Replybullet Topic: Dynamic Suppress
    Posted: 27 Sep 2011 at 11:29am
I got three types of report which show and hide according to what is needed. My problem is how do I suppress if the fields that contains with a text 'KLP*' and 'WRT*'.

Here is the example code that I put in the object.

//Len({sql_DB_1.fld_Grump})=WRT*
not(isnull{sql_DB_1.fld_Grump}))like 'KLP','WRT'))

I want to suppress the object if the fld_grump has the value of klp and wrt.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 27 Sep 2011 at 11:55am
{sql_DB_1.fld_Grump} like ["klp*","WRT*"]
IP IP Logged
GunChild
Newbie
Newbie


Joined: 27 Sep 2011
Location: Philippines
Online Status: Offline
Posts: 9
Quote GunChild Replybullet Posted: 27 Sep 2011 at 12:03pm
suppress if {sql_DB_1.fld_Grump} like ["klp*","WRT*"]

Suppress if it contains with KLP wrt?
tried it no luck
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 27 Sep 2011 at 12:12pm
the formula i gave you is a row level or field level suppression option.
there is no "If" in it, just the boolean reulst of this:
{sql_DB_1.fld_Grump} like ["klp*","WRT*"]
 
IP IP Logged
GunChild
Newbie
Newbie


Joined: 27 Sep 2011
Location: Philippines
Online Status: Offline
Posts: 9
Quote GunChild Replybullet Posted: 28 Sep 2011 at 4:49am
much better if I do this way?

left ({sql_DB_1.fld_Grump},6)="klpWRT"

I haven't tried this yet.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 28 Sep 2011 at 4:54am

these are in the same field for the same row?

{sql_DB_1.fld_Grump} like ["*KLP*WRT*","*WRT*KLP*"]
IP IP Logged
GunChild
Newbie
Newbie


Joined: 27 Sep 2011
Location: Philippines
Online Status: Offline
Posts: 9
Quote GunChild Replybullet Posted: 28 Sep 2011 at 6:47am
or I should say if the report contains a field with klp i want to suppress the object.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 28 Sep 2011 at 6:50am
I cannot understand your request.
To help, please show some sample row level data (with any grouping) and exactly what you want suppressed with why (for that row)
IP IP Logged
GunChild
Newbie
Newbie


Joined: 27 Sep 2011
Location: Philippines
Online Status: Offline
Posts: 9
Quote GunChild Replybullet Posted: 28 Sep 2011 at 7:01am
{sql_DB_1.fld_Grump) = "klp" "WRT

if those two words (klp and wrt) is pull from the DB i want to suppress the selected object.

here's what i did.
1. image right click -> format graphic
2. check the suppress box
3. click the x-2 icon
4. formula.

My question above is what formula do i put if the field grump pulls the record klp or wrt.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 28 Sep 2011 at 7:04am
where are you placing the graphic? Detail, Group header, footer...???
IP IP Logged
Page  of 2 Next >>
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.032 seconds.