US 1.877.212326.2662
Browse Search
RELNOTE: Data-Viewer Web Part for SharePoint 2010 Release Notes (HW37)
Created on: 25-Jun-10. Print Article
Last Modified on: 06-Apr-17. Email Article
Article has been viewed: 17570 times.
Rated: 6 out of 10 based on 3 votes.
KB.12490

APPLIES TO:

  • SharePoint Foundation 2010 and SharePoint Server 2010

To find out which product version you have, read KB.11999: How to Find the File Version for a Bamboo Product.

Below are the lists of features and issues for each release of this product.

Release Notes
R3.7.95.0
04/05/2017
 

New Features

Resolved Customer-Reported Bugs:

·         Bamboo Data Viewer web will now fit to web part zone on a page

R3.7.93
10/18/2016

Resolved Customer-Reported Bugs and Known Issues/Limitations:

  • Resizing the browser window does not dynamically resize the web part display.

See the Known Issues and Limitations section for the latest known issues and limitations related to this release.

R3.7.90
08/12/2016

Resolved Customer-Reported Bugs and Known Issues/Limitations:

  • Clicking 'Site Actions' in non-English team sites with Data-Viewer Web Part causes an error.

See the Known Issues and Limitations section for the latest known issues and limitations related to this release.

R3.7.89
07/07/2016

Resolved Customer-Reported Bugs and Known Issues/Limitations:

  • The Data-Viewer web part displays an error when connected to a List Rollup data source using SharePoint Aggregation Services with recurrence defined.

See the Known Issues and Limitations section for the latest known issues and limitations related to this release.

R3.7.79
05/05/2016

Resolved Customer-Reported Bugs and Known Issues/Limitations:

  • Calculated column formulas created using HTML are not displayed correctly in the Data Viewer grid.
  • The total sum of percentage fields is not displayed in a percent format.
  • The calculated totals of nested data are not displayed correctly when you expand to a second item.

See the Known Issues and Limitations section for the latest known issues and limitations related to this release.

R3.7.53
09/11/2015

Resolved Customer-Reported Bugs and Known Issues/Limitations:

  • Unable to configure web part when accessing the site via UAG.
  • Internal bug fixes regarding SQL data source, UAG environment, Chrome browser and to support List Rollup R7.0.

See the Known Issues and Limitations section for the latest known issues and limitations related to this release.

R3.7.37
07/01/2015

Resolved Customer-Reported Bugs and Known Issues/Limitations:

  • Could not conditionally format on a Person or Group column.
  • No option to reset multiple dynamic filters with one click.
  • A Data View Web part displaying List Rollup data could not sort by People or Group columns.
  • Column alias did not apply to group heading.
  • No support to hide the header row.
  • When using SQL as the data source a column could not be resized if the column title contained multiple words.
  • Web Part did not support 'blank' runtime filter on the page until a filter criteria is selected.
  • The Web Part showed an error when filtering Date Time column with " [Today] - x".
  • When configured to use a SharePoint list data source with the " Show all items without folders" option checked, users would receive an error when editing in datasheet mode.
  • tags were displayed in inline edit mode of Data Viewer on Project Management Central sites.
  • After adding a new column to a list or rollup the new column was not automatically available in "Column Display Settings".
  • A scrollbar appeared when Nested List data was displayed when the "Set Custom Column Width" option is checked even if the number of columns in Nested List was smaller than the number of columns displayed in the Parent List.
  • Conditional Formatting for text fields of the Master/Nested List is reset after Column Display Settings pop up screen is displayed following the initial configuration.
  • Support calculations on numeric columns for nested list items.
  • When "Use list or library view" is the filter for a SharePoint list or library, users can switch between list views at runtime.
  • Added option "Edit default fields" in General Settings to always include default display fields in the inline and datasheet edit modes.
  • After configuring the Web Part, if the user access the Column Display Settings pop up screen, the nested list, calculated, and conditional formatting options had to be reset.
  • Resizing columns in runtime mode for Nested Grid View caused display issues.
  • Multiple Lines of Text column types, Rich Text and Enhanced Rich Text, displayed HTML tags.

See the Known Issues and Limitations section for the latest known issues and limitations related to this release.

R3.6.84
12/01/2014

Resolved Customer-Reported Bugs and Known Issues/Limitations:

  • When paging is enabled in the Data Viewer web part, items on some page are not linked to the correct source list.
  • Filtering a single managed metadata column using the "Contains" operator results in an error when the Web Part's data source is List Rollup Schema.

See the Known Issues and Limitations section for the latest known issues and limitations related to this release.

R3.6.81
04/22/2014

Resolved Customer-Reported Bugs and Known Issues/Limitations:

  • For countries that have Day Light Saving time in March- 2014,  the time is displayed on Web Part earlier than the time on in the list by one hour.
  • Web part displays error message "Item Command: : Invalid operator for this type of column" when using the "Contains" operator to filter a text column, and the Data-Viewer is configured to use SQL as the data source.
  • OR operator does not working when the data source is  a SharePoint list.

See the Known Issues and Limitations section for the latest known issues and limitations related to this release.

R3.6.72
12/19/2013

Resolved Customer-Reported Bugs and Known Issues/Limitations:

  • Shows the error related to dispose check of Data-Viewer is on Project Management Central (version 4.1)'s portfolio site home page if the Developer Dashboard is turned on.
  • Shows error: "OnLoad: : The specified view is invalid.", while in the Edit Datasheet mode and perform some actions such as adding a task on My Summary or on My Tasks Due this Week or My Overdue Tasks within Project Management Central.
  • Shows error: "dgrResult_PreRender:: : Column ' ' does not exist....",  when grouping using the Date column and the Date column is a calculated data type column, e.g. grouping by the MONTH column where the MONTH column is a Date column with the calculated data type with formula as =TEXT(Date,"yyyy - ")&TEXT(Date,"mm")&TEXT(Date,"(mmmm")&TEXT(date,"yyy)").
  • When the data source is from List Rollup Schema, Data-Viewer is showing the Site Name instead of the List Name.
  • Anonymous users are prompted for a user name and password to access some PM Central pages (including the home page) if the page includes data that contains the rollup by List Rollup schemas with People and Group column.

See the Known Issues and Limitations section for the latest known issues and limitations related to this release.

R3.6.66
09/20/2013

New Features:

  • Allow adding new nested list items directly from the Data-Viewer Web Part.
  • Allow for the display of all items without folders or showing items inside folders.
  • Allow set formatting for the column headers.
  • Allow for printing of data.
  • Allow Inherit Site Theme for skin and font style.

Resolved Customer-Reported Bugs and Known Issues/Limitations:

  • When the data source is List Rollup schema, using condition format with column type Hyperlink or Picture and Multiple Lines of Text. 
  • Data-Viewer web part configuration such as using nested is lost when migrating from Sharepoint 2007 to Sharepoint 2010 or from one farm to another farm.
  • Allow the header justification to be configured as align right or align left.
  • When List Rollup Data View (Classic Edition) is used as the data source, Data-Viewer Web Part shows message "Error: OnLoad: : Field AssignedTo_BBCustomInvisibleC not found in the source table. Please check the expression syntax." when dragging Assigned To column to the top for grouping.
  • "Subject-Linked to Item" column displays "No title" when migrating from SharePoint 2007 to SharePoint 2010.
  • Allow set formatting for the column headers as bold.
  • When List Rollup Data View (Classic Edition) is used as the data source and using the Date field for sorting or grouping, Data-Viewer sorts or groups as text string instead of date, e.g. 10/5/2013, then 2/5/2013, and then 3/5/2012.
  • Allow adding new nested list items directly from the Data-Viewer Web Part in the Nested/child section.
  • Column set for grouping is using only the columns included in the display.
  • The following have been fixed and are no longer limitations:

Data Source: All

  • Feature: Calculated Settings
    • If the column that is being Calculated on is also used for grouping the data, the resulting Calculated value is shown as the last item in the grouping instead of bottom of Grid View.
  • Feature: Export to Excel
    • Master and Nested Data sets are exported in separate Excel files.
  • Feature: Grouping (Dynamic)
    • Dynamic Grouping only occurs on the current page in the grid and does not group the full data set. (When use List Rollup Schema)
  • Feature: General configuration of Web Part
    • In certain cases, if configuring the Web Part for the first time, the option "Allow Columns to be resized" checkbox found in General Settings is not saved first time selected.

Data Source: Bamboo List Rollup Web Part

  • Feature: Export to Excel

    • The following column types are not formatted correctly:
      • Calculate
      • List Rollup special columns: List Name and Site Name return blank values
  • Feature: Filtering (Default)
    • The following column types are not supported:
      • Calculate (When use List Rollup Schema)
      • Choice (Multiple Selection mode) (When use List Rollup Schema and with the operator "contains")
      • Date & Time (When use List Rollup Schema)
      • Hyperlink or Picture (When use List Rollup Schema)
      • Number (When use List Rollup Schema)
      • Yes/No (When use List Rollup Schema)
      • List Rollup special columns: List Name and Site (When use List Rollup Schema)
  • Feature: Filtering (Dynamic)
    • The following column types are not supported:
      • Calculate (When use List Rollup Schema)
      • Choice (Multiple Selection mode)(When use List Rollup Schema and with the operator "contains") 
      • Date & Time (When use List Rollup Schema)
      • Hyperlink or Picture (When use List Rollup Schema)
      • Number (When use List Rollup Schema)
      • Yes/No (When use List Rollup Schema)
      • List Rollup special columns: List Name and Site Name 1294 (When use List Rollup Schema)
    • Using the [Me] SharePoint variable is only supported with the operators Contains and Equals.
  • Feature: Sorting (Defaut) 
    • Date & Time columns are sorted as text instead of numbers (When use List Rollup Schema).
  • Feature: Sorting (Dynamic)
    • Date & Time columns are sorted as text instead of numbers (When use List Rollup Schema).
    • Person or Group columns are not sorted correctly due to the data includes the profile ID (When use List Rollup Schema).

Data Source: SharePoint List or Library

  • Feature: Export to Excel
    • The following column types are not formatted correctly:
      • Calculate

Data Source: Business Connectivity Services (BCS)

  • Feature: Filtering
    • Certain filter criteria returns no results even though items do match the criteria.

See the Known Issues and Limitations section for the latest known issues and limitations related to this release.

R3.5.67
04/12/2013

Resolved Customer-Reported Bugs and Known Issues/Limitations:

  • When the Web Part page contains 3 columns for Web Parts and the Web Parts are added to the columns on the left and Data-Viewer Web Part is added on the right, the display is stretched to over 1000 pixels.
  • Shows error when download document file from the Web Part interface.
  • Cannot update or edit in datasheet mode when document list is used with Data-Viewer Web Part.

See the Known Issues and Limitations section for the latest known issues and limitations related to this release.

R3.5.64
12/21/2012

New Features:

  • Expanded control over the columns displayed in Standard and Datasheet views.
    • Improved selection of columns to be displayed and the order of the columns.
    • Ability to specify default columns widths.
    • Ability to define a column alias to be displayed instead of original column display name.
  • Allow end users to resize columns by dragging the column header borders left and right during their page session.
  • Allow end users to add and remove columns in run-time during their page session.
  • Scroll within content while freezing column header, Web Part header and Web Part footer.
  • Support for using Windows Authentication to connect to remote SQL Server Table data.
  • Provide the in progress image when users sort/filter/group data in runtime mode.
  • Added support for External list content types.
  • Support the following special columns when connected to List Rollup Web Part data
    • Sorting:
      Hyperlink (Picture and URL)
    • Grouping:
      Person or Group (Single Selection and Multiple Selection)
      Lookup (Single Selection and Multiple Selection)
      Hyperlink (Picture and URL)
      Calculated
    • Filtering:
      Person or Group (Single Selection only)
      Lookup (Single Selection only)

Resolved Customer-Reported Bugs and Known Issues/Limitations:

  • SQL Table or View as Datasource - Exporting to Excel - Column data type is Money, empty value is returned in Excel.
  • Nested data does not display correctly when a Web Part Connection is established for filtering the master list.
  • Nested data returns an error if runtime filter is cleared on subsequent page results.
  • List Rollup Web Part as Datasource - Grouping - Incorrect results when grouping on columns of type People and Group.

See the Known Issues and Limitations section for the latest known issues and limitations related to this release.

R3.4.66
06/17/2012

New Features:

  • Added support for Bamboo Aggregation Service in List Rollup Web Part, Release 6.0

Resolved Customer-Reported Bugs and Known Issues/Limitations:

  • The error message "Invalid usage of aggregate function SUM() and Type:String" occurs when summing the values in a Calculated column.

See the Known Issues and Limitations section for the latest known issues and limitations related to this release.

R3.4.52
04/30/2012

New Features:

  • Improved Web Part configuration experience with a pop-up settings window.
  • Allows selection of up to two columns when configuring default grouping and sorting options.
  • Option to display all required columns in the inline edit form, even if those columns are not displayed in the grid view.
  • Allows parent data in Data-Viewer Web Part to be filtered by a secondary Web Part using SharePoint Web Part Connections.
  • Allows filtering, sorting, and limits on the number of items displayed to be configured for nested data.
  • Enhances conditional formatting rules to allow background shading to affect the text, the cell, or the entire row.
  • When connecting to a SharePoint list or library, selecting a list view is no longer required unless you want to configure item filtering based on list view settings.
  • Improved interface for configuring conditional formatting and calculation rules.
  • Ability to display calculation results at both the top and bottom of the item list.

Resolved Customer-Reported Bugs and Known Issues/Limitations:

  • User receives the error "Default or Null are not allowed as explicit identity values" when attempting to add a new item to Data-Viewer Web Part with SQL Table or View configured as the Data Source.
  • When exporting data of multiline of text column to the excel, Web Part add more <div> tag.
  • If an instance of Data-Viewer Web Part resides on the same page as SharePoint List View Web Part that is displaying Calendar view of a list, users are unable to navigate to next month or past month in List View Web Part.
  • When Data-Viewer Web Part data source is List Rollup - Classic Edition, and a column of Single Line of Text is configured with a default value, Data-Viewer Web Part returns the error message "OnLoad: : System.ArgumentException: Input array is longer than the number of columns in this table..."
  • When exporting to Excel, columns of type Date & Time, Calculated (Number), Number and Person and Group are formatted incorrectly.
  • Sorting on columns of type Number are treated as text (string), not numerical value.
  • When exporting the nested data, only the data from the expanded parent item is exported, not the complete nested data set.

See the Known Issues and Limitations section for the latest known issues and limitations related to this release.

R3.3.67
01/04/2012

Resolved Customer-Reported Bugs and Known Issues/Limitations:

See the Known Issues and Limitations section for the latest known issues and limitations related to this release.

R3.3.63
10/28/2011

New Features:

  • Data Viewer Web Part now uses Web License Manager Version 2.0.10.0.

Resolved Customer-Reported Bugs and Known Issues/Limitations:

  • When clicking on the "NoFilter" option and not entering parameters to the search field, the Web Part does not function.
  • Added support for SA12 Project Management Central.

See the Known Issues and Limitations section for the latest known issues and limitations related to this release.

R3.3.50
09/26/2011

Resolved Customer-Reported Bugs and Known Issues/Limitations:

  • Managed metadata columns do not display in Inline Editing mode.
  • Datasheet View does not display managed metadata columns correctly.
  • Spreadsheets created using Excel Export include column index and delimeters for managed metadata columns.
  • The Name field does not display properly when using a Bamboo List Rollup data source.
  • Displays an error message when attempting to filter date or time columns using the SharePoint variable [Today]: "OnLoad: : String was not recognized as a valid DateTime."

See the Known Issues and Limitations section for the latest known issues and limitations related to this release.

R3.3.28
08/10/2011

New Features:

  • Allow users to change the name of the list configured in Data-Viewer Web Part while not interrupting the functionality of the Web Part.

See the Known Issues and Limitations section for the latest known issues and limitations related to this release.

R3.3.26
06/22/2011

New Features:

  • Allow users to export data to Excel, preserving data formatting for columns of type Date and Time, Choice and Lookup by enabling the option Export Data in Excel with Data Formatting.
  • Provide sample manual installation scripts in misc folder of the installation Package.

Resolved Customer-Reported Bugs and Known Issues/Limitations:

  • Remove limitation of 40 conditional format criteria. The upper limit now is 100 until next release.
  • Exporting to Excel, Date and Time fields - even if set to Date Only - will result in this format: 2011-05-06T00:00:00-04:00. Provided option in the tool part to allow users to choose to format the data before export. The columns that will be affected are Number, Currency, DateTime, Lookup, calculated, user, computed and hyperlink.
  • When exporting grid view items to Excel, the Latin-1 characters does not render correctly.

See the Known Issues and Limitations section for the latest known issues and limitations related to this release.

R3.3.14
05/26/2011
New Features:
  • Added support for "Edit in Datasheet" mode for List Rollup and SQL Server data sources.
  • Runtime data filtering can now be performed on multiple columns at the same time.
  • Added the option to export all items in a nested data source to Microsoft Excel.
Resolved Customer-Reported Bugs and Known Issues/Limitations:
  • Connected to SQL Server Table or View: An error message is displayed when exporting data to Excel.
  • Cannot localize the Web Part language setting.

See the Known Issues and Limitations section for the latest known issues and limitations related to this release.

R3.2.29
03/11/2011
New Features:
  • Allow users to edit items in Datasheet mode. To turn this feature on, select Allow Edit in Data Sheet in the section Dynamic Settings of the Web Part Tool Pane.
  • Installation Package now contains a new Setup interface.
Resolved Customer-Reported Bugs and Known Issues/Limitations:
  • In the SharePoint Log File, the user will see the error: Detected use of SPRequest for previously closed SPWeb object.
  • Connected to a SQL 2005 Table or View: Conditional Format fails for columns of type Date.

See the Known Issues and Limitations section for the latest known issues and limitations related to this release.

R3.1.65
12/6/2010

New Features:

  • Provide Support for List Rollup 5.0
  • Use Web License Manager 1.3.9

Resolved Customer-Reported Bugs and Known Issues/Limitations:

  • Internal Bug fixes to support for PM Central SA12 R.20 and List Rollup HW24 R5.0

See the Known Issues and Limitations section for the latest known issues and limitations related to this release.

R3.1.44
07/29/2010

Resolved Customer-Reported Bugs and Known Issues/Limitations:

  • Fixed dispose and Cross-Site Scripting check.

See the Known Issues and Limitations section for the latest known issues and limitations related to this release.

R3.1.32 6/25/2010

Initial Release on Microsoft Windows SharePoint Foundation 2010 and Microsoft Office SharePoint Server 2010
This build is for an environment on SharePoint Foundation 2010 and SharePoint Server 2010 that does not already have Bamboo products installed. Currently we do not support in-place upgrades.

See the Known Issues and Limitations section for the latest known issues and limitations related to this release.

Known Issues & Limitations
R3.7.37 View our Known Issues and Limitations for SharePoint 2010 for more information.
R3.6.84

Limitations:

  • When using List Rollup as the data source, filtering Managed Metadata is only supported for the "Contains' operator with a single metadata type column.

R3.6.66

Known Issues:

  • "Calculating Header" and "Calculating Footer" show wrong position when dynamic sorting in a group.
  • Calculating result shows wrong position for "Both" selection of Position when dynamic grouping.
  • Can not support filtering data for Additional fields type of Lookup column type in Rollup data source.
  • Once edited data of the column, it is not applied if selecting "Yes" for "on Grouping" and format color of any column.
  • The configuration of Nested list in Conditional Formatting section is not applied when changing column display setting.
  • The ID column sorts incorrectly in Rollup connection.
  • Grouping result always shows on the right of gridview when selecting "Yes" for "On Grouping" in "Calculations" section.
  • All of types without text type are not supported sorting when grouping in SharePoint, SQl, Rollup Classic data source. All of  type without text, number, Datetime type are not supported when grouping in Rollup Schemas data source.
  • Do not get automatically the value for Mapping column when adding new item for Nested list in Sharepoint datasource.
  • Connected to any source with Nested Data: Expanding and collapsing a Nested Data set causes an extra line to appear when using skin Web20.
  • After initially configuring the Web Part to use Asynchronous Mode, must navigate away from the page for the data to show for the first time.

Limitations:

  • Do not support all item in folder in Rollup data source
  •  "Count, Sum, Average, Maximum, or Minimum" is not correct when nested is used since it sums up the counts from multiple sub groups instead of it's own sub group, e.g.
  • Project 1 has 1 budget and the count is 1; Project 2 has 1 budget and the count should be 1, but the count is shown as 2 since it also counts the budget from Project 1.
  • Content Type field does not support sorting or grouping. It cannot be used in the Web Part settings for grouping or sorting.
  • When SQL is selected as the data source, and in the Web Part settings if "Define Item Grouping" is set to use the Column_NText or Text and for the Calculation section in tool pane is set to  "Yes " for "on Grouping" field, the Web Part shows an error message.
  • When SQL is selected as the data source,and for the Calculation section in toolpane is set to  "Yes " for "on Grouping" field, the Value of that column is not shown after dragging the column for grouping from the Web Part interface.
  • Showing wrong calculated data after changing Locale when summarizing data using calculations
  • Calculate group is not supported by dynamic grouping
  • Date field in a group is sorted as text string instead of date on Rollup Classic data source.
  • When grouping using the Content Type for the document library, the grouping is now display in a continous order due to the limitation of the Content Type in SharePoint 2010. For example, it showing Documents group, then Folders group, and Documents group again. See Microsoft Discussion for more information.
  • Data Source: All
    • Feature: Datasheet Mode
      • Editing a Person or Group column that allows multiple selections will replace the current list of values stored in the column.
      • Choice fields that allow multiple selections do not include a "Select All" choice.
      • Reordering columns with drag and drop not supported in Datasheet mode.
    • Feature: Grouping (Dynamic)
      • Dynamic Grouping only occurs on the current page in the grid and does not group the full data set. (Except when use List Rollup Schema)
      • Loading icon does not display if using Internet Explorer 8.
    • Feature: Sorting (Default)
      • Default sorting is not honored if default grouping is enabled.
    • Feature: Filtering (Dynamic)
      • Loading icon does not display if using Internet Explorer 8.
    • Feature: Sorting (Dynamic)
      • Loading icon does not display if using Internet Explorer 8.
    • Feature: Language Resource Strings
      • No resources string available to modify the text "None" in the Calculated Settings section of the tool pane.
      • No resource strings available to modify the runtime filter conditions.
    • Feature: General configuration of Web Part
      • After configuring the Web Part, if the user modifies the columns displayed for the Master List, the nested list, calculated, and conditional formatting options will be reset..
    • Feature: Resize Columns in Runtime Mode
      • Resizing columns in runtime mode for Nested Grid View causes display issues.
    • Feature: Selection of Columns in Runtime
      • If the grid view has few records, the drop down menu for selection of columns in runtime will be cut off.
  • Data Source: Bamboo List Rollup Web Part
    • Feature: Conditional Formatting
      • Columns of type Hyperlink or Picture and Multiple Lines of Text are not supported.
    • Feature: Datasheet Mode
      • Does not support modification of columns of type External Data Type.
      • Does not support modification of columns of type Multiple Lines of Text (Enhanced rich text).
      • Does not support modification of columns of type Recurrence and Workspace.
    • Feature: Filtering (Default)
      • Filtering lists of type Calendar on either Start Date or End Date will not return items with “All-Day Events” enabled.
      • The following column types are not supported:
        • Choice (Multiple Selection mode) (Except when use List Rollup Schema and with the operator "contains")
        • Date & Time (When use List Rollup Classic)
        • Hyperlink or Picture (When use List Rollup Classic)
        • Lookup (Multiple Selection mode)
        • Number (When use List Rollup Classic)
        • Person or Group (Multiple Selection mode)
        • Yes/No (When use List Rollup Classic)
        • List Rollup special columns: List Name and Site Name (When use List Rollup Classic)
    • Feature: Filtering (Dynamic)
      • The following column types are not supported:
        • Calculate (When use List Rollup Classic)
        • Choice (Multiple Selection mode) (Except when use List Rollup Schema and with the operator "contains")
        • Date & Time (When use List Rollup Classic)
        • Hyperlink or Picture (When use List Rollup Classic)
        • Lookup (Multiple Selection mode)
        • Number (When use List Rollup Classic)
        • Person or Group (Multiple Selection mode)
        • Yes/No (When use List Rollup Classic)
        • List Rollup special columns: List Name and Site Name 1294 (When use List Rollup Classic)
      • Using the [Me] SharePoint variable is only supported with the operators Contains and Equals.
    • Feature: General Data Display
      • If user modifies their local in the "My Regional Settings" page, columns of type Currency and Calculated (output = Currency), the comma "," and decimal point "." are displayed in the wrong position.
    • Feature: Inline Edit Mode
      • Does not support modification of columns of type External Data Type.
      • Does not support modification of columns of type Recurrence and Workspace.
      • Columns of type Multiple Lines of Text - Rich Text and Enhanced Rich Text modes display HTML tags. Alternatively use the Content Editor provided in Datasheet mode.
    • Feature: Nested Data
      • Association between Parent Data and Nested Data is not supported if mapped columns contain multiple value (People and Group, Lookup and Choice).
      • Cannot link Nested Data set based on Lookup column in Master List.
    • Feature: Sorting (Default)
      • Date & Time columns are sorted as text instead of numbers. (When use List Rollup Classic)
      • Person or Group columns are not sorted correctly due to the data includes the profile ID.
    • Feature: Sorting (Dynamic)
      • Date & Time columns are sorted as text instead of numbers. (When use List Rollup Classic)
      • Person or Group columns are not sorted correctly due to the data includes the profile ID. (When use List Rollup Classic)
  • Data Source: SharePoint List or Library
    • Feature: Conditional Formatting
      • Columns of type Hyperlink or Picture and Multiple Lines of Text are not supported.
    • Feature: Datasheet Mode
      • Does not support modification of columns of type External Data Type.
      • Does not support modification of columns of type Multiple Lines of Text (Enhanced rich text).
      • If the source is External List, Datasheet mode is not supported.
      • If modifying a column of type Multiple Lines of Text that contains text surrounded by tag characters (i.e.. <...>), the text will clear upon saving.
      • If modifying a column of type Multiple Lines of Text that contains hyperlinks, the hyperlinks are lost upon saving the changes.
      • When users are modifying a cell of the following Column Types, the users will see the raw data instead of the formatted data. Upon navigating away from the cell, the format will be displayed correctly.
        • Choice (Checkboxes)
        • Lookup (Both Single and Multiple Selection modes)
        • Multiple Lines of Text (Rich Text and Enhanced Rich Text Modes)
        • Person or Group (Single or Multiple Selection modes)
      • Viewing or modifying columns of type Hyperlink or Picture displays only the Description text. User is not able to modify the URL.
      • Viewing or modifying columns of type Multiple Lines of Text (Plain Text mode) removes line breaks. If user modifies the column and saves changes, line breaks are removed from original column text.
      • Columns of type Business Data are not supported. Data-Viewer Web Part hides these columns automatically from view in Datasheet Mode.
      • All Bamboo Custom Columns are not supported.
      • Does not support modification of columns of type Recurrence and Workspace.
    • Feature: Export to Excel
      • Column display names with special characters are formatted incorrectly in the resulting Excel column headers.
    • Feature: Filtering (Default)
      • Columns with multiple values are not supported.
    • Feature: Filtering (Dynamic)
      • If the backslash "\" is included in the filter string, it will be removed automatically.
      • If Filtering on Person or Group column, Bamboo recommends using the Contains operator and enter the User Name in the value instead of First or Last Name.
      • Columns with multiple values are not supported.
    • Feature: General Data Display
      • If user modifies their local in the "My Regional Settings" page, columns of type Currency and Calculated (output = Currency), the comma "," and decimal point "." are displayed in the wrong position.
    • Feature: Inline Edit Mode
      • Does not support modification of columns of type External Data Type.
      • If source is an External List, Inline Edit Mode is not supported.
      • Columns of type Business Data are not supported. Data-Viewer Web Part hides these columns automatically from view in Datasheet Mode.
      • Columns of type Multiple Lines of Text with Append Data feature enabled, only the current version text is displayed.
      • Columns of type Multiple Lines of Text - Rich Text and Enhanced Rich Text modes display HTML tags. Alternatively use the Content Editor provided in Datasheet mode.
      • Does not support modification of columns of type Recurrence and Workspace.
      • Columns of type Lookup with Multiple Selections are not supported.
      • No support for the following Bamboo Custom Columns:
        • Bamboo Column Level Security
        • Bamboo Lookup Selector
        • Bamboo Rating
        • Bamboo Rich Text
        • Bamboo Validator
    • Feature: Nested Data
      • Association between Parent Data and Nested Data is not supported if mapped columns contain multiple value (People and Group, Lookup and Choice).
  • Data Source: SQL Server Table/View
    • Feature: Datasheet Mode
      • Not Supported
R3.5

Known Issues:

  • Connected to any source with Nested Data: Expanding and collapsing a Nested Data set causes an extra line to appear when using skin Web20.
  • Connected to SQL Table or View with Default Group By or Dynamic Grouping: If the SQL column contains a special character, the Web Part returns an error message.
  • After initially configuring the Web Part to use Asynchronous Mode, must navigate away from the page for the data to show for the first time.

Limitations:

  • Data Source: All
    • Feature: Calculated Settings
      • If the column that is being Calculated on is also used for grouping the data, the resulting Calculated value is shown as the last item in the grouping instead of bottom of Grid View.
    • Feature: Datasheet Mode
      • Editing a Person or Group column that allows multiple selections will replace the current list of values stored in the column.
      • Choice fields that allow multiple selections do not include a "Select All" choice.
      • Reordering columns with drag and drop not supported in Datasheet mode.
    • Feature: Export to Excel
      • Master and Nested Data sets are exported in separate Excel files.
    • Feature: Grouping (Dynamic)
      • Dynamic Grouping only occurs on the current page in the grid and does not group the full data set.
      • Loading icon does not display if using Internet Explorer 8.
    • Feature: Sorting (Default)
      • Default sorting is not honored if default grouping is enabled.
    • Feature: Filtering (Dynamic)
      • Loading icon does not display if using Internet Explorer 8.
    • Feature: Sorting (Dynamic)
      • Loading icon does not display if using Internet Explorer 8.
    • Feature: Language Resource Strings
      • No resources string available to modify the text "None" in the Calculated Settings section of the tool pane.
      • No resource strings available to modify the runtime filter conditions.
    • Feature: General configuration of Web Part
      • In certain cases, if configuring the Web Part for the first time, the option "Allow Columns to be resized" checkbox found in General Settings is not saved first time selected.
      • After configuring the Web Part, if the user modifies the columns displayed for the Master List, the nested list, calculated, and conditional formatting options will be reset..
    • Feature: Resize Columns in Runtime Mode
      • Resizing columns in runtime mode for Nested Grid View causes display issues.
    • Feature: Selection of Columns in Runtime
      • If the grid view has few records, the drop down menu for selection of columns in runtime will be cut off.
  • Data Source: Bamboo List Rollup Web Part
    • Feature: Conditional Formatting
      • Columns of type Hyperlink or Picture and Multiple Lines of Text are not supported.
    • Feature: Datasheet Mode
      • Does not support modification of columns of type External Data Type.
      • Does not support modification of columns of type Multiple Lines of Text (Enhanced rich text).
      • Does not support modification of columns of type Recurrence and Workspace.
    • Feature: Export to Excel
      • The following column types are not formatted correctly:
        • Calculate
        • List Rollup special columns: List Name and Site Name return blank values
    • Feature: Filtering (Default)
      • Filtering lists of type Calendar on either Start Date or End Date will not return items with “All-Day Events” enabled.
      • The following column types are not supported:
        • Calculate
        • Choice (Multiple Selection mode)
        • Date & Time
        • Hyperlink or Picture
        • Lookup (Multiple Selection mode)
        • Number
        • Person or Group (Multiple Selection mode)
        • Yes/No
        • List Rollup special columns: List Name and Site Name
    • Feature: Filtering (Dynamic)
      • The following column types are not supported:
        • Calculate
        • Choice (Multiple Selection mode)
        • Date & Time
        • Hyperlink or Picture
        • Lookup (Multiple Selection mode)
        • Number
        • Person or Group (Multiple Selection mode)
        • Yes/No
        • List Rollup special columns: List Name and Site Name
      • Using the [Me] SharePoint variable is only supported with the operators Contains and Equals.
    • Feature: General Data Display
      • If user modifies their local in the "My Regional Settings" page, columns of type Currency and Calculated (output = Currency), the comma "," and decimal point "." are displayed in the wrong position.
    • Feature: Inline Edit Mode
      • Does not support modification of columns of type External Data Type.
      • Does not support modification of columns of type Recurrence and Workspace.
      • Columns of type Multiple Lines of Text - Rich Text and Enhanced Rich Text modes display HTML tags. Alternatively use the Content Editor provided in Datasheet mode.
    • Feature: Nested Data
      • Association between Parent Data and Nested Data is not supported if mapped columns contain multiple value (People and Group, Lookup and Choice).
      • Cannot link Nested Data set based on Lookup column in Master List.
    • Feature: Sorting (Default)
      • Date & Time columns are sorted as text instead of numbers.
      • Person or Group columns are not sorted correctly due to the data includes the profile ID.
    • Feature: Sorting (Dynamic)
      • Date & Time columns are sorted as text instead of numbers.
      • Person or Group columns are not sorted correctly due to the data includes the profile ID.
  • Data Source: SharePoint List or Library
    • Feature: Conditional Formatting
      • Columns of type Hyperlink or Picture and Multiple Lines of Text are not supported.
    • Feature: Datasheet Mode
      • Does not support modification of columns of type External Data Type.
      • Does not support modification of columns of type Multiple Lines of Text (Enhanced rich text).
      • If the source is External List, Datasheet mode is not supported.
      • If modifying a column of type Multiple Lines of Text that contains text surrounded by tag characters (i.e.. <...>), the text will clear upon saving.
      • If modifying a column of type Multiple Lines of Text that contains hyperlinks, the hyperlinks are lost upon saving the changes.
      • When users are modifying a cell of the following Column Types, the users will see the raw data instead of the formatted data. Upon navigating away from the cell, the format will be displayed correctly.
        • Choice (Checkboxes)
        • Lookup (Both Single and Multiple Selection modes)
        • Multiple Lines of Text (Rich Text and Enhanced Rich Text Modes)
        • Person or Group (Single or Multiple Selection modes)
      • Viewing or modifying columns of type Hyperlink or Picture displays only the Description text. User is not able to modify the URL.
      • Viewing or modifying columns of type Multiple Lines of Text (Plain Text mode) removes line breaks. If user modifies the column and saves changes, line breaks are removed from original column text.
      • Columns of type Business Data are not supported. Data-Viewer Web Part hides these columns automatically from view in Datasheet Mode.
      • All Bamboo Custom Columns are not supported.
      • Does not support modification of columns of type Recurrence and Workspace.
    • Feature: Export to Excel
      • Column display names with special characters are formatted incorrectly in the resulting Excel column headers.
      • The following column types are not formatted correctly:
        • Calculate
    • Feature: Filtering (Default)
      • Columns with multiple values are not supported.
    • Feature: Filtering (Dynamic)
      • If the backslash "\" is included in the filter string, it will be removed automatically.
      • If Filtering on Person or Group column, Bamboo recommends using the Contains operator and enter the User Name in the value instead of First or Last Name.
      • Columns with multiple values are not supported.
    • Feature: General Data Display
      • If user modifies their local in the "My Regional Settings" page, columns of type Currency and Calculated (output = Currency), the comma "," and decimal point "." are displayed in the wrong position.
    • Feature: Inline Edit Mode
      • Does not support modification of columns of type External Data Type.
      • If source is an External List, Inline Edit Mode is not supported.
      • Columns of type Business Data are not supported. Data-Viewer Web Part hides these columns automatically from view in Datasheet Mode.
      • Columns of type Multiple Lines of Text with Append Data feature enabled, only the current version text is displayed.
      • Columns of type Multiple Lines of Text - Rich Text and Enhanced Rich Text modes display HTML tags. Alternatively use the Content Editor provided in Datasheet mode.
      • Does not support modification of columns of type Recurrence and Workspace.
      • Columns of type Lookup with Multiple Selections are not supported.
      • No support for the following Bamboo Custom Columns:
        • Bamboo Column Level Security
        • Bamboo Lookup Selector
        • Bamboo Rating
        • Bamboo Rich Text
        • Bamboo Validator
    • Feature: Nested Data
      • Association between Parent Data and Nested Data is not supported if mapped columns contain multiple value (People and Group, Lookup and Choice).
  • Data Source: SQL Server Table/View
    • Feature: Datasheet Mode
      • Not Supported
  • Data Source: Business Connectivity Services (BCS)
    • Feature: Filtering
      • Certain filter criteria returns no results even though items do match the criteria.
R3.4

Known Issues:

  • The current release of Data-Viewer Web Part does not support migration to SharePoint 2010.
  • Connected to any source with Nested Data: Expanding and collapsing a Nested Data set causes an extra line to appear when using skin Web20.
  • Connected to SQL Table or View with Default Group By or Dynamic Grouping: If the SQL column contains a special character, the Web Part returns an error message.
  • After initially configuring the Web Part to use Asynchronous Mode, must navigate away from the page for the data to show for the first time.

Limitations:

  • Data Source: All
    • Feature: Calculated Settings
      • If the column that is being Calculated on is also used for grouping the data, the resulting Calculated value is shown as the last item in the grouping instead of bottom of Grid View.
    • Feature: Datasheet Mode
      • Editing a Person or Group column that allows multiple selections will replace the current list of values stored in the column.
      • Choice fields that allow multiple selections do not include a "Select All" choice.
    • Feature: Export to Excel
      • Master and Nested Data sets are exported in separate Excel files.
      • Date/Time columns formatted incorrectly in Excel. Resolved in Release 3.3.26 by enabling "Export Data in Excel with Data Formatting"
    • Feature: Grouping (Dynamic)
      • Dynamic Grouping only occurs on the current page in the grid and does not group the full data set.
    • Feature: Sorting (Default)
      • Default sorting is not honored if default grouping is enabled.
    • Feature: Language Resource Strings
      • No resources string available to modify the text "None" in the Calculated Settings section of the tool pane.
  • Data Source: Bamboo List Rollup Web Part
    • Feature: Conditional Formatting
      • Columns of type Hyperlink or Picture and Multiple Lines of Text are not supported.
    • Feature: Datasheet Mode
      • Does not support modification of columns of type Recurrence and Workspace.
    • Feature: Export to Excel
      • The following column types are not formatted correctly:
        • Calculate
        • Lookup (Single and Multiple Selection modes) Resolved in Release 3.3.26 by enabling "Export Data in Excel with Data Formatting"
        • Person or Group (Single and Multiple Selection modes) Resolved in Release 3.3.26 by enabling "Export Data in Excel with Data Formatting"
        • Multiple Lines of Text (Rich text or Enhanced rich text modes) will display html tags in the excel file whether "Export Data in Excel with Data Formatting" is enabled or not. Resolved in Release 3.4.41
        • List Rollup special columns: List Name and Site Name return blank values
    • Feature: Filtering (Default)
      • Filtering lists of type Calendar on either Start Date or End Date will not return items with “All-Day Events” enabled.
      • The following column types are not supported:
        • Calculate
        • Choice (Multiple Selection mode)
        • Date & Time
        • Hyperlink or Picture
        • Lookup (Multiple Selection mode)
        • Number
        • Person or Group (Multiple Selection mode)
        • Yes/No
        • List Rollup special columns: List Name and Site Name
    • Feature: Filtering (Dynamic)
      • The following column types are not supported:
        • Calculate
        • Choice (Multiple Selection mode)
        • Date & Time
        • Hyperlink or Picture
        • Lookup (Multiple Selection mode)
        • Number
        • Person or Group (Multiple Selection mode)
        • Yes/No
        • List Rollup special columns: List Name and Site Name
      • Using the [Me] SharePoint variable is only supported with the operators Contains and Equals.
    • Feature: General Data Display
      • If user modifies their local in the "My Regional Settings" page, columns of type Currency and Calculated (output = Currency), the comma "," and decimal point "." are displayed in the wrong position.
    • Feature: Inline Edit Mode
      • Does not support modification of columns of type Recurrence and Workspace.
      • Columns of type Multiple Lines of Text - Rich Text and Enhanced Rich Text modes display HTML tags. Alternatively use the Content Editor provided in Datasheet mode.
    • Feature: Nested Data
      • Association between Parent Data and Nested Data is not supported if mapped columns contain multiple value (People and Group, Lookup and Choice).
      • Cannot link Nested Data set based on Lookup column in Master List.
    • Feature: Sorting (Default)
      • Number columns are sorted as text instead of numbers. Resolved in Release 3.4.41
      • Date & Time columns are sorted as text instead of numbers.
      • Person or Group columns are not sorted correctly due to the data includes the profile ID.
    • Feature: Sorting (Dynamic)
      • Number columns are sorted as text instead of numbers.Resolved in Release 3.4.41
      • Date & Time columns are sorted as text instead of numbers.
      • Person or Group columns are not sorted correctly due to the data includes the profile ID.
  • Data Source: SharePoint List or Library
    • Feature: Conditional Formatting
      • Columns of type Hyperlink or Picture and Multiple Lines of Text are not supported.
    • Feature: Datasheet Mode
      • If modifying a column of type Multiple Lines of Text that contains text surrounded by tag characters (i.e.. <...>), the text will clear upon saving.
      • If modifying a column of type Multiple Lines of Text that contains hyperlinks, the hyperlinks are lost upon saving the changes.
      • When users are modifying a cell of the following Column Types, the users will see the raw data instead of the formatted data. Upon navigating away from the cell, the format will be displayed correctly.
        • Choice (Checkboxes)
        • Lookup (Both Single and Multiple Selection modes)
        • Multiple Lines of Text (Rich Text and Enhanced Rich Text Modes)
        • Person or Group (Single or Multiple Selection modes)
      • Viewing or modifying columns of type Hyperlink or Picture displays only the Description text. User is not able to modify the URL.
      • Viewing or modifying columns of type Multiple Lines of Text (Plain Text mode) removes line breaks. If user modifies the column and saves changes, line breaks are removed from original column text.
      • Columns of type Business Data are not supported. Data-Viewer Web Part hides these columns automatically from view in Datasheet Mode.
      • All Bamboo Custom Columns are not supported.
      • Does not support modification of columns of type Recurrence and Workspace.
    • Feature: Export to Excel
      • Column display names with special characters are formatted incorrectly in the resulting Excel column headers.
      • The following column types are not formatted correctly:
        • Calculate
        • Lookup (Single and Multiple Selection modes) Resolved in Release 3.3.26 by enabling "Export Data in Excel with Data Formatting"
        • Person or Group (Single and Multiple Selection modes) Resolved in Release 3.3.26 by enabling "Export Data in Excel with Data Formatting"
        • Multiple Lines of Text (Rich text or Enhanced rich text modes) will display html tags in the excel file whether "Export Data in Excel with Data Formatting" is enabled or not. Resolved in Release 3.4.41
    • Feature: Filtering (Default)
      • Columns with multiple values are not supported.
    • Feature: Filtering (Dynamic)
      • If the backslash "\" is included in the filter string, it will be removed automatically.
      • If Filtering on Person or Group column, Bamboo recommends using the Contains operator and enter the User Name in the value instead of First or Last Name.
      • Columns with multiple values are not supported.
    • Feature: General Data Display
      • If user modifies their local in the "My Regional Settings" page, columns of type Currency and Calculated (output = Currency), the comma "," and decimal point "." are displayed in the wrong position.
    • Feature: Inline Edit Mode
      • Columns of type Business Data are not supported. Data-Viewer Web Part hides these columns automatically from view in Datasheet Mode.
      • Columns of type Multiple Lines of Text with Append Data feature enabled, only the current version text is displayed.
      • Columns of type Multiple Lines of Text - Rich Text and Enhanced Rich Text modes display HTML tags. Alternatively use the Content Editor provided in Datasheet mode.
      • Does not support modification of columns of type Recurrence and Workspace.
      • Columns of type Lookup with Multiple Selections are not supported.
      • No support for the following Bamboo Custom Columns:
        • Bamboo Column Level Security
        • Bamboo Lookup Selector
        • Bamboo Rating
        • Bamboo Rich Text
        • Bamboo Validator
    • Feature: Nested Data
      • Association between Parent Data and Nested Data is not supported if mapped columns contain multiple value (People and Group, Lookup and Choice).
  • Data Source: SQL Server Table/View
    • Feature: Datasheet Mode
      • Not Supported
    • Feature: Add New Item
      • Not Supported Resolved in Release 3.4.41
R3.3

Known Issues:

  • The current release of Data-Viewer Web Part does not support migration from SharePoint 2007 to SharePoint 2010.
  • Connected to any source with Nested Data: Expanding and collapsing a Nested Data set causes an extra line to appear when using skin Web20.
  • Connected to SQL Table or View with Default Group By or Dynamic Grouping: If the SQL column contains a special character, the Web Part returns an error message.
  • After initially configuring the Web Part to use Asynchronous Mode, must navigate away from the page for the data to show for the first time.

Limitations:

  • Connected to List Rollup using Export to Excel: Some column types not formatted correctly in Excel.
  • Connected to List Rollup: Number columns are sorted as text instead of numbers .
  • Connected to List Rollup 4.5 or 5.0 Calendar lists: Filtering for a Start Time or End Time will not include all day events in the results.
  • Connected to any source using Edit in Datasheet Mode: Editing a Person or Group column that allows multiple selections will replace the current list of users in the column.
  • Connected to any source using Edit in Datasheet Mode: Choice fields that allow multiple selections do not include a "Select All" choice.
  • Connected to any source with Grouping: An error message is displayed when clicking Edit in Datasheet after expanding more than one group.
  • Connected to SQL Server View: Edit in Datasheet and Add New Item are not supported.
  • Connected to SharePoint List in Datasheet Mode: If modifying a column of type Multiple Lines of Text that contains text surrounded by tag characters (i.e.. <...>), the text will clear upon saving.
  • Connected to SharePoint List in Datasheet Mode: If modifying a column of type Multiple Lines of Text that contains hyperlinks, the hyperlinks are lost upon saving the changes.
  • Connected to SharePoint List in Datasheet Mode: When users are modifying a cell of the following Column Types, the users will see the raw data instead of the formatted data. Upon navigating away from the cell, the format will be displayed correctly.
    • Choice (Checkboxes)
    • Lookup (Both Single and Multiple Selection modes)
    • Multiple Lines of Text (Rich Text and Enhanced Rich Text Modes)
    • Person or Group (Single or Multiple Selection modes)
  • Connected to SharePoint List in Datasheet Mode: Viewing or modifying columns of type Hyperlink or Picture displays only the Description text. User is not able to modify the URL.
  • Connected to SharePoint List in Datasheet Mode: Viewing or modifying columns of type Multiple Lines of Text-Plain Text mode removes line breaks. If user modifies the column and saves changes, line breaks are removed from original column text.
  • Connected to SharePoint List in Inline Edit mode and Datasheet mode: Columns of type Business Data are not supported in Inline Edit Mode and Datasheet mode and as a result are hidden in the two modes.
  • Connected to SharePoint List in Inline Edit mode: Columns of type Multiple Lines of Text - Rich Text and Enhanced Rich Text modes display HTML tags. Alternatively use the Content Editor in Datasheet mode.
  • Connected to SharePoint List in Inline Edit mode: Columns of type Lookup with Multiple Selections is not supported.
  • Connected to SharePoint List in Inline Edit mode: No support for the following Bamboo Custom Columns:
    • Bamboo Column Level Security
    • Bamboo Lookup Selector
    • Bamboo Rich Text
    • Bamboo Validator
  • Connected to SharePoint List in Datasheet mode: All Bamboo Custom Columns are not supported.
  • Connected to SharePoint List with Export to Excel: Column display names with special characters are formatted incorrectly in the resulting Excel column headers.
  • Connected to SharePoint List with Dynamic Filtering: If the backslash "\" is included in the filter string, it will be removed automatically. If Filtering on Person or Group column, Bamboo recommends using the Contains operator and enter the User Name in the value instead.
  • Connected to SharePoint List or List Rollup in Inline Edit and Datasheet Mode: These modes does not support modification of Recurrence and Workspace columns.
  • Connected to SharePoint List or List Rollup in Inline Edit Mode: Columns of type Multiple Lines of Text - Rich Text or Enhanced Rich Text, displays html tags in the field.
  • Connected to SharePoint List or List Rollup with Export to Excel: The following columns are not formatted correctly in the resulting Excel file:
    • Calculate
    • Lookup (Single and Multiple Selection modes) Resolved in Release 3.3.26 by enabling "Export Data in Excel with Data Formatting"
    • Person or Group (Single and Multiple Selection modes) Resolved in Release 3.3.26 by enabling "Export Data in Excel with Data Formatting"
    • Multiple Lines of Text (Rich text or Enhanced rich text modes) will display html tags in the excel file whether "Export Data in Excel with Data Formatting" is enabled or not.
    • List Rollup special columns: List Name and Site Name return blank values 
  • Connected to SharePoint List or List Rollup with Nested Data: Linking columns with multiple values for Nesting Data is not supported.
  • Connected to SharePoint List or List Rollup with Default Filter and Dynamic Filtering: Columns with multiple values are not supported.
  • Connected to SharePoint List or List Rollup with Conditional Formatting: Columns of type Hyperlink or Picture and Multiple Lines of Text are not supported.
  • Connected to List Rollup with Default Filter and Dynamic Filtering: The following column types are not supported:
    • Calculate
    • Date & Time
    • Hyperlink or Picture
    • Lookup (Multiple Selection mode)
    • Number
    • Person or Group (Multiple Selection mode)
    • Yes/No
    • List Rollup special columns: List Name and Site Name
  • Connected to List Rollup with Default Filter and Dynamic Filtering: The SharePoint variable [Today] is not supported.
  • Connected to List Rollup with Default Sort and Dynamic Sorting: Columns returned by List Rollup are formatted in String format, as a result, columns of type Date and Time & Number are not sorted correctly.
  • Connected to List Rollup with Default Sort and Dynamic Sorting: Columns Person or Group are not sorted correctly due to the data includes the profile ID.
  • Connected to List Rollup with Dynamic Sorting: Using the [Me] SharePoint variable is only supported with the operators Contains and Equals.
  • Connected to List Rollup with Nesting Data option: Cannot link Nested Data set based on Lookup column in Master List.
  • Connected to SQL Table or View or BDC/MashPoint with Calculated Settings: In certain cases the resulting value is not formatted correctly.
  • Connected to any source with Export to Excel: Date/Time columns formatted incorrectly in Excel. Resolved in Release 3.3.26 by enabling "Export Data in Excel with Data Formatting"
  • Connected to any source using Calculated Settings: If the column that is being Calculated on is also used for grouping the data, the resulting Calculated value is shown as the last item in the grouping instead of bottom of Grid View.
  • Connected to any source using Dynamic Grouping: Dynamic Grouping only occurs on the current page in the grid and does not group the full data set.
  • Connected to any source using Export to Excel: Master and Nested Data sets are exported in separate Excel files.
  • No resources string available to modify the text "None" in the Calculated Settings section of the tool pane.
R3.2

Known Issues:

  • The current release of Data-Viewer Web Part does not support migration from SharePoint 2007 to SharePoint 2010.
  • Connected to any source with Nested Data: Expanding and collapsing a Nested Data set causes an extra line to appear when using skin Web20.
  • Connected to SQL Table or View with Default Group By or Dynamic Grouping: If the SQL column contains a special character, the Web Part returns an error message.
  • After initially configuring the Web Part to use Asynchronous Mode, must navigate away from the page for the data to show for the first time.

Limitations:

  • Connected to SharePoint List in Datasheet Mode: If modifying a column of type Multiple Lines of Text that contains text surrounded by tag characters (i.e.. <...>), the text will clear upon saving.
  • Connected to SharePoint List in Datasheet Mode: If modifying a column of type Multiple Lines of Text that contains hyperlinks, the hyperlinks are lost upon saving the changes.
  • Connected to SharePoint List in Datasheet Mode: When users are modifying a cell of the following Column Types, the users will see the raw data instead of the formatted data. Upon navigating away from the cell, the format will be displayed correctly.
    • Choice (Checkboxes)
    • Lookup (Both Single and Multiple Selection modes)
    • Multiple Lines of Text (Rich Text and Enhanced Rich Text Modes)
    • Person or Group (Single or Multiple Selection modes)
  • Connected to SharePoint List in Datasheet Mode: Viewing or modifying columns of type Hyperlink or Picture displays only the Description text. User is not able to modify the URL.
  • Connected to SharePoint List in Datasheet Mode: Viewing or modifying columns of type Multiple Lines of Text-Plain Text mode removes line breaks. If user modifies the column and saves changes, line breaks are removed from original column text.
  • Connected to SharePoint List in Inline Edit mode and Datasheet mode: Columns of type Business Data are not supported in Inline Edit Mode and Datasheet mode and as a result are hidden in the two modes.
  • Connected to SharePoint List in Inline Edit mode: Columns of type Multiple Lines of Text - Rich Text and Enhanced Rich Text modes display HTML tags. Alternatively use the Content Editor in Datasheet mode.
  • Connected to SharePoint List in Inline Edit mode: Columns of type Lookup with Multiple Selections is not supported.
  • Connected to SharePoint List in Inline Edit mode: No support for the following Bamboo Custom Columns:
    • Bamboo Column Level Security
    • Bamboo Lookup Selector
    • Bamboo Rich Text
    • Bamboo Validator
  • Connected to SharePoint List in Datasheet mode: All Bamboo Custom Columns are not supported.
  • Connected to SharePoint List with Export to Excel: Column display names with special characters are formatted incorrectly in the resulting Excel column headers.
  • Connected to SharePoint List with Dynamic Filtering: If the backslash "\" is included in the filter string, it will be removed automatically. If Filtering on Person or Group column, Bamboo recommends using the Contains operator and enter the User Name in the value instead.
  • Connected to SharePoint List or List Rollup in Inline Edit and Datasheet Mode: These modes does not support modification of Recurrence and Workspace columns.
  • Connected to SharePoint List or List Rollup in Inline Edit Mode: Columns of type Multiple Lines of Text - Rich Text or Enhanced Rich Text, displays html tags in the field.
  • Connected to SharePoint List or List Rollup with Export to Excel: The following columns are not formatted correctly in the resulting Excel file:
    • Calculate
    • Lookup (Single and Multiple Selection modes)
    • Person or Group (Single and Multiple Selection modes)
    • List Rollup special columns: List Name and Site Name return blank values
  • Connected to SharePoint List or List Rollup with Nested Data: Linking columns with multiple values for Nesting Data is not supported.
  • Connected to SharePoint List or List Rollup with Default Filter and Dynamic Filtering: Columns with multiple values are not supported.
  • Connected to SharePoint List or List Rollup with Conditional Formatting: Columns of type Hyperlink or Picture and Multiple Lines of Text are not supported.
  • Connected to List Rollup with Default Filter and Dynamic Filtering: The following column types are not supported:
    • Calculate
    • Date & Time
    • Hyperlink or Picture
    • Lookup (Multiple Selection mode)
    • Number
    • Person or Group (Multiple Selection mode)
    • Yes/No
    • List Rollup special columns: List Name and Site Name
  • Connected to List Rollup with Default Filter and Dynamic Filtering: The SharePoint variable [Today] is not supported.
  • Connected to List Rollup with Default Sort and Dynamic Sorting: Columns returned by List Rollup are formatted in String format, as a result, columns of type Date and Time & Number are not sorted correctly.
  • Connected to List Rollup with Default Sort and Dynamic Sorting: Columns Person or Group are not sorted correctly due to the data includes the profile ID.
  • Connected to List Rollup with Dynamic Sorting: Using the [Me] SharePoint variable is only supported with the operators Contains and Equals.
  • Connected to List Rollup with Nesting Data option: Cannot link Nested Data set based on Lookup column in Master List.
  • Connected to SQL Table or View or BDC/MashPoint with Calculated Settings: In certain cases the resulting value is not formatted correctly.
  • Connected to SQL Table or View with Export to Excel: Date/Time columns formatted incorrectly in Excel.
  • Connected to any source using Calculated Settings: If the column that is being Calculated on is also used for grouping the data, the resulting Calculated value is shown as the last item in the grouping instead of bottom of Grid View.
  • Connected to any source using Dynamic Grouping: Dynamic Grouping only occurs on the current page in the grid and does not group the full data set.
  • Connected to any source using Export to Excel: Master and Nested Data sets are exported in separate Excel files.
  • No resources string available to modify the text "None" in the Calculated Settings section of the tool pane.
R3.1

Known Issues and Limitations:

  • We are currently in the process of developing a migration procedure from SharePoint 2007 to SharePoint 2010 for this product.
  • Sorting or Group for Hyperlink or calculated column will not be correct.
  • Clicking on next page hyperlink will show error message while the grouping is expanded (if Allow Group option is selected in the tool part).
  • Filtering Settings: List Rollup Mode can not filter with [Me] token for filtering operators: "is not equal to, greater than, less than or equal to". It will work for "equal to" or "contain" operator only.
  • Does not support List Rollup Schemas.
  • SharePoint List or List Rollup data source connection needs to be in the same web app.
  • Data viewer web part - not sorting when using groups.
  • When export to excel, the columns are not shown as they were in the list. 
  • The excel export puts Time information in to the Date fields.
  • The sort is working as text instead of numeric.
Related Articles
No Related Articles Available.

Article Attachments
No Attachments Available.

Related External Links
No Related Links Available.
Help Us Improve This Article
What did you think of this article?

poor 
1
2
3
4
5
6
7
8
9
10

 excellent
Tell us why you rated the content this way. (optional)
   
Approved Comments
No user comments available for this article.