We are having issues with our header printing on each page (It does not)
For this example, and using the Job Traveler Style for SSRS that Epicor provides with Kinetic, we are losing some job info that we would like to have on every page…but are unable to fix this using Report Builder.
Red square - Page Header
Green Square - First non-grouped Row in Tablix
Blue Square - Raw Materials Sub Report
If the job that we are printing has a lot of materials, the Raw Materials sub report (blue square) will continue on the 2nd page. When this happens, the “Fixed” row (green square) disappears on the 2nd page, taking with it the Job #, Asm #, part #, description, etc. The “Fixed” row (green square) then reappears on the 3rd page if the sub report (blue square) has ended on the 2nd page.
How can we get the “Fixed” row (green square) to stay on every page, regardless of any sub report?
We’ve tried moving the info from the “Fixed” row (green square) up to the Page Header (red square) , but we’ve found that any fields put there do not change as the job progresses, (such as the Assembly #). Or, if we try to print multiple jobs, then the job # doesn’t change, either.
We’ve found out that any fields put into the job header have to be aggregate fields (First, Last, Average, Sum, etc.), and that also doesn’t allow the fields to change for multiple assemblies or job #'s.
