|
-
Mar 7th, 2006, 08:08 PM
#1
Thread Starter
Hyperactive Member
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
#2
Re: Refrech Data Report
 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
#3
Thread Starter
Hyperactive Member
Re: Refrech Data Report
 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
#4
Re: Sort Data Report
Split from 3 year old thread and moved to reporting section.
-
Mar 9th, 2006, 02:27 AM
#5
Thread Starter
Hyperactive Member
Re: Refrech Data Report
 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...
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|