How to use filtergroup method ?

soofian

Hi All,

I want to filter the data in report in such away that these three fields
"Sales (Qty.)", "COGS (LCY)" and "Sales (LCY)" all should not be equal to zero.

The only thing I know is that, filtergroup() method will be used for applying combination of filters for filtering such type of data.

I don't know how to use it. Can anybody explain by example plz ?

kriki

You don't need FILTERGROUPS in your case.
Just this:

SETFILTER(Sales (Qty.)",'<>0');
SETFILTER("COGS (LCY)",'<>0');
SETFILTER("Sales (LCY)",'<>0');

See also http://www.mibuso.com/forum/viewtopic.php?t=16659.

Edited the post:to put the FILTERGROUP example in Tips & Tricks.

Waldo

First of all, this is a "heavy" filter ... .
Second,
don't know what you're trying to reach with FILTERGROUP? You should be careful with filtergroups, because all different groups are all effective simultaneously. Usually, filtergroups are used to "hide" the filters for a user, but for your report, this is not necessary. There is a lot to find about FILTERGROUP in the help of C/SIDE, as well as on this forum.

For you report,
you can set the filters on the dataitem of the report (suppose you mean Cust. Ledger Entry?).

Waldo

Posting at the same time ... sorry kriki

kriki

Waldo wrote:

Posting at the same time ... sorry kriki

No problem.
I also edited my post. It is a nice one for Tips&Tricks.