Repeat header on Each page of Sub Report

[former_member197302]

Hi

I have one Sub Report where there will be multiple page. But page header displays only Once. So I created Group

and selected the Repeat Group Header On Each Page

But Then it displayed like Below

So I entered below formula. But it makes the page header appear only begining .. I want on each page. Any help is most welcome

[abhilash_kumar · Accepted solution]

Hi Naman,

I followed the steps I posted above and it worked for me. I've attached the updated report here:

https://1drv.ms/u/s!AuxdZLwPbS04jhddI0fO0z86I3Ed

-Abhilash

[former_member197302 · Accepted solution]

Thank you.. I got it now.. I have to create group using formula. I misunderstood that.

Thank you

[former_member1254384 · Accepted solution]

Hi Abhilash,

I have the same requirement. I got the same format. But the issue is, when I'm exporting the this report into text, the header is not repeating in every page. Could please help me on this.

Thanks,

[Former Member]

If you do as Abhilash says just create a top group on the formula @Fake_grp as he suggested, In the Group header place the field

({Command.Document Number}

This will now show the current doc number on each page

Ian

[abhilash_kumar]

Hi Naman,

The "Group1" formula you created should not include references to any database fields. The formula needs to be:

whilereadingrecords;
"";

Notice that the two double quotes on the last line are empty - this is how it needs to be!

If that still doesn't work, please browse to the last page of the report > Go to File > Check Save data with report > Save > Upload the report to a shared drive and post the URL here; I will take a look at it.

-Abhilash

[former_member197302]

It did not work. Here is the link

https://1drv.ms/u/s!AgY7TyJRAtZMgy5SeIj_300TAHtz

[abhilash_kumar]

Hi Naman,

1) Inside the Subreport, create a formula (@Fake_grp) with this code:

whilereadingrecords;
"";

2) Insert a Group on this formula and move this group to the top of the Group list.

3) Highlight the @Fake_grp group > Options > Options tab > Check 'Repeat Group Header on each page'.

4) Move all column headers to this new Group Header#1

-Abhilash

[former_member197302]

I created formula call "Group1" in SubReport.

Then added below code in formula Group1

whilereadingrecords; "GroupName ({Command.Document Number})";

Also Report -> Group Expert -> Selected Group -> Option -> Repeat Group Header On Each Page

But still not working

[former_member197302]

But I need to display Column header on each page.. Can u think any other way?

[DellSC]

The trick for this is to create a group on a field that only appears once in the subreport. If you have linked the subreport to the main report, I would use the field that you're linking on. If you're not linking the subreport to a field from the main report, you might be able to create a formula that uses, for example, the PrintDate or DataDate special field and then create a group on that formula to put the header in.

-Dell