need help with details section formula
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=245
Printed Date: 06 May 2024 at 1:28am
Topic: need help with details section formula
Posted By: mrbassman26
Subject: need help with details section formula
Date 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
|
Replies:
Posted By: BrianBischof
Date 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>
|
Posted By: mrbassman26
Date 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.
|
Posted By: BrianBischof
Date 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 - 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>
|
Posted By: mrbassman26
Date 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.
|
|