Excluding data from details section

[runnerlk]

I have a report in version 11 that uses a .xls as it's data source. I would like to remove or supress rows based when certain specific data appears in that row. Also, if a certain row is blank, then i would also like to remove it from the details and any totals.

Tried it with a formula in the section expert but no luck.

Any help would be greatly appreciated.

 

[lbass]

What formula did you try? You should try to remove rows using the selection formula, if you can. Otherwise, you can do conditional suppression by going into the section expert->details->x+2 and entering something like:

{table.field} = "A"

However, suppressed rows still contributed to summaries unless you specifically exclude them. You can handle this by using running totals that use a formula in the evaluation section:

{table.field} <> "A"

...i.e., by building in the opposite of your suppression criteria.

-LB

 

[briangriffin]

In the section expert there is a checkbox for 'Suppress Blank Section', so that should take care of that.

The suppression formula is the right way to go; under what circumstances do you want to suppress non-blank details, and what formula have you tried?

 

[runnerlk]

Ok I can use a selection formula. What i want to have happen is if a row contains "System created" then it is eliminated.

 

[lbass]

Then use a selection formula like this:

{table.field} <> "System created"

If the case can vary, then use:

ucase({table.field}) <> "SYSTEM CREATED"

Even better (for speed), create a SQL expression {%syscr}:

{fn ucase(table.field)}

{%syscr} <> "SYSTEM CREATED"

-LB

 

[runnerlk]

thanks lbass. worked perfectly