Consolidated Data View (list/display format)
-
I wanted to create a consolidated view of lists from muliple locations. So, I created SOAP Service Connection (in SP Designer). Then I created a Linked Data Source to link multiple lists. I was able to create a Data View and create a consolidated view. Now the problem I have is how some of the fields are being displayed (example: Facility). In the original list it displays just the name (example: ‘Fayette’). However, in the consolidated view it displays “28;#Fayette”. I have this similar issue with three other columns. The only difference is that the other columns displays ‘float;#’ before the numeric value. I believe this may be due to the fact that the ‘Facility’ column is actually a lookup function on the original list (with drop down). And the columns with ‘float;#’ in front of the value are actually calculations. Your help is much appreciated. Thanks, sv
-
I wanted to create a consolidated view of lists from muliple locations. So, I created SOAP Service Connection (in SP Designer). Then I created a Linked Data Source to link multiple lists. I was able to create a Data View and create a consolidated view. Now the problem I have is how some of the fields are being displayed (example: Facility). In the original list it displays just the name (example: ‘Fayette’). However, in the consolidated view it displays “28;#Fayette”. I have this similar issue with three other columns. The only difference is that the other columns displays ‘float;#’ before the numeric value. I believe this may be due to the fact that the ‘Facility’ column is actually a lookup function on the original list (with drop down). And the columns with ‘float;#’ in front of the value are actually calculations. Your help is much appreciated. Thanks, sv
When you have a Lookup field in your list a SPFieldLookup type is used whose default display value is obtained from SPFieldLookupValue and is a concatenation of the ID and Title from the source list. You didn't specify what version of SharePoint you are working with so a specific suggestion can't be given.
No comment
-
When you have a Lookup field in your list a SPFieldLookup type is used whose default display value is obtained from SPFieldLookupValue and is a concatenation of the ID and Title from the source list. You didn't specify what version of SharePoint you are working with so a specific suggestion can't be given.
No comment
I am working with SP Foundation. I was able to solve the issue using the feedback I used. I made the following changes to my code: xsl:value-of select="substring-after(@ows_Facility, ';#')"/ I used the same logic you provided for other columns that had a similar issue. The good part is the ‘2;#’ and ‘float;#’ disappeared from the Data View. Now the one thing I’m still having trouble with is editing the calculation columns. For example I have a ‘Tonnage Capacity’ column, which is a calculation on the initial lists (tonnage capacity = pallet capacity * 1500). In my data view I am able to edit all my normal columns to a number format with 0 decimal places. However, when I format the Tonnage Capacity column to number format the values disappear. Is there a way around this? Thanks for your help.