Go Back > Blogs > Sarath's blog

User login

Frontpage Sponsor


As a Customer What would do to keep your ERP Implementation intact
Proactively define Business Process-- Take the Project Ownership
Handover everything to System Integrator from drawing BP till implementation of ERP
Hire more inhouse skilled & capable IT Resource to work directly with SI
Rely on SI Architects/Consultants
Total votes: 8

Baanboard at LinkedIn

Reference Content

Skip the Lines in Report
By Sarath at 19 Sep 2018 - 10:33



I Want to skip the lines from the report.

Actaul Report was.

Item Code  Description Section1  Section2 Total

A1 T1  1 2 3

A2  T2  0 0 0

A3 T3 5 5 10 

 Total Value is comming from the report script. 

If the toatl value is 0 then that the record has to skip.


 Item Code  Description  Section1  Section2  Total

A1 T1  1 2 3

A3 T3 5 5 10 

 Here A2 record has skipped .

Please suggest any idea.

Thanks in advance.


Best Regards,

Namburi Sarath Kumar.



No votes yet

by mark_h on September 19, 2018 - 2:41pm
mark_h's picture
If you own the session script I would get the total before the report and skip it that way. If you do not own the script then in the report you have to calculate the total in something like the before.layout event and see if it is 0 - then you can set lattr.print to false.

by Sarath on September 19, 2018 - 3:47pm

Thank you for your valuable reply.
But in layout i taken 22 lines and for suppose second line total value is 0.
for that i want to print remaining 21 lines.
only second line has to skip.
if i kept the lattr.print =false total layout will not print.
so please advise for that.

Thank You,
Sarath Kumar.

by mark_h on September 20, 2018 - 12:17pm
mark_h's picture
If the layout is 22 lines then use the print expression on the variables on the line in question. You could do something like some.value>0.

by Sarath on September 20, 2018 - 1:36pm

Yes i checked that condition at that time the records are showing blank.
i don't want that line in the report.
Pleas advise for that.

Thank You,
Sarath Kumar

by mark_h on September 23, 2018 - 5:15pm
mark_h's picture
The only other thing I can think of is to separate the layout into smaller pieces then you can not print the whole layout rather than getting a blank like in the middle of a larger layout.

by Sarath on September 24, 2018 - 12:23pm

Thanks for the update.
But splitting 22 lines into 22 report layouts is very hard.
is there any option available for skipping the records?

Sarath Kumar.

by mark_h on September 24, 2018 - 12:53pm
mark_h's picture
You can skip the layout, you can skip fields in a layout - but I do not know of a way to make a blank line disappear in a 22 line layout.

All times are GMT +2. The time now is 14:09.

©2001-2020 - -