|
| |
|
|
AllenD
Posts: 258
From: Dayton, OH, USA
Status: offline
 |
Sort DRW results ASC or DESC? - 2/4/2002 16:06:41
I am using this page from Microsoft:
http://office.microsoft.com/assistance/2000/FPDBResult.aspx
On sorting database entries using the DRW, works nicely, but I need the option to sort ASC or DESC. The example above only lets you do it one way or another. Is there a way I can make a hyperlink image with an arrow that goes up or down to allow this? Or can I use a radio button to specify ASC or DESC? Thanks! 
|
|
|
|
whitec00
Posts: 32
From: Dallas Texas USA
Status: offline
|
RE: Sort DRW results ASC or DESC? - 2/4/2002 18:24:22
By all means I am not an expert so take this advice for what it might be worth.
I have a similar report that I wanted to be able to sort differently.
At the top of my DRW table, I inserted a row with the same amount of columns as my DRW.
I then placed form buttons in each column and labeled the buttons according to the label in the DRW. I got rid of the DRW labels and used the buttons as my header labels.
I then copied the original DRW and went in to each one and changed the DRW to sort differently on each column. So I had 2 DRWs for each sort method.
I then went into form properties and pointed each sortable column to the appropriate
DRW so that when the button was clicked, it would run that DRW.
If I wanted to sort by name ascending, it would call one DRW that had that sorting.
If I wanted to go back to Name descending, I would click the button and it would call the name descending DRW.
I am quite positive that this is the hard way to do it, but it was all I could come up with at the time that I needed it. Perhaps my round-about method will inspire someone to set me straight......please......
I try to think, but it hurts....
| |
|
|
|
Spooky
Posts: 26606
Joined: 11/11/1998
From: Middle Earth
Status: offline
|
RE: Sort DRW results ASC or DESC? - 2/4/2002 19:33:10
You may be able to trick the DRW by adding another parameter
eg "order by column ::SortOrder::"
You would need to pass SortOrder in the same quesrystring with a value of asc or desc
§þððk¥
Database / DRW Q & A
VP-ASP Shopping cart
Spooky Login
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
