Author |
Message |
GunChild
Newbie
Joined: 27 Sep 2011
Location: Philippines
Online Status: Offline
Posts: 9
|
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 Logged |
|
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|
Posted: 27 Sep 2011 at 11:55am |
{sql_DB_1.fld_Grump} like ["klp*","WRT*"]
|
IP Logged |
|
GunChild
Newbie
Joined: 27 Sep 2011
Location: Philippines
Online Status: Offline
Posts: 9
|
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 Logged |
|
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|
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 Logged |
|
GunChild
Newbie
Joined: 27 Sep 2011
Location: Philippines
Online Status: Offline
Posts: 9
|
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 Logged |
|
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|
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 Logged |
|
GunChild
Newbie
Joined: 27 Sep 2011
Location: Philippines
Online Status: Offline
Posts: 9
|
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 Logged |
|
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|
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 Logged |
|
GunChild
Newbie
Joined: 27 Sep 2011
Location: Philippines
Online Status: Offline
Posts: 9
|
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 Logged |
|
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|
Posted: 28 Sep 2011 at 7:04am |
where are you placing the graphic? Detail, Group header, footer...???
|
IP Logged |
|
|