Jump to content
  • 0

Sorting In A Search And Report Database



I have a table which stores price information for each record. When I display results via a search and report datapage, I am currently sorting them based on price - low to high. That part works great and I've no issues with. 


My problem is as follows - the table has some records that have no price information in it. These records are being treated as price $0 and are therefore ranked higher than other records that have valid price data. What I want is for the records with no price information to be sorted lower - i.e. displayed after all the records that have price information in them. Is there a way to do this?


Thanks for your help in advance.



Link to comment
Share on other sites

2 answers to this question

Recommended Posts

  • 0

Thanks for your response Emma! 


Actually filtering the blank records doesnt work because I want the records with $0 to be displayed - just displayed *AFTER* the ones with valid price info in them. 


I figured out another way to do this. I manually updated the records with no price information to have a max price e.g. $1000. This way the sort functionality always sorts them correctly. Thanks for your help.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...