• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 411
  • Last Modified:

multiple condition section suppression

if i have groupings by "School Name" ...and after each detail record there is a line, is it possible for me to suppress that line based on multiple conditions?  In other words, I don't want the line below the last record of each group to appear above the header of the following group.

I actually have nested groupings:

- DISTRICT   (G1)
  - SCHOOL   (G2)
    - PARENT NAME   (G3)
      - DATE    (G4)

the group footer for "parent name," G3, is actually split into G3a & G3b.   G3b is where the line is that I need to suppress when the last 'record' of a parent grouping prints

In the section expert for G3b, I've tried the following formula:

{Students.SchoolName}  <>  next({Students.SchoolName})
or
OnLastRecord
//...i've also tried "OnLastRecord=true" just to be safe

The problem is that "OnLastRecord" never seems to work!   If I comment out the first line & the "or", it works perfectly though, but I need to accomplish both here!   Any help is much appreciated!

- travis
0
trs28
Asked:
trs28
  • 3
  • 2
1 Solution
 
zephyr_hex (Megan)DeveloperCommented:
try putting the first line of your formula in paranthesis:
({students.schoolname) <> next({students.schoolname}))    this way it's grouped together as 1 statement.
then follow it with your "or":
or
onlastrecord;
0
 
trs28Author Commented:
i've tried that ...and also tried grouping the entire thing in one parenthesis after doing what you suggested, but is that semicolon absolutely necessary at the end?   i'm a little foggy on when i should or shouldn't be using them.  I know that they need to be used with any control structures but foggy on every other circumstance
0
 
trs28Author Commented:
by the way, adding a semicolon didn't work for me either
0
Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

 
mlmccCommented:
I generally write formulas liek that in the other order.  I know it shouldn't matter but sometimes it seems to

OnLastRecord  OR
({Students.SchoolName}  <>  next({Students.SchoolName})

The problem is the NULL values tend to create trouble fo the comparison.

In your case if it is the last record then the NEXT( ) is NULL and the test automatically fails because the NEXT failed.

mlmcc
0
 
trs28Author Commented:
That worked perfectly mlmcc !!!   You're the man!   Thanks!

- Travis
0
 
mlmccCommented:
Glad i could help

mlmcc
0

Featured Post

[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now