Report Sorting

Lamba

Hi,
I have a report with multiple dataitem's..
On a Purch. Inv Line dataitem's body there is a field whose data is fetched from other table.

The issue is to sort the Purch. Inv Line's data in ascending order but according to that field that is fetched from the other table.

mohana_cse06

Can you explain a bit more with example?

Lamba

Hi,
If there are 4 dataitems as shown in the attached screenshot, there is a field named Test
flowing from other table which is a record variable in the report.

And the data in the Report flows according to different dataitems as shown in the attached screenshot. As marked the challan no is a field flowing from the record variable. And sorting of that particular table is to be done on Challan nos. basis. And the all the fields are of Purch. Inv. Line. So sorting of the complete Purch. Line data is to be done on the Challan Nos Basis.

mohana_cse06

There is no Challan nos. field in Purchase Line table
Is there any relation between Purhcase Line or Purch. Inv Line with the table which has Challan nos. field in it?

May be yes and you are getting Challan nos. based on that link..

If yes, why cant you take that table as a dataitem and get Purch. Inv. Line information based on the Challan nos. sorting?