Active TopicsMemberlistSearchHelpRegisterLogin

Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: grouping Post Reply Post New Topic
Author Message
shamee_banu
Newbie
Newbie


Joined: 15 Mar 2007
Location: Solomon Islands
Online Status: Offline
Posts: 28
Quote shamee_banu Replybullet Topic: grouping
    Posted: 16 Apr 2007 at 6:22pm
hi
i am doin scheduled lots report which consist of 3 groups and some details
the three different types of group is plant stat time, part id, start quntanty.
 
in the detail fileld i have about 5 infor lot id, lot type , location, tool and reQDtime
 
so when i preview it shows like  this .....
 
Planstarttime                        
11/12/2006
               partId
               520019
                            startQTY
                                1
 
i  hide the details so when click on the startQTY it will display the datails
my problem is that i want to make the report in the horizontal like
 
 
Planstarttime        partId        start QTY
  11/12/2006      520019              1         
 
how do i do this please help
thankz
 
IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet Posted: 16 Apr 2007 at 7:26pm
You can set the group headers to have the Overlay Following Section turn on. That way the three group headers appear on the same line. Or you could just put all the fields in the last group header. Just because you have a group section for a certain field, you don't have to put the data in that header and it will still group fine.


Edited by BrianBischof - 16 Apr 2007 at 7:28pm
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
IP IP Logged
shamee_banu
Newbie
Newbie


Joined: 15 Mar 2007
Location: Solomon Islands
Online Status: Offline
Posts: 28
Quote shamee_banu Replybullet Posted: 16 Apr 2007 at 11:37pm
i did try  but then how about the details section . the header for the details in PH.  i want the header to appear only when i click on the startQTY .
 
i tried putting in the details section, when i preview the header tent to appear more than once for example if i have 6 startQTY  the header appear 6 time
 
i want the header to appear only when the click on the startQTY and should appear once any idea of how to do it ........
 
   Stern%20Smile
 
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 18 Apr 2007 at 9:06am
Put the header in a separate details section from the data and in the suppress formula for that section, try:
 
({table.partId} = previous({table.partId})) and
({table.startQty} = previous({table.startQty})
 
This should suppress the header when the partID and startQTY values are the same as the previous record that was displayed.
 
-Dell
Proviti, Data & Analytics Practice
www.protiviti.com/US-en/data-management-advanced-analytics
IP IP Logged
shamee_banu
Newbie
Newbie


Joined: 15 Mar 2007
Location: Solomon Islands
Online Status: Offline
Posts: 28
Quote shamee_banu Replybullet Posted: 18 Apr 2007 at 10:54pm

i have now created two detail section a and b, section a is for the header and b is for the data in the detail section . the headers are

LotID  LotType  Location  Tool  ReQdTime
 
so i am suppose to create formular based on  this right
e.g
({Command.LotID} = previous ( {Command.LotID} )) and
({Command.LotType}= previous){Command.LotType})and
. .......
 
 
i use this formular on the section a in detail section  because it is the header that i dont want to repeat with the data but after doing this the header still repeats what shall i do .....
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 19 Apr 2007 at 7:15am
Is this in the Suppress formula for the section or as a regular formula?  The formula isn't a "formula" but in the Suppress formula for the section.
 
- Right-click to the left of the section and select Section Expert.
- On the right side of the screen, there's an option labelled "Suppress" with a checkbox and a button.  Click on the button.
- The formula editor will appear.  Enter your formula.
 
When you create the suppress formula, make sure that it includes ONLY the the fields that are your group fields - NOT the detail fields!
 
-Dell
Proviti, Data & Analytics Practice
www.protiviti.com/US-en/data-management-advanced-analytics
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.017 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.