I have a non-SQL database linked to a SQL database. I've created a datasource in SPD using a custom query to this database.
select * from LINKEDDB...sometable
I then created a data view web part from this data source, which seems to work just fine.
However, sorting doesn't seem to work. Nothing happens. When I use the OPENQUERY syntax for the custom SQL statement, sorting breaks the web part.
I have a vague notion of why it's not working. Is there something I can do using parameters in my query to enable sorting? (actually, I would assume that sorting happens via xslt, so I'm not sure at all why it's not working)