I'm new for LN Programming... I have created a basic report by using a single table.... But right now, I need to develop a report by using two table with different types of columns.... So is it possible to create a report by using more than one baan tables... If it is possible one, please let me know how to do that...?

Thanks in advance,
Regards,
Pralash

Pralash,

It doesn't matter how many tables you have. Just add the table field on report layout. If your program script is having the data in those table fields before doing a rprt_send(), the report will show the value. As simple as that.

So, I can do this -

select tcibd001.item, tcibd001.dsca, tdipu001.prip, tisa001.cvat
from tcibd001,tdisa001,tdipu001
where tcibd001._index1 = tdipu001.item
and tcibd001._index1 = tdisa001.item
selectdo
rprt_send()
endselect

So, this is my program script. And my report will have all the 4 fields from 3 different tables.

Hi bhushanchanda,
Thanks so much for your information... But when we create a new report, we assign a single table as a main table of the report... Am I correct or can we assigned more than one tables as a main table for the report?
Please let me know about it...
Thanks in advance,
Regards,
Pralash

Yes, we can assign fields of only one table during new report creation. But, later, when you modify the report, you can just add whichever table fields you want in the report layouts.

Oh I see, Thanks so much Buhshan....
Regards,
Pralash