Active TopicsMemberlistSearchHelpRegisterLogin

Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Multiple column supressing Post Reply Post New Topic
Author Message
ssweeney
Newbie
Newbie


Joined: 17 Aug 2007
Location: United States
Online Status: Offline
Posts: 5
Quote ssweeney Replybullet Topic: Multiple column supressing
    Posted: 22 Aug 2007 at 1:08pm
i currently have a subreport that has the following look
 
name______                   Name__________
 
Name______                  Name________
 
i have each line on a seperate details.  I am supressing detail b (second line) if count of sum is >2.
 
works if i get two names.  it looks like this
 
name George                   name shawn
 
name______                   Name_______
 
I need the extra lines on forms for someone to fill in.
 
If i get three then i get only three name fields instead of 4.  I will always need four. 
 
This is situated to be formated with columns so i can get all names on the list.
 
Suggestions to see 4 when i only have one name and 3?  When i have one i get
 
name  shawn
 
name _________
 
 
Smile - ssweeney
 
 
IP IP Logged
bliddel
Newbie
Newbie


Joined: 05 Sep 2007
Location: United States
Online Status: Offline
Posts: 1
Quote bliddel Replybullet Posted: 05 Sep 2007 at 7:36am
I'm such a newbie that I have never even seen Crystal reports.  However, if I needed to do this in MS Access, I'd use a calculated field something like this:  Iif([Name] is Null, "_______",[Name]) and forget all about suppression of columns.  
IP IP Logged
wattsjr
Groupie
Groupie
Avatar

Joined: 25 Jun 2007
Location: United States
Online Status: Offline
Posts: 51
Quote wattsjr Replybullet Posted: 05 Sep 2007 at 10:52am
Without knowing the source of the names, I can't guarentee that this will work.  But if each of the names is stored in a separate database field (ie. Signee1,Signee2 etc.) in the same record, then the following should work for you.
 
1. Create a Formula for each Name. (ie. Signee-1, Signee-2)
2. Adapt the following formula to fit your database naming conventions for all 4 formulas:
  
   If IsNull(Signee1)
      Then "Name: _________"
      Else "Name: " + TrimRight(Signee1) 
 
3.  In you report detail you would have:
 
             @Signee-1        @Signee-2
             @Signee-3        @Signee-4
 
I hope that this works for you.
-jrw
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump 		You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.
HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | CLICK PLAYS | COACH FORUMS | TROPICAL FISH

© 2004-2024 Brian Bischof. All Rights Reserved.