Hi,
I have a report with 10 to 15 fields.
and logic is:--if first 4 fields are not there in the table ,then report should not be printed.
i have only one index field .
can you suggest me how to do this?
thanks in advance.

Hi,
I have a report with 10 to 15 fields.
and logic is:--if first 4 fields are not there in the table ,then report should not be printed.
i have only one index field .
can you suggest me how to do this?
thanks in advance.

Hello,

can you be more specific ?

Only the detail will not be printed if the 4 fields are empty ?

Based on the datatype of the fields !

detail.x:
before.layout:
if (isspace field.1 and isspace field.2 and isspace field.3 and isspace field.4) then
lattr.print = false
else
lattr.print = true
endif

Regards

Hello..
My Req is:-
If firstfour fields in the report has no data in the table,then the report should not be printed.
it should come "no data found,no report printed" as we get in the stadard session.

My thought for solution:- i think this will happens only when the fileds are the input fields of report session.

Plz clarify my dbt..

Hello..
My Req is:-
If firstfour fields in the report has no data in the table,then the report should not be printed.
it should come "no data found,no report printed" as we get in the stadard session.

My thought for solution:- i think this will happens only when the fileds are the input fields of report session.

Plz clarify my dbt..

Hello,

then do it in sessionscript like :

if isspace field.1 ...... then
else
rprt_send()
endif

Report is only printed whenn the fields are filled.

Regards

Session is a standard one.so i need to write in report script only....
but it is not working in tht...

Hi,,
In report script, i have written like this..

if isspace(fields...) then
message("No data found")
endif.

it works but report is also printing after printing message.

If date is not there,report should not be printed....
more solutions plz...

Thanks in advance...

Not sure about LN, but put the report in debug mode. See if there is a routine you can call to end the report. Not sure but at this point you have the spooler and report open, not sure if you can abort it at that point. Of course you can always find the process numbers and kill them. Not something I like.

My first thought was just add a layout that gets printed - that says no data found.

try following code in Report Script

before.program:
if <condition> then
end()
end if

it works with Baan 4

try following code in Report Script

before.program:
if <condition> then
end()
end if

it works with Baan 4

Does it clean-up the background processes also?

It gives message but report is printng vth 0 values.
i want report not to be printd.
it just stop printing.

suggestion plz...

It gives message but report is printng vth 0 values.
i want report not to be printd.
it just stop printing.

suggestion plz...

Hello,

best way is to do it in sessionscript. If condition, then don't send data to reportwriter.

Before program is executed -- before the program -- .
You say, you don't have sessioncode.
Add a before.report and try to cancel printing there.

before.report:

if >condition< then
end()
endif

Regards

Did u try ending the report in after.receive.data section . Probably that will work .