Repeat header's line to the next page

Discussion forum about all things Report Builder (all versions).
soni
India
Posts: 47
Joined: 07 Jul 2020, 13:24
Location: hyderabad, India

Repeat header's line to the next page

Post by soni » 07 Apr 2021, 12:03

how to repeat a line( in the group header ) into the next page(if the list of detail block got break)
please help..by looking at the image requirement will be more clear--------
Screenshot (72).png
You do not have the required permissions to view the files attached to this post.

Igor Ivanovic
Site Admin
Site Admin
Croatia
Posts: 1470
Joined: 05 Mar 2017, 12:37
Location: Zagreb, Croatia

Re: Repeat header's line to the next page

Post by Igor Ivanovic » 07 Apr 2021, 16:53

Not sure if this is the same situation as yours, but please check this post: viewtopic.php?f=38&t=62237#p194057
Igor Ivanovic
Image

soni
India
Posts: 47
Joined: 07 Jul 2020, 13:24
Location: hyderabad, India

Re: Repeat header's line to the next page

Post by soni » 08 Apr 2021, 05:22

Igor Ivanovic wrote:
07 Apr 2021, 16:53
Not sure if this is the same situation as yours, but please check this post: viewtopic.php?f=38&t=62237#p194057
thank you. but i want the extra line to be repeated not the header field...

thomas.uttendorfer
Site Admin
Site Admin
Germany
Posts: 314
Joined: 05 Mar 2017, 17:19
Location: Munich Germany

Re: Repeat header's line to the next page

Post by thomas.uttendorfer » 08 Apr 2021, 10:16

Hi soni,

as far as I understood your question and Igors hint this should work for you.
I think that your line with "SI.No. | Item Code | Item Name | ..." are backgrounds in a group header.
If instead you put it in fields (fill them with fix text formulas), move them from break group header
to the detail block and set the "Behaviours" like Igors hint - then it should work for you.

Regards Thomas
Thomas Uttendorfer
[ frevel & fey ] Software-System GmbH
https://thomasuttendorfer.wordpress.com/

soni
India
Posts: 47
Joined: 07 Jul 2020, 13:24
Location: hyderabad, India

Re: Repeat header's line to the next page

Post by soni » 08 Apr 2021, 12:34

thomas.uttendorfer wrote:
08 Apr 2021, 10:16
Hi soni,

as far as I understood your question and Igors hint this should work for you.
I think that your line with "SI.No. | Item Code | Item Name | ..." are backgrounds in a group header.
If instead you put it in fields (fill them with fix text formulas), move them from break group header
to the detail block and set the "Behaviours" like Igors hint - then it should work for you.

Regards Thomas
thank you.. but this idea can only display the required line in every page. but i need it conditionally( if and only if serial number breaks)

Igor Ivanovic
Site Admin
Site Admin
Croatia
Posts: 1470
Joined: 05 Mar 2017, 12:37
Location: Zagreb, Croatia

Re: Repeat header's line to the next page

Post by Igor Ivanovic » 09 Apr 2021, 07:50

soni wrote:
08 Apr 2021, 12:34
thank you.. but this idea can only display the required line in every page. but i need it conditionally( if and only if serial number breaks)
Well, then play with the Conditional Display and formulas...
You have been pointed to the right direction.
Igor Ivanovic
Image

soni
India
Posts: 47
Joined: 07 Jul 2020, 13:24
Location: hyderabad, India

Re: Repeat header's line to the next page

Post by soni » 10 Apr 2021, 05:17

Igor Ivanovic wrote:
09 Apr 2021, 07:50
soni wrote:
08 Apr 2021, 12:34
thank you.. but this idea can only display the required line in every page. but i need it conditionally( if and only if serial number breaks)
Well, then play with the Conditional Display and formulas...
You have been pointed to the right direction.
am unable to write that condition or formula, I need help on writing that logic

soni
India
Posts: 47
Joined: 07 Jul 2020, 13:24
Location: hyderabad, India

Re: Repeat header's line to the next page

Post by soni » 10 Apr 2021, 08:42

soni wrote:
08 Apr 2021, 12:34
thomas.uttendorfer wrote:
08 Apr 2021, 10:16
Hi soni,

as far as I understood your question and Igors hint this should work for you.
I think that your line with "SI.No. | Item Code | Item Name | ..." are backgrounds in a group header.
If instead you put it in fields (fill them with fix text formulas), move them from break group header
to the detail block and set the "Behaviours" like Igors hint - then it should work for you.

Regards Thomas
thank you.. but this idea can only display the required line in every page. but i need it conditionally( if and only if serial number breaks)
hello thomas,
i tried putting "SI.No. | Item Code | Item Name | ..." into fix text formulas. its working almost fine. but page break is not happening properly.

how can i fix this..
You do not have the required permissions to view the files attached to this post.

thomas.uttendorfer
Site Admin
Site Admin
Germany
Posts: 314
Joined: 05 Mar 2017, 17:19
Location: Munich Germany

Re: Repeat header's line to the next page

Post by thomas.uttendorfer » 11 Apr 2021, 08:43

Hi soni,
it would be helpful if you post the .qrp.
But I think you have to place the line with "SI.no. | Item | ..." above the "normal" Detail-fields.
Regards Thomas
Thomas Uttendorfer
[ frevel & fey ] Software-System GmbH
https://thomasuttendorfer.wordpress.com/

soni
India
Posts: 47
Joined: 07 Jul 2020, 13:24
Location: hyderabad, India

Re: Repeat header's line to the next page

Post by soni » 12 Apr 2021, 05:12

thomas.uttendorfer wrote:
11 Apr 2021, 08:43
Hi soni,
it would be helpful if you post the .qrp.
But I think you have to place the line with "SI.no. | Item | ..." above the "normal" Detail-fields.
Regards Thomas
here is the qrp
NFCSTOCK_ORDER.rar
You do not have the required permissions to view the files attached to this post.

soni
India
Posts: 47
Joined: 07 Jul 2020, 13:24
Location: hyderabad, India

Re: Repeat header's line to the next page

Post by soni » 12 Apr 2021, 05:17

thomas.uttendorfer wrote:
11 Apr 2021, 08:43
Hi soni,
it would be helpful if you post the .qrp.
But I think you have to place the line with "SI.no. | Item | ..." above the "normal" Detail-fields.
Regards Thomas
and here the output if I place the line with "SI.no. | Item | ..." above the "normal" Detail-fields, at page break the header is not visible
NFCSTOCK_ORDER.pdf
You do not have the required permissions to view the files attached to this post.

soni
India
Posts: 47
Joined: 07 Jul 2020, 13:24
Location: hyderabad, India

Re: Repeat header's line to the next page

Post by soni » 12 Apr 2021, 05:18

soni wrote:
12 Apr 2021, 05:17
thomas.uttendorfer wrote:
11 Apr 2021, 08:43
Hi soni,
it would be helpful if you post the .qrp.
But I think you have to place the line with "SI.no. | Item | ..." above the "normal" Detail-fields.
Regards Thomas
and here the output if I place the line with "SI.no. | Item | ..." above the "normal" Detail-fields, at page break the header is not visibleNFCSTOCK_ORDER.pdf
hi thomas,
please check the above 2 posts....

thomas.uttendorfer
Site Admin
Site Admin
Germany
Posts: 314
Joined: 05 Mar 2017, 17:19
Location: Munich Germany

Re: Repeat header's line to the next page

Post by thomas.uttendorfer » 12 Apr 2021, 10:22

Hi soni,

ReportBuilder is a beast..
Maybe it helps if you set "Keep: On Page" in the properties of the Detail Block.

Regards Thomas
Thomas Uttendorfer
[ frevel & fey ] Software-System GmbH
https://thomasuttendorfer.wordpress.com/

soni
India
Posts: 47
Joined: 07 Jul 2020, 13:24
Location: hyderabad, India

Re: Repeat header's line to the next page

Post by soni » 14 Apr 2021, 05:25

thomas.uttendorfer wrote:
12 Apr 2021, 10:22
Hi soni,

ReportBuilder is a beast..
Maybe it helps if you set "Keep: On Page" in the properties of the Detail Block.

Regards Thomas
hi thomas,
i cant see "Keep: On Page" in the properties of the Detail Block, can you please help. my report builder version is 2.1

thomas.uttendorfer
Site Admin
Site Admin
Germany
Posts: 314
Joined: 05 Mar 2017, 17:19
Location: Munich Germany

Re: Repeat header's line to the next page

Post by thomas.uttendorfer » 14 Apr 2021, 07:19

Hi soni,
I have RepBi 1.1.2 and RepBi 7.3.
Here is a screenshot from Version 1.1.2:
keep_on_page.png
Regards Thomas
You do not have the required permissions to view the files attached to this post.
Thomas Uttendorfer
[ frevel & fey ] Software-System GmbH
https://thomasuttendorfer.wordpress.com/

Return to “General Discussion Report Builder”

Who is online

Users browsing this forum: No registered users and 0 guests