Show first Op Comment on all rows in Job Traveler

Kinetic ERP
,
1

Good morning,
I am modifying a copy of the Job Traveler report. The goal is to provide a succinct list of all the operations for each assembly in a given job. The Job Traveler is setup nicely for this with checks in place to split by assembly allowing us to print a page for each assembly. I have made the changes to the RDL and it seems to work properly. However, I want to add one thing to each page. For each job, ASM 0, OP 10 is the starting op, this op has important information in the first line of the comments. I would like to show the first line of the comment text for ASM 0 OP 10 at the top of each page. The page breaks happen automatically for the assemblies, so I thought this would be easy.

Can I create a Report variable that is equal to ASM 0, Min(OpSeq), left(OpComment, 50)? Or something similar?

2

Since I am already filtering on the job, I can just take the first record. This expression worked and I didn’t need to use a variable:

First(Fields!CommentText.Value, "JobHead").Substring(0,50)