Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: need help with details section formula Post Reply Post New Topic
Author Message
mrbassman26
Newbie
Newbie


Joined: 27 Feb 2007
Online Status: Offline
Posts: 3
Quote mrbassman26 Replybullet Topic: need help with details section formula
    Posted: 27 Feb 2007 at 5:24am
i have a packing slip report with 2 detail sections.  can i select which details section to display/print as the line item based on whether the line item is a stock item (orderitem.type) =1 or a miscellaneous item (orderitem.type) = 3 ??  i don't want to use the suppress method, i need to be one section or the other.  thanks
IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet Posted: 27 Feb 2007 at 8:36am
Yes you can do this. You would still use the Suppress property, but assign a formula to each detail section. Suppress one detail section if it equal 3 and suppress the other one if it is equal to 1. That way you always see one of them but not the other.
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
mrbassman26
Newbie
Newbie


Joined: 27 Feb 2007
Online Status: Offline
Posts: 3
Quote mrbassman26 Replybullet Posted: 27 Feb 2007 at 9:35am
could show a sample code, i must be having major brain fart as can't quite get it right.
IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet Posted: 27 Feb 2007 at 10:13am
I have sample code in my free online chapter on Crystal Reports multiple sections. If this doesn't help, please let me know so I can modify the chapter accordingly.

http://www.crystalreportsbook.com/Crystal_Reports_XI.asp?Page=8_3
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
mrbassman26
Newbie
Newbie


Joined: 27 Feb 2007
Online Status: Offline
Posts: 3
Quote mrbassman26 Replybullet Posted: 27 Feb 2007 at 10:34am
it's close.  what i am doing in my report is,i have a multiple line packing slip, each line is either a "stock" part or a "non-stock" or miscellaneous part.  the miscellaneous part uses one or two different fields than the stock part.  so basically what i need to happen is:
     if line item = stock then use details section a else use details section b
hope that makes sense.  
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.016 seconds.