Ryan,
Thank you for your prompt response.
I am encouraged by your answer but I must be missing something as I have already tried what you suggest and I do not get could results.
I am using version 3.0.10 on DNN 6.2
“If it doesn't then please select the Columns that you wish to sort. In Dynamic Views there's the option to select a column to sort by(ASC or DESC) and a Secondary column(ASC or DESC).”
[Scott] in the settings I only see Sort Field and Sorting Order. I do not see any additional way to add or set another column to sort on. Am I on an older version maybe?
With settings CustomSQL, “Allow form Query” not checked I can use a simple SQL like SELECT * FROM Certification. An example of a publicly available page on my site
http://www.himsa.com/Products/NoahM...fault.aspxAs soon as I append my SQL to be “SELECT * FROM Certification Order By Supplier ASC” then the table is populated with no results.
If I change “Allow form Query” to be checked and set the sql to be “SELECT * FROM Certification Order By Supplier ASC” then my table will be populated but it will not be sorted as I have specified. It will be sorted by the row ID from the table.