Skip to Content
avatar image
Former Member

How to filter data based on reset value in report ?

ex1.jpg ex2.jpg ex3.jpg Dear Experts ,

I want to filter report data based on condition . Please look into the image file , i have attached a sample format which reports look like .

I want to display Max of Manual Group value alone in report as per attached file when total record no > 10 for the max of group value . Else report should be blank .

In Report Header i am using below formula to reset :

Whileprintingrecords;

Numbervar MGroup:=1;

In Group Header i am using below formula :

Whileprintingrecords

Numbervar MTotal; Numbervar MGroup;

If MTotal > 10 then (MTotal := 0; MGroup := MGroup+1)

MGroup;

In Detail Section i am using below formula :

Formula 1 (Month Count ): Whileprintingrecords

Numbervar MTotal := MTotal+1

Formula 2 (Manual Group): Whileprintingrecords

Numbervar MGroup;

Please advise .

ex1.jpg (160.3 kB)
ex2.jpg (171.3 kB)
ex3.jpg (156.5 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Jun 06, 2017 at 02:59 PM

    You can not use a variable to suppress headers or details based on a summary value.

    You will need to use group suppression

    Ian

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 06, 2017 at 03:47 PM

    In group selection enter

    Count(anyfield, groupfield) <> 0

    Any groups where above count = 0 will be suppressed

    Ian

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thanks Ian ,

      But in my scenario this one not helps for me , because i am using MonthYear group in report , where all month i have an record . Just i am trying to manually reset a record number group wise when its crossed count value 10 .

      In Report i want to display both Mar and Apr value record as per sample file , if i applied above condition in report none of the group get suppress .

      Please advise . ex2.jpg

      ex2.jpg (171.3 kB)
  • Jun 06, 2017 at 04:19 PM

    Change group suppression to

    Count(anyfield, groupfield) > 10

    Add comment
    10|10000 characters needed characters exceeded