Functionality to determine/change the sort oreder of a query in Webi and CR

[Nisha_Makhijani]

Hi

Does Business Objects Web Intelligence have the functionality to

determine/change the sort order of a query, or does it always push down

the order by into the database and have the database do the sorting? The

background to my question is particularly multi-byte characters (e.g.

Japanese or Chinese characters).

What about the feature in Crystal Reports product?

Regards

Nisha

[Former Member]

The sort order of the query is completely irrelevant to reports, which default to sorting by columns on a left to right basis.

The only reason to sort in a query is where you are restricting the number of rows returned and want the top n rows.

[Former Member]

Hai,

We have an option of running one query at a time or all ,if you would like to have the queries executed in a particalar order then while adding query itself you take that order

[Former Member]

You can define standard ascending and descending sorts or a custom sort for any object in the query. This is defined in the report block properties.