I’ve been working a lot with DVWP in recent weeks and have had a few issues which I’ve fixed or how to work around.
Web Connections. Often if there are multiple web part connections on a page you may suddenly get an error when opening a page.
Could not find the connection provider Web Part with ID “g_2f2eb8c3_d516_439f_8e67_ffa57b95212e”.
To avoid this…Or work round it, work on the page without the connections, make a copy of the page, then add in the connections. If further design requirements are needed, work on the page without connections and repeat the process of adding in the connections.
Unable to display this Web Part” on Data Views after restoring site from backup – SharePoint Designer Support Team Blog – Site Home – MSDN Blogs
This is a MS work around
Categorizing a column with the date value.
Need to have the Edit formula something like: string(ddwrt:FormatDate(string(@Review_x0020_Date),1033,1))
To avoid the date looking like: 12/12/2010-TXX23-433-12-12-10
This also works ddwrt:FormatDate(string(@EventDate) ,2057 ,3)
Dealing with UK dates. Click here
ddwrt:FormatDate(string(@EventDate) ,2057 ,3)