Skip the Lines in Report

		Baanboard.com > Blogs > Sarath's blog
Skip the Lines in Report

User login
Username: * Password: Remember me Create new account Request new password

Frontpage Sponsor

Main
Frontpage Forum Jobs News Stories RSS Newsfeeds Categories ERP Geek Industry & Technology Opinion Security Sources Calendar Contact Polls Shop Web Links

Google search

Poll
How big is your Baan-DB (just Data AND Indexes) 0 - 200 GB 15% 200 - 500 GB 27% 500 - 800 GB 3% 800 - 1200 GB 9% 1200 - 1500 GB 12% 1500 - 2000 GB 12% > 2000 GB 21% Total votes: 33 Older polls

Baanboard at LinkedIn

Reference Content
BaanERP Tutorial Programmer's Manual

Skip the Lines in Report

By Sarath at 19 Sep 2018 - 10:33

Hi,

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.

Output:

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.

Average:

No votes yet

by mark_h on September 19, 2018 - 2:41pm

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

Hi,

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

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

Hi,

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

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

Hi,

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

Thanks,
Sarath Kumar.

by mark_h on September 24, 2018 - 12:53pm

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.

Read full thread
Login or register to post comments

All times are GMT +2. The time now is 06:25.