Sort Order

rbuser

My data source is being sorted by a field that's not displayed in my report.
However, the report is not respecting the sort. I added a group on the field
that I want to sort by but the sort order of the data is still not being
used. How do I get the report sorted the way I want it?

nicocizik

Hi Carl,

ReportBuilder traverses your dataset start to finish as is. Try connecting
your dataset to a DBGrid on your form and see if the data is in fact sorted
the way you expected. If you are using DADE, select the data preview button
and check the same thing.

I'm going to need a little more information about how your report is
designed and what features you are using. Are you using crosstabs? Are you
manipulating any data in event code? How are you setting up your datasets?
What version of ReportBuilder and Delphi are you using?

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com

rbuser

Nico,

The report is very basic. Just a few dbText controls. I added one group in
an attempt to enforce sorting. I'm not using crosstabs and am not
manipulating data in event code. My datasets just have simple SQL: "SELECT *
FROM MYTABLE ORDER BY MY_SORT_FIELD". I'm running D7 and RB 10.06.

Everything seems so basic, that's why I'm puzzled. Any ideas?

Rick

rbuser

I've never seen RB change the sort order--add your sort field to the report
and see what happens.

Edward Dressel
Team DM

nicocizik

Hi Carl,

This is not a known issue. Please create a minimal example of this behavior
using the DBDEMOS database and send it in .zip format to
support@digital-metaphors.com.

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com

rbuser

Hi Nico,

I knew that it wasn't RB, I just couldn't figure out what was wrong. Now I
found it. I was inserting records into a dataset, so the ORDER BY wasn't
being considered until I refreshed.

Thanks,

Carl