0

I have two identical lists containing the following columns:

  • Title (default column)
  • Rate (defined as Currency)
  • Rate2 (defined as Number)

In SPDesigner, under the Data Sources, I've created a Merged linked data source.

I've created a blank page and added a dataview webpart that points to my merged data source. This dvwp has Sort & Filter on Headers enabled. The three columns that are visible are Title, Rate and Rate2.

When I view this page in IE, I do see that all 3 columns have sorting enabled on them. When I sort on either of the Rate(Currency) or Rate2(Number) columns, my data is sorted as if those columns contain text and not numbers.

To see if there was something wrong with the XSLT, I created another dvwp that was connected to just one of the lists. Once again, I enabled sorting and when I view this page in IE, sorting on the Rate and Rate2 columns work as expected.

Any thoughts on where to go from here?

Adrian
  • 5,603
  • 8
  • 53
  • 85
RNaka
  • 1
  • can you show some XSLT _relevant_ code? – Emiliano Poggi Jul 21 '11 at 21:48
  • The thing is, I haven't written any XSLT code. I simply added a DVWP, connected it to my merged list and then viewed that list in IE. At no point did I have to edit the XSLT. I only brought up the part about "something wrong with the XSLT" since my inital assumption was that there must be something wrong in SharePoint's default XSLT for a DVWP. – RNaka Jul 25 '11 at 17:20

0 Answers0