|
-
May 2nd, 2006, 01:39 PM
#1
Thread Starter
Member
Crystal* Formula help please
I have a crystal report where I group by case number.
The idea is to print a message beneath each group if there is a carton#
Packing note print after every case the following;
Qty Description Weight
5 External Modems .3
7 Keyboards .2
6 Harddrives 1
All above packed into Carton# 1
4 Motherboards .4
3 Internal Modems .2
6 Boxes CD-R 1
All above packed into Carton# 2
The above is fine but if items are not packed into a carton then the following still prints but without the carton #
2 Monitors 5.3
1 HP Printer .9
All above packed into Carton#
How do I adapt my formula not the print the message if the Carton# fileld is empty?
My formula currently is:
"All above packed into Carton# " & {Details.caseno}
Suppose should be some thing like:
"All above packed into Carton# " & {Details.caseno} where {Details.CaseNo} > ""
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|