Hi,

we are customizing the std report of Finance.
In this report std report is printing all the data.
Now this data we want to filter based on my report script.

eg:-std report is printing the 10 lines output and my report script sql will give 3 lines output.
so just i want to print the std records which are matching with my report script output.


Please help me to resolve this issue.

Regards
Rajesh

U can add ur filter in before.layout section of detail.
Detail.1:
before.layout:
if condition then
print
else
attr.print = false
endif

U can add ur filter in before.layout section of detail.
Detail.1:
before.layout:
if condition then
print
else
attr.print = false
endif

Hi Sumaya

I have following code in the before.layout of detail section

select tfacr015.leac from tfacr015 where ficu=(select cfcg from tccom112 where itbp=:bpid.f)
selectdo

if tfgld106.leac = tfacr015.leac then
aleac=tfacr015.leac
lattr.print=true
else
aleac=""
lattr.print=false
endif
endselect

But it's not printing the any values for detail .
I have done the debug also in 3 record it's assing the value for aleac .but finaly it's not printing the values.
Regards
Rajesh

Hi Rajesh,
I would like to ensure from you that whether it the whole layout which is not getting printed or it is just a single field which is not printing the value.

1. If it is the whole layout which not printing, then check the expresion which is mentioned in the "Output Expression" for that particular layout. Even if the the value for this expression is evaluated to true, then I think it is somewhere in the report script where the value for the variable "lattr.print" is getting assigned to false.

2. If it is a particular variable which is not printing the value then, check the expression mentioned in "Print Condition" for that particular field. If the value for this expression is evaluated to true, then I think the value for that variable while printing is getting blanked.

I hope it helps.

Regards,
--Rahul

Hi Rajesh,
I would like to ensure from you that whether it the whole layout which is not getting printed or it is just a single field which is not printing the value.

1. If it is the whole layout which not printing, then check the expresion which is mentioned in the "Output Expression" for that particular layout. Even if the the value for this expression is evaluated to true, then I think it is somewhere in the report script where the value for the variable "lattr.print" is getting assigned to false.

2. If it is a particular variable which is not printing the value then, check the expression mentioned in "Print Condition" for that particular field. If the value for this expression is evaluated to true, then I think the value for that variable while printing is getting blanked.

I hope it helps.

Regards,
--Rahul

Hi Rahul,

My whole layout is not printing also in output experssion is having value 1.
Please find the attchment of report script which is used for Report.

Rajesh

Hi Rajesh,

The reason why your layout is not getting printed cause, you are calling layout.again() function in before.layout section ..........

Thanks And Regards
MilindV

Have you tried changing layout.again to lattr.print=false. I think this is what MilindV is saying. I did not study the script to see if that would work.

Hi Mark,

I am able contorle the lattr.print=false in my report for one query.

I have 2 sql queries where i want to contorle the output.

It's not working for second query.

Regards
king1980

You would need to post the script. I mean all you really have to do is control the printing of each layout as it is needed. So basically you turn them on and off with lattr.print based of some condition.