Hi All,
Is it possible to add a line number as a field item and use it to format the output of the GI? For e.g., I have a GI that lists 10 rows but I had like to use the line number to change the background color of each alternate row, which is not based on any conditiion. Since, the Row Number is available only for display, how to get a row number for any GI (not a report)?
Manish
+1
In order to reference the SO Line number, you need to reference the table SOLine and look for LineNbr
+3If you’re just trying to get a view of the raw ROW_NUMBER() of a result set, you might be able to make use of the ROW_NUMBER() SQL command, though I’m guessing that could get kind of temperamental.
Also be aware that resorting columns wouldn’t recalculate a ROW_NUMBER() function call.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
