Baanboard.com

Go Back   Baanboard.com > Blogs > Sarath's blog

User login

Frontpage Sponsor

Main

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

Baanboard at LinkedIn


Reference Content

 
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.

 

 

0
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
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
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
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
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
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
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 06:25.


©2001-2018 - Baanboard.com - Baanforums.com