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
QuadraMedAssume 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)