Sales Order Report Customization Problem

arindam

Hi All,

I have a query regarding Report customization.

The senario is :
1. I created 2 tables Table A and Table B
2. Table A has reference with No. feild of Sales Head table.
3. Table B has reference with 'TabANo.' feild of Table A
4. I want to add 2 feilds from my Table B at Sales Order Report.
5. I have created Table A data item under Sales Head at Report designer and linked Sales Head No. feild with Table A's SalesHeadNo. feild which are identical and reference.
6.Now I it creates 2 section at report designer as Table A and Table B.
7. I add feilds from Table B to the respective section.

My problem is when I am executing Sales Order table, my new created section is not showing. Thus no data is displaying.

Please advice how to solve this issue.

Thanks in advance.
Arindam

arindam

Any help ?

sandy_bsil

Why dont you directly put Table B under the Sales..

Currently:
T 36
T A-->(T A "ANo."=T 36 "No.")
T B..>(T B "TableANo."= T A "ANo.")

Better:
T 36
T B-->(T B "TableANo." = T 36 "No.")

1.Check for data in Table B for a particular Sales Order.
2.Is any grouping done on Sales Order DataItem.
3.Is there any condition written like Currreport.Skip,Currreport.Break on Sales Order DataItem.