How to suppress certain rows conditionally in CR11 1

[madsstiig]

Hi.
I'm trying to make a report 'look nicer' by suppressing irrelevant rows.
I made a formula field (@Status):

if {VWALLNEW.STTEXT} startswith "Udeb" then "Udebl." else "Anden status"

I then want the report to suppress the rows where @Status is not "Udebl."

How do I do that?​

 

[kray4660]

Have you looked at the section expert and the formula area for suppressing details? If not, then in the formula editor for suppressing the detail, put in @Status <> "Udebl". The formulas in the section expert are looking for a Boolean (True/False) result. Just remember that for the suppress formula, you want a True result to suppress.

 

[hilfy]

Do you need the non-"Udebl." data in the report for any sums or counts? If not, I would go to the Select Expert and add the following:

{VWALLNEW.STTEXT} startswith "Udeb"

If you have other criteria already set up, you'll need to put "and" in front of this in the select formula.

This will keep the records that you don't want to show from even being pulled from the database for the report, which will probably also speed it up.

-Dell

DecisionFirst Technologies - Seven-time SAP BusinessObjects Solution Partner of the Year

http://www.decisionfirst.com

 

[madsstiig]

Hi.
Thank you both for your response.
@hilfy: yes I'm sorry I didn't mention but I need the counts on "Anden status" so your advice didn't help
@kray4660: Worked like a charm - thank you