OnLoad: String was not recognized as a valid DateTime
You configured the Data-Viewer to filter the items in a SharePoint list and see this error when you save the web part settings.
The issue is that the current version of the Data-Viewer Web Part doesn’t support using a filter with [Today] and plus/minus values (i.e., [Today]+5) as shown here. The Web Part doesn’t currently recognize the string as a valid DateTime.
Filters using [Today] by itself should be OK.
As a workaround, create a list view that filters the items in the list using [Today]+5 and then configure the Data-Viewer Web Part to filter with Use list or library view instead of Create custom filter.
Data-Viewer’s conditional formatting is no longer being applied
You configured conditional formatting rules to be applied to content displayed in Data-Viewer and not only did they worked perfectly, they looked great!
Then one day, even though you didn’t make any changes to the conditional formatting rules, you realize they are no longer being applied to the Data-Viewer display. When you check the Conditional Formatting page, the rules appear to be there. So, what happened?
Example 1: Conditional formatting rules applied to the Task Status column
This issue is seen in Data-Viewer 3.6 and earlier and was caused when:
You opened the Column Display Settings dialog screen after you had configured the formatting rules
You clicked the Save & Close button to close that screen.
This would reset the Column Name associated with your formatting rules to the Title or default column of your list. Although the rest of the rule would be intact, since your rules didn’t apply to the newly identified column, no formatting would be displayed.
Example 2: The Column Names for the three rules have changed to Task Name. Since Task Name is never equal to Completed, In Progress, or Not Started, the conditions are never met so no formatting appears.
To fix the issue, just change the Column Name back to what it should be. All of the other rule settings should be intact and not require any changes.
Example 3: Change the column name back to Task Status for all three rules.
NOTE: Resetting the conditional formatting column(s) is not required if you are using Data-Viewer 3.7. To find out what version you are using, click here
Interactive Filters don’t appear after configuration
On the General Settings page, you enabled interactive filtering by checking the Allow Filtering box. You saved your configuration changes, applied them, and clicked OK to close the web part toolpane. The filter boxes don’t appear on the interface of the Data-Viewer Web Part. You refreshed the page and still no filter boxes appear. What’s wrong?
After implementing interactive filtering, sometimes you need to view a different portal page and then come back and view the page where your Data-Viewer Web Part is. When the page is re-loaded this way, the filter boxes should appear.
How to Turn off Page Navigation in the Web Part
You are displaying a small number of items in the Data-Viewer, but the paging links still appear. You have the Item Limit parameter configured and set to show 20 items per page (the default). Based on your business use case, you never expect to see more than 20 items in this view.
When you know that your display will not include a large number of items, unchecking the Item Limit box, will hide the Back and Next page navigation links (see screen shot below).
Error when configuring Data-Viewer SharePoint site URL
When configuring the Data-Viewer for displaying a SharePoint List or Library, you see the error message below when specifying an incorrect SharePoint Site URL and clicking View Lists and Libraries.
Be sure there is a / at the end of the URL. The screen shot below shows the correct syntax.