Hi guys,
I'm a new babies here. May I ask some questions?

I already create the new LN program/session to print the data. But I’m stuck when I want to print the data in 1 row.

So,anyone knows how to print data in row in LN report?

I'm really appreciated.

Thank you,
Deknor

Hi,

Can you elaborate more? What data you want to print in 1 line?

In case if you want to print only 1 record, you can use as set with 1 rows

e.g.

select tcibd001.*
from tcibd001
as set with 1 rows
selectdo
endselect

Thank you,

Sorry if i'm make it confuse. I already attach the example of row data which are needed in LN reports.

I already create the coding by using 'as set with 1 rows'. But nothing changes

long x, i
x = 1
DTE = date.f
for i = 1 to 31
select tcccp020.*
from tcccp020
where tcccp020.date inrange {:date.f} and {:date.t}
order by tcccp020._index1
as set with 31 rows
selectdo
dat.date(X) = DTE
X = X + 1
DTE = date.f + i
endselect
endfor
endif

Hi,

If you are new to Development, I will suggest you to go through some basic report developments.

For this, you will need to create 3 arrays -

1. Transaction Date
2. Issue Qty
3. Received Qty

Then, For each transaction date, store the receipt and issue quantities.

Once all the transactions are stored(If you are using Standard Report Designer you will have only 255 characters in single line), you need to add the fields on your layout -

trdt(1,1) trdt(1,2) trdt(1,3)...
issue(1,1) issue(1,2) issue(1,3)...
rcpt(1,1) rcpt(1,2) rcpt(1,3)...

If you want to print Item Wise report, then you will need to create a before.field layout with item. For this, you will need to have the item code input field as pre-sorted.

Search for the threads on the Board with showing how to print arrays in report. You will find many examples.

Thank you Bhushan,

I really appreciated it.

I will try this suggestion to get my result,

Thank you,

Regards,
Deknor