Using Sharepoint designer 2007 and WSS 3.0. I've added a SQL view as a dataformwebpart and whenever I try and sort and group by the 2 fields I need, the sorting displays correctly in sharepoint designer but whenever I browse to the site I get the error message
"Unable to display this Web Part. To troubleshoot the problem, open this Web page in a Windows SharePoint Services-compatible HTML editor such as Microsoft Office SharePoint Designer. If the problem persists, contact your Web server administrator"
I thought this might be caused by the data in the fields to be sorted, some were numeric and some were text, so I altered the SQL view so it converted all to varchar but it still won't sort properly. I've had this problem many many times with different
views, sometimes it sorts perfectly, other times I get this annoying message which doesn't help me find the reason. Can anybody please explain why this is happening, or offer a workaround or solution?
Secondly whenever you insert a dataformwebpart from a SQL View it ignores Aliases and just presents the original field title, this is incredibly annoying as I like most other people in the world in my role work with a relational database where most primary
key fields in the major tables are all called No_ or Code, In some cases I can take the field from another table wher
View Complete Post