J
Jose
I use FP to customize Sharepoint Services pages. I use the Sharepoint Data
View Web Part extensively. I have a problem that I believe is caused by a bug.
I use Data View to display the contents of an SP List data source. The list
has 3 calculated columns: Two are numeric and one is a date. I then use these
fields to filter and set conditioned formatting in the Data View.
There is no problem using the numeric calculated field for the purpose.
However, operations in the calculated data field do not work.
Conditioned Formating - If I set conditioned formatting based on the
calculated date field, the result of the formatting shows in the Data View at
design time, but the formatting dissapears when the page is displayed in IE
6.0. For example, if I set the date field lower than a given date to display
as bold red, the fields with these criteria will show red and bold at design
time, but they will revert to regular font when displayed in IE
Filtering - Filtering works when I set the filter at design time using the
filter wizard. However, filtering does not work from the Filter/Group/Sort
tool bar at run time.
By the way, the calculated date field is pretty simple: =[TODAY] + 10
I also tried =DATE(YEAR([Due Date]),MONTH([Due Date]),DAY([Due Date])+10)
I also tried a second date column that simply copied the contents of the
first. None works
In contrast, the calculated numeric fields are very elaborate, and they work
fine.
Any help will be appreciated
View Web Part extensively. I have a problem that I believe is caused by a bug.
I use Data View to display the contents of an SP List data source. The list
has 3 calculated columns: Two are numeric and one is a date. I then use these
fields to filter and set conditioned formatting in the Data View.
There is no problem using the numeric calculated field for the purpose.
However, operations in the calculated data field do not work.
Conditioned Formating - If I set conditioned formatting based on the
calculated date field, the result of the formatting shows in the Data View at
design time, but the formatting dissapears when the page is displayed in IE
6.0. For example, if I set the date field lower than a given date to display
as bold red, the fields with these criteria will show red and bold at design
time, but they will revert to regular font when displayed in IE
Filtering - Filtering works when I set the filter at design time using the
filter wizard. However, filtering does not work from the Filter/Group/Sort
tool bar at run time.
By the way, the calculated date field is pretty simple: =[TODAY] + 10
I also tried =DATE(YEAR([Due Date]),MONTH([Due Date]),DAY([Due Date])+10)
I also tried a second date column that simply copied the contents of the
first. None works
In contrast, the calculated numeric fields are very elaborate, and they work
fine.
Any help will be appreciated