analysing strings
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=22938
Printed Date: 05 May 2024 at 11:31pm
Topic: analysing strings
Posted By: Lord Yorkshire
Subject: analysing strings
Date Posted: 28 Jun 2021 at 5:26am
We have report which shows the route of a product through production.
Each machine has a work center number that is stored as a string and not a number.
We have a series of tables, that show the Job Steps and these are on the Details section of the report.
PV_JobStep_1 = "001"
PV_JobStep_2 = "526"
PV_JobStep_3 = "221"
all three are separate records/fields and I want to look at all three records and pick the highest, so in this case "526"
Any assistance would be appreciated.
|
Replies:
Posted By: wsc27
Date Posted: 28 Jun 2021 at 5:35am
|
Did you want the one highest # of all of the records in the report? If so, could you do a run summary calculation setting the maximum of the string field value?
|
|