SQL like Ranking functions in Crystal Reports

Is there a way to do ranking f开发者_开发百科unctions in Crystal Reports running against a SQL 2000 server?

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

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

Thanks.

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

You can do a running totals-style or row count formula on the data in the report itself. If you need to differentiate between table A and B's data then you can insert a constant into the select statements (do you mean join or union?) and then key on that field in your formula.