Re: Repeating Table (Populating data and filtering into sections)

Shiva — Tue, 29 Jul 2008 10:42:53 GMT

Hello Welcome to the Forums,

It seems your formula is correct for repeating section. But you are applying this formula for under repeating section field called ‘CR number'. Then that formula is not works for this and it will display for only first row.

For this you have to change the binding of section to repeating section node and apply your formula then it works.

Repeating Table (Populating data and filtering into sections)

arudb — Wed, 23 Jul 2008 18:48:23 GMT

Hello all,

I have a form I built that is using an Access database as a primary data source and a Sharepoint list as a secondary data source. My goal is to list audit items that are separated into three different categories but are being pulled from the same data source. I keep getting data control errors or binding errors saying the data cannot be repeateThis is what it looks like now:

ECM Audit Report

Deployment Date

6/1/2008

[Enter Date]

Project Folder:

Director Name:

Red (Over 48 Hours old)

CR Number	RFC Contact	Workflow Status	Deploy Date	Update Fields

Yellow (Over 24 Hours old)

CR Number	RFC Contact	Workflow Status	Deploy Date	Update Fields

Grey (Pending Status)

CR Number	RFC Contact	Workflow Status	Deploy Date	Update Fields

Workflow Status – Inappropriate; Production Verify or Closed status are appropriate

Fill in the "Change Result - User Acceptance" text box with your production acceptance
Change the workflow to "OnlOpRelMgmt"

Deployment Status – Field Empty

Missing Docs - Implementation, Rollback or Testing fields empty. If these fields indicate an attachment is present then the attachment field may be audited if empty.

Missing Approval – Inappropriate approval based on level of severity (LOW = Manager, MED = Director, HIGH = CMRB)

Inappropriate CM Status – Must state APPROVED; CANCELLED status is not valid on a CR that is Closed Deployed

Priority – Field Empty

Missing SIV Score– Field Empty

For the field called CR number under I have the following formula listed:

Red:

@RFC_Number[(msxsl:string-compare(@Deployment_Date, startDate) >= 0 and msxsl:string-compare(@Deployment_Date, endDate) <= 0) and (contains(@Project_Folder, projectFolder)) and (contains(@Watch_List_Status, "Red"))]

Yellow:

Grey:

Basically the same formula but I have a filter setup to only show those items coded under that category. The problem is that only one record is showing for each entry and I would like it to pull all items. Any help is appreciated. Thanks in advance.

General

Re: Repeating Table (Populating data and filtering into sections)

Repeating Table (Populating data and filtering into sections)