Return only one value
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22533
Printed Date: 01 May 2024 at 12:35pm
Topic: Return only one value
Posted By: Beso90
Subject: Return only one value
Date Posted: 30 Jan 2018 at 7:40am
|
Hello,
I'm building a report on pricing for our products. We have price breaks, which is screwing me up. I only want the price that matches (or less than) the qty break. the first qty field is {PTORDER_REL.REL_QUAN} the qty break field is {ARINVT_BREAKS.QUAN} the price that is attached to the qty break field is {ARINVT_BREAKS.QPRICE} So let's say the qty breaks ({ARINVT_BREAKS.QUAN}) are: qty 100 --> $1 qty 1000 --> $0.75 qty 5000 --> $0.50 If my PTORDER QUAN is 2500, I want the price field to only return $0.75 (vs listing all three prices causing duplicates) because it's more than 1000 but still less than 5000. I hope my question makes sense. if not, I will answer any questions arise from this. But I really need help 
|
Replies:
Posted By: DBlank
Date Posted: 31 Jan 2018 at 6:53am
| you could try and add it to a join condition |
Posted By: Beso90
Date Posted: 02 Feb 2018 at 9:41am
| How do I do that? |
Posted By: DBlank
Date Posted: 05 Feb 2018 at 2:28am
| can you write a command or store procedure as your data source? |