Sort Data Report

Printable View

Mar 7th, 2006, 08:08 PM
weisi

Sort Data Report

Any idea on whether i can sort the datareport? User can sort either by key in a text or by a combobox(drop down)? Pls advice!

:)
Mar 7th, 2006, 08:27 PM
dee-u

Re: Refrech Data Report

Quote:

Originally Posted by weisi

Any idea on whether i can sort the datareport? User can sort either by key in a text or by a combobox(drop down)? Pls advice!

:)

How about using the ORDER BY Clause in your sql statement?
Mar 8th, 2006, 03:15 AM
weisi

Re: Refrech Data Report

Quote:

Originally Posted by dee-u

How about using the ORDER BY Clause in your sql statement?

Any examples on how I can be able to do that? For examples I have the following fields in my databse and report. "Index","Age" and "Height". And I have created a combobox(drop down) for Index from and another for Index to. So for examples I have 10 records, which means that there will be index 1 - 10. So when the user select from 3 to 8 in the combobox(drop down) and click on "show report", the report will only show Index, Age and Height for Index 3 to 8. Same goes for Age and Height. Please kindly advice...

:)
Mar 8th, 2006, 07:04 AM
Hack

Re: Sort Data Report

Split from 3 year old thread and moved to reporting section.
Mar 9th, 2006, 02:27 AM
weisi

Re: Refrech Data Report

Quote:

Originally Posted by weisi

Any examples on how I can be able to do that? For examples I have the following fields in my databse and report. "Index","Age" and "Height". And I have created a combobox(drop down) for Index from and another for Index to. So for examples I have 10 records, which means that there will be index 1 - 10. So when the user select from 3 to 8 in the combobox(drop down) and click on "show report", the report will only show Index, Age and Height for Index 3 to 8. Same goes for Age and Height. Please kindly advice...

:)

Please Advice... :)