Joined: 27 Feb 2007
Online Status: Offline
Posts: 3
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
Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
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>
Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
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.
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>
Joined: 27 Feb 2007
Online Status: Offline
Posts: 3
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.
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