Newbie Q? Sorting

[ppula]

Is there a way i can sort a report on .rfx
I want to sort my report by name and the same report again by date! My question is is there a way i can sorting on the report side without having to modify my stored procedure ?

thanks for the help
ppula

 

[alvechurchdata]

There are several ways of doing this. When you say you are using a Stored Procedure do you mean that you're calling code within a back end server such as SQL Server or Oracle to generate the data source for the report?

Geoff Franklin

http://www.alvechurchdata.co.uk

 

[ppula]

Yeah on SQL Server, basicly i was wondering if i can sort on the report side. if there is a certain expresion to sort by field?

thanks

 

[Olaf Doschke]

ppula,

a report generally scans through it's data source the way it is sorted. So if you index the cursor or view you got from SQL Server you are able to sort the data on differing fields and then output in that special order.

SELECT ReportCursor
INDEX ON myfield TAG sorting
SET ORDER TO sorting
REPORT FORM ...

Bye, Olaf.