Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Rank/Sort Exceeding Limit

I am currently dealing with a report that returns over 66,000 rows for a cross-tab report and I am attempting to narrow it down to the top 50 for the row selection, but due to the rows exceeding a certain value the report will not run properly. From what I've read, it seems like I need to deal with a SQL Expression field, but cannot find anything online about them. The help file is just terrible to help with it. Is it possible to do with a SQL expression field so that we can get the top 100 or so pre-ranked on the server side and then when Crystal Reports goes to process the data it will certainly be under the larger value and produce some results?

replied

Hi Reid,

As you are new user its a little complex for you.

You can take help of samples.

To download samples click [here|https://boc.sdn.sap.com/crsamples]

With above suggestion I would like to add one more thing first of all Test query in your database whatever you are using Oracle, Sql server,u2026, then use that query in command make sure that it gives out accurate output according to your requirement.

Regards,

Shweta

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question