Sorting the order of printing Sales Invoice in RTC

Did you already try to create a key in sales invoice line (if you're talking about report 206) for the fields you need and then sort the dataitem with that key?
(i'm just guessing, anyway)
P.S.: you probably do not want to maintain this key in sql...think about it...

hewajith wrote:

Thank you for your reply
Can't I use Expression in report layout to make these changes

i've no idea on what are you talking about
what is "Expression in report layout"?

Hi,

You could try one of the following in report layout (VS):
1. Change the sorting of the group by right clicking and then select 'Edit Group'. You will see a 'sorting' tab. By default the report sorts by Sales_Line_No. You can change this to 'SalesLineType.Value' and descending (it should then sort by Resources then Item and then G/L Account).

or try
2. Insert 2 more groups below the detail line and copy all the cell values (you will then have 3 groups exactly the same). Use an expression statement (IIF........) for each group to turn off the visibility based on the Line Type (Resources, Items, G/L Account).

I haven't tried the above myself but it is worth a go.

Cheers.