Multiple values on same line
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=22706
Printed Date: 03 May 2024 at 5:00pm
Topic: Multiple values on same line
Posted By: kris_a
Subject: Multiple values on same line
Date Posted: 04 Dec 2018 at 8:58am
I'm hoping I can describe this correctly. I have a couple reports that I am needing the same functionality from and therefore am having the same issue.
The reports are based on a Part No. and I am trying to generate multiple value horizontally on the same line - however all of the values are coming from the same data field so it is replicating the line for each different criteria. Example:
Part No. Pricelist 1 Pricelist 2 Pricelist 3
Part A 2.00 0.00 0.00
Part A 0.00 2.00 0.00
Part A 0.00 0.00 2.00
So rather than having 3 lines for the same part, I would like one line per part with it's price on each of the pricelists:
Part A 2.00 2.00 2.00
*Side note: I already checked Select Distinct Records and have a left outer join on the main table.
|
|