aparnaramsharma
Technical User
Dear all,
1) I need to get the top 5 customers in a WebI report.
I have Customer ID, Sales amount.
I created an object as top 5 sales amount (Edit - Descending sort). When the Display is clicked for the object, it shows the top 5 sales amounts.
The problem in WebI is, it is not recognizing Order by in its SQL query syntax. Is there any way in which I can get this detail.
My back-end is SQLserver 2000.
2) Why is TopCount function not recognized in SQL Server where as Top is recognized. In the help TopCount is given as a valid function. Is there any setup to be done so that SQL server can recognize this function.
Thanks for the help in advance,
Aparna
1) I need to get the top 5 customers in a WebI report.
I have Customer ID, Sales amount.
I created an object as top 5 sales amount (Edit - Descending sort). When the Display is clicked for the object, it shows the top 5 sales amounts.
The problem in WebI is, it is not recognizing Order by in its SQL query syntax. Is there any way in which I can get this detail.
My back-end is SQLserver 2000.
2) Why is TopCount function not recognized in SQL Server where as Top is recognized. In the help TopCount is given as a valid function. Is there any setup to be done so that SQL server can recognize this function.
Thanks for the help in advance,
Aparna