[Group Header] can't work with SQL [Order by]!

jain

Dear Sir:

I desgin report with SQL [Order by] field,
it will work,
but, if i use [Group Header] with other filed in report,
the [Order by] can't work.

it only work with [Group Header] success,
what's up?

Thank you.

AlexTZ

Hello,

By default, group header sorts the datasource by the group condition, in ascending order. If your datasource is sorted already, you may turn off group sorting (in the group header editor).

jain

The attachments show [我是中文],
it can't set [UP-DOWN middle],
but, if i use others fonts,
it will set middle.

AlexTZ

This is probably a problematic font. We cannot fix anything regarding this issue because we use standard Graphics.DrawString method.

jain

SORRY! I POST IN [[Traditional Han] font make [The upper and lower set of middle] fail].
Thank you!

Bridget

AlexTZ,

What do you mean by this:
"If your datasource is sorted already, you may turn off group sorting (in the group header editor)."

I don't see an option like that in the Group Header setup?

Thank you!

AlexTZ

Hello,

Double click the group header band. Set sort to "Do not sort".

Bridget

Hi,

I don't see an option for "Do not Sort". See attached screenshot.

Do you mean to just set the expression to blank?

Also, is it true that you can not change the order of a dataset's results from within FastReports, if the dataset is external?

Thank you,

AlexTZ

You are using FastReport VCL. Please post your problem here:
http://www.fast-report.com/en/forum/index.php?showforum=13