VishalMistry
12th March 2016, 11:55
hi all,

I have a report (supplier balance) in which even if the end of data is reached, the before.layout is printed unnecessarily.

The layout should print only if the data is present below it.

I am attaching report output and layout screenshot for reference. Can anybody guide how this can be avoided.

Regards,
Vishal

Ajesh
14th March 2016, 04:00
Why dont you put "not lattr.enddata" in the before field condition as it is written for the after.field section?

vamsi_gujjula
14th March 2016, 07:49
you can check using lattr.enddata as mentioned in the above post

the other variable you might want to check is lattr.autobefores

VishalMistry
14th March 2016, 10:09
Hi everyone,

I have tried a layout condition (not lattr.enddata) as well as checking at the report script level in before.layout section of after.field. Still there is no result.

Vishal

Ajesh
14th March 2016, 11:00
WHich is the layout that is getting printed? before.field.tccom122.ifbp or after.field.tccom122.ifbp?


Anyways i think it is the before.field.1 that is getting printed. Why dont you try putting the condition lattr.break in it as you have used for before.field.2? It will ensure that that layout will only be printed in case of a sort field change and not during a page break.

Put the combined condition as "lattr.break and not lattr.enddata".

VishalMistry
15th March 2016, 09:45
Hi Ajesh,

I have tried that also, still no luck.

Vishal

Ajesh
16th March 2016, 07:03
DId you Debug the report script? What is the value of lattr.enddata in the case of the unnecessary before.field section?