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: 04 May 2024 at 5:47am
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
Posted By: DBlank
Date Posted: 05 Feb 2018 at 2:28am
can you write a command or store procedure as your data source?
|
|