Report Detail Line Suppression

Assume that a report has Customer, City, and Sales.

If Sales is equal to zero, I want to suppress the detail line from
printing/displaying. How do I do this? Is this done through an
Alerter perhaps?

Thank you.


Get Free Email and Do More On The Web. Visit http://www.msn.com


Listserv Archives (BOB member since 2002-06-25)

How about using a condition where Sales is not null? Or, right click on the
Sales cell, select Insert Filter, and select all values except 0.

George Baranowski
QuadraMed

Assume that a report has Customer, City, and Sales.

If Sales is equal to zero, I want to suppress the detail line from
printing/displaying. How do I do this? Is this done through an
Alerter perhaps?

Thank you.


Listserv Archives (BOB member since 2002-06-25)

Hi Rudy.
It can be done in the SQL with the WHERE clause not returning the row.
Will this do what you want it to?

Rudy Betke rbetke@HOTMAIL.COM 04/21/99 01:47PM >>>
Assume that a report has Customer, City, and Sales.

If Sales is equal to zero, I want to suppress the detail line from
printing/displaying. How do I do this? Is this done through an
Alerter perhaps?

Thank you.


Get Free Email and Do More On The Web. Visit http://www.msn.com


Listserv Archives (BOB member since 2002-06-25)

Rudy Betke schrieb:

Assume that a report has Customer, City, and Sales.

If Sales is equal to zero, I want to suppress the detail line from
printing/displaying. How do I do this? Is this done through an
Alerter perhaps?

You can do this via Filters


DI Walter Muellner
Delphi Software GmbH, Vivenotgasse 48, A-1120 Vienna / Austria
Tel: +43-1-8151456-12, Fax: +43-1-8151456-21
e-mail: w.muellner@delphi.at, WEB: http://www.delphi.at


Listserv Archives (BOB member since 2002-06-25)

I think it’s better to use “user defined” filters. Otherwise, you always will see
only those non-zero values which are returned by the actual query. If you re-run
the query with other parameters, you will miss some data.

Walter.

“Baranowski, George” schrieb:

How about using a condition where Sales is not null? Or, right click on the
Sales cell, select Insert Filter, and select all values except 0.

George Baranowski
QuadraMed

Assume that a report has Customer, City, and Sales.

If Sales is equal to zero, I want to suppress the detail line from
printing/displaying. How do I do this? Is this done through an
Alerter perhaps?


DI Walter Muellner
Delphi Software GmbH, Vivenotgasse 48, A-1120 Vienna / Austria
Tel: +43-1-8151456-12, Fax: +43-1-8151456-21
e-mail: w.muellner@delphi.at, WEB: http://www.delphi.at


Listserv Archives (BOB member since 2002-06-25)

What about suppressing detail lines based on calculated fields? I cannot
put a filter or a user defined filter on a calculated field. For example I
want to divide my number of customers by the number of invoices and if that
number is less than 30% I have a alerter that prints “<30%” but how could I
suppress the other detail lines? In some cases I would like to filter where
invoices is greater that 5 or something, but it won’t let me because it is a
“count” ed field, I suppose.
Thanx.

            I think it's better to use "user defined" filters.

Otherwise, you always will see
only those non-zero values which are returned by the actual
query. If you re-run
the query with other parameters, you will miss some data.

            Walter.



            "Baranowski, George" schrieb:

            > How about using a condition where Sales is not null?  Or,

right click on the
> Sales cell, select Insert Filter, and select all values
except 0.
>
> George Baranowski
> QuadraMed
>
> Assume that a report has Customer, City, and Sales.
>
> If Sales is equal to zero, I want to suppress the detail
line from
> printing/displaying. How do I do this? Is this done
through an
> Alerter perhaps?


Listserv Archives (BOB member since 2002-06-25)