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:

 

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

 

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 .