Solved

multiple condition section suppression

Posted on 2006-06-15
6
400 Views
Last Modified: 2010-08-05
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
Comment
Question by:trs28
  • 3
  • 2
6 Comments
 
LVL 42

Expert Comment

by:zephyr_hex
ID: 16914571
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
 

Author Comment

by:trs28
ID: 16914623
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
 

Author Comment

by:trs28
ID: 16914637
by the way, adding a semicolon didn't work for me either
0
Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

 
LVL 100

Accepted Solution

by:
mlmcc earned 250 total points
ID: 16917707
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
 

Author Comment

by:trs28
ID: 16920094
That worked perfectly mlmcc !!!   You're the man!   Thanks!

- Travis
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 16924735
Glad i could help

mlmcc
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

746 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now