Method Community

I'm sorting a report detail section by Date. For any records with no Date assigned, how do I make sure they sort to the bottom? Is there a way I can identify and/or group these particular records and make sure they end of at the end of a list?

Thanks

Hi Blake-

I am going to recommend taking a look at the SimpleInvoice report as an example.

The SimpleInvoice template consists of a Master table(Invoice) and a details table(InvoiceLine).

If you click on the Detail1 bar so that it is selected and look at the Group and Sort properties found at the bottom of the page you will see that by default its set to RecordID(This is what it is being sorted by) but in this case if I wanted to change the sort to be by Date I would change it to ServiceDate. An Acsending date field will show all the blank dates at the bottom and a Descending date field will show all the dates at the top.

You can apply this same concept to the report you are working on.

-Michael

Thx. I'll look at grouping and sorting the detail section of my report.

Finally getting around to looking at the detail sorting again.

The detail sections in my report are sorted by Ascending date field, yet the records with an empty date are still showing up first in the list. The remaining records are sorted by date correctly.

Is there some other special trick to sort records by ascending date field but have the fields with empty dates sort at the end of the list?

Also, the same behavior is occurring in on my web forms. Collections are sorted by Ascending date, but the recs with empty dates go to the top. What gives?

Thanks

Blake-

I will look into this further and see what I can come up with.

-Michael