Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

WSS 3.0

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)

share|improve this question
add comment

1 Answer 1

up vote 1 down vote accepted

I have not done with with Non-SQL databases but I do know that the sorting and filtering options have to be done using a view. I am not very experienced with the DVWP but that is what I have found out through google searches and trial/error.

share|improve this answer
    
I would give you an upvote but I don't have the rep. Indeed, creating a view solved the problem. Thanks! –  Boden Oct 21 '10 at 19:25
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.