Report Builder - Getting group header to show the first value of the group

Epicor ERP 10
1

I’ve had no luck in my google searches but I’m hoping someone here can help me.
I am trying to create a BAQ Report that shows the Serial Numbers assigned to the job.
I added a table and then a group by JobNum.
It took a bit to get what I wanted, and it works if I just print one job, but I want it to be able to print more than one job at a time. In the group header I am showing the job number with First(JobHead_JobNum) and that works just fine but when it breaks to the next job, the serial numbers are correct but it still shows the job number from the very first row, which makes sense to me. I added the scope to the First statement (First(JobHead_JobNum, “JobNumGroup”) and I get an error that the scope is not valid.

I’m wondering if it has anything to do with me changing the format for grouping because I didn’t want the job number to be listed in the left column. I deleted that column and added header rows to get the format that I want.

Here is the layout of my report right now. Any idea?

image
image842×448 28.5 KB

2

What happens if you make the header expression Fields!JobHead_JobNum.Value (drop the “First”)?

3

I was hoping that would work but it just shows the same job number on each page even thought, based on serial numbers, it is putting a page break between pages and the serial numbers for the other job are showing.

4

I added the job number to the details to show it is different.

image
image876×217 7.36 KB

5

I see what I did wrong. I inadvertently deleted the group header and I was putting my details in the static section.