IanWaterman
Programmer
Sorry if this has appeared more than once, it would not accept this question when I first added to Formulae Forum.
I am using CR 10 on Oracle 8
Within Oracle SQL there is a reserved function called rownum, this returns the database row number.
I need to be able to get at this through Crystal as I need to sort data through about 4 levels and at the very end sort by the Oracle RowNum. Has I want to list data inthe order it was entered. When you sort via crystal you lose the data entry order.
Can this be done?
My only other alternative seems to be building a view of the table and adding Rownum as an additional column, and then adding this to my final sort order in Crystal.
Thank you
Ian
I am using CR 10 on Oracle 8
Within Oracle SQL there is a reserved function called rownum, this returns the database row number.
I need to be able to get at this through Crystal as I need to sort data through about 4 levels and at the very end sort by the Oracle RowNum. Has I want to list data inthe order it was entered. When you sort via crystal you lose the data entry order.
Can this be done?
My only other alternative seems to be building a view of the table and adding Rownum as an additional column, and then adding this to my final sort order in Crystal.
Thank you
Ian