SQL as a ranking function in Crystal Reports

Question

Is there a way to perform ranking functions in Crystal Reports running on SQL 2000?

http://msdn.microsoft.com/en-us/library/ms189798.aspx

I need to return the row number in table A before joining it to table B in Crystal Reports.

Thanks.

Answer 1

You can embed 'raw' SQL in the SQL Expression field. However, this must be a scalar value. See Crystal Reports: Using SQL Expression Fields .

Answer 2

You can make the current formula of totals or the style of line counting according to the data of the report itself. If you need to distinguish between table A and B data, you can insert a constant into select statements (do you mean join or join?), And then enter the formula in this field.