I need to filter a related list for the active inventory in a related list. Similar to this question:

http://community.salesforce.com/t5/Visualforce-Development/Visualforce-Email-Template-Display-filtered-Opportunty-Report/m-p/148071

This is simple in an XSLT implementation.

I found the following:

http://community.salesforce.com/t5/Visualforce-Development/Visualforce-email-template-On-Account-displaying-all/m-p/154143#M18324

<apex:dataTable value="{!relatedTo.Opportunities}" var="o">

<apex:column value="{!o.Name}" rendered="{!o.IsClosed == false}"/>

<apex:column value="{!o.CloseDate}" rendered="{!o.IsClosed == false}"/>

</apex:dataTable>

This seams a lot easier than having to write a customer controller.

I have tried to apply the rendered="{!o.IsClosed == false} approach to the following code with no luck.

Any suggestions?

<apex:repeat var="cx" value="{!relatedTo.ri__Units__r}">

<tr>

<td WIDTH=100 >{!cx.Year__c}</td>

<td WIDTH=200>{!cx.Make__c}</td>

<td WIDTH=300>{!cx.Model__c}</td>

<td WIDTH=200>$<apex:outputText value="{0,number,00,000}"> <apex:param value="{!cx.ri__ListPrice__c}"/> </apex:outputText> </td>

<td WIDTH=200><img src={!cx.ri__Unit_Main_Image__c} height=100 width=150 alt={!cx.Model__c} /></td> </tr> </apex:repeat>

Any idea why I get a "field integrity exception" error when I try to update SOME PricebookEntry objects?  It doesn't happen for all Pricebooks/PricebookEntry objects, just some, but I can't figure out whether there's a pattern.  I'm definitely using a valid PricebookEntryId.  Any ideas are appreciated.