Report order

rbuser

I'm having a problem with a report, I want it to list by job number, but it
seems to be using a different sort. I can arrange the clients records in the
program anyway I want but it does not effect the way they are printing. I
tried making a group with the jobno, but it did not change it. Is there
something I can use in the calc tab to get the correct result.

nicocizik

Hi Chris,

ReportBuilder retrieves data directly from the dataset you have it connected
to. If you need to reorder the records shown on a report, you will need to
reorder the data in your dataset.

--
Regards,

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

rbuser

How would I do that? Your not talking about reordering them on the screen
prior to printing, because I can do that, but it has not effect.

nicocizik

Hi Chris,

Perhaps I'm a bit unclear about what you are trying to accomplish. What
exactly are you trying to order? Are you placing a DBText component inside
the detail band of the report? If so, the only way to order the data that
is displayed in the preview is by altering the underlying SQL code that
accesses the data displayed.

--
Regards,

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