Solved

multiple condition section suppression

Posted on 2006-06-15
6
405 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
6 Comments
 
LVL 43

Expert Comment

by:zephyr_hex (Megan)
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
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…

759 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