Print Page | Close Window

Group in Mailing Label Wizard

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=1404
Printed Date: 06 May 2024 at 2:13pm


Topic: Group in Mailing Label Wizard
Posted By: newbie
Subject: Group in Mailing Label Wizard
Date Posted: 28 Sep 2007 at 1:08pm
Hello All,
 
I have to design a report which looks like this.
 
 
State             st_code                      |   State        st_code
order_no       order_amt                  |   order_no   order_amt
....                                                 |
.. display the order details down and across  
.. for each state.
 
I used mailing label wizard, I don't see "Group selection" in the wizard.  The Group "St_code" is created Manually above the "Mailing Details section" which contains order_no and order_amt.  The data displays down and across the page for each state code.  Each state code details should print in a next page.
 
Now the problem is, since I created manually the Group "st_code", the right hand side state_code display its value when there no orders prints right hand side.
 
Example:
 
State             AL                              |   State        AL
1                    $200.00                     |  
2                    $325.79                     |
3                                                     |
so on.
 
The right hand side "St_code" shows "AL" when there is no records to display.
 
How to resolve this issue?  I used query in "Command" using CR XI.
 
Thanks
VK
 


Replies:
Posted By: newbie
Date Posted: 01 Oct 2007 at 7:53am
Can anyone let me know how to make a Group in Mailing Label and also how to include Headers of the mailing label columns. 
 
Please help me?
 
Thanks in advance.
VK
 
 

Posted By: dada.dhumal
Date Posted: 04 Oct 2007 at 4:58am
for -- newbie
 
use mailing label report
go to section expert  for detail section
go to layout
set height=0.5in and width=3in
then add group of st_code manullay
supress group header and group footer
add stcode in details a --- set the field as supress if duplicate
add order no and order amount in details b
go to group expert and set - keep group together .
 
 


Print Page | Close Window