Hello~!
I have a default SSRS for Job Traveler and is does something I want to replicate on another, different report. The first two rows appear on every page. Where is the option to turn this on?
It is not a header. It’s part of the table.
JobTravBinTest.rdl (135.0 KB)
Thank you.
If it is the JobNum row and the barcode row below it, this is due to this Row Group being set up to start a new page with each new row group (i.e., each new Bomsequence).
In Report Builder or Visual Studio, right-click on the row (to the left of the actual table) > Row Group > Group Properties > Page Breaks. There you have a break “Between instance of a group” checked.
So the one I am working on has it like this, but it only shows up on the first page. BTW, you are correct with your assumption.
I tried with CustID and it didn’t work. Basically, I am trying to make it so CustID shows up on every page.
I think instead of “=CustID” you want “=First(CustID)”, which would be the ‘first’ customer in that invoice group; but since there is only 1 customer per invoice, that will be the right customer.
The problem with that is when they print our a batch, it just uses one/the first CustID. The way I have it now, just as a top row, works even in batches. But it doesn’t appear on every page of the individual invoice, like the header does. When I put it into the header, it brings CustID but only one – so a batch comes out as just the first ID used even if its the wrong one.
Do you know how to enter the Advanced Mode in the RDL?
No, but I am willing to try!
In the report, turn on Advanced Mode.
It is going to create a lot of (Static) lines in the groupings. Click on the line that correlates to the row. Looks like it would be the first one based on your screen shot. Go to the Properties and change the Repeat on new page property.
Okay I did that, went to save, and got this error:
The tablix 'Tablix1' has an invalid TablixMember. The TablixMember must have the same value set for the RepeatOnNewPage property as those following or preceding the dynamic TablixMember. (Expected Value: "True"; Actual Value: "False")
Sorry, I did not notice that it was included in a row group. Add a row above it OUTSIDE of the group. Add the field in the new row and delete the existing row. Then set the repeat on new page for the new line.
That did put the CustID on each page, but it’s only using the CustID of the first invoice. I am printing a group, and it repeats the first one.
You could try putting the CustID in another field within the report, hide the field, and then use the textbox reference to populate it. I’m not sure it will work, can’t remember the rendering hierarchy. But once you add the field, this is what you would put in the other field.
=ReportItems!TextBoxXXX.Value