Flex Reports - Shading

gnathan

Any help with how to alternate shading in a report would be helpful. This is for Cycle Count Variance Report.

Thanks

gnathan

Sure.

1. Create an EventHandler - StdObjectSelectCurrentCompleted with Type - Form Script Method and Parameters - SetDetailBackground()
2. Before Editing FormScript, figure out what you called your DetailFlex (In my case 2 lines - Detail2FlexLayout and Detail3FlexLayout)
3. Edit FormScript - and add the following lines into the Sub SetDetailBackground()
4.  Sub SetDetailBackground()
         If ThisForm.PrimaryIDOCollection.GetCurrentObjectIndex() Mod 2 = 0 Then         ThisForm.Components("Detail3FlexLayout").BackgroundColor = "200,200,200"         ThisForm.Components("Detail2FlexLayout").BackgroundColor = "200,200,200"      Else         ThisForm.Components("Detail3FlexLayout").BackgroundColor = "255,255,255"         ThisForm.Components("Detail2FlexLayout").BackgroundColor = "255,255,255"      End If   End Sub 5. 5. This will do it. Thanks.