kread
Active Member
I'm working on a new report that has 2 processing options but does not have data selection. I have a level break header section where I've set user selection in the initialize section.
My first line is to set the append flag to Yes. I have 3 lines after that. The first is to set one field from my business view to a specific value. The next 2 lines set business view fields based on the processing options. I've displayed the code below.
I've run it through debug and after it runs through the 3 lines, there's a delay before it gets to the Do Section. When it hits the Do Section, it's on the first record in the business view which does not match any of the criteria in the data selection.
I've used the same view in another report with no issue but could there be something in the business view that is overriding my data selection?
Set Selection Append Flag(<Yes>)
Set User Selection(BC Type of Hours (F31122)(TYR), <Equal To>, "4", <And>)
Set User Selection(BC Asset Item Number (F31122)(NUMB), <Equal To>, PO mnUserReservedNumber, <And>)
Set User Selection(BC User Reserved Reference (F31122)(URRF), <Equal To>, PO szUserReservedReference, <None>)
Thank you,
Kelly
My first line is to set the append flag to Yes. I have 3 lines after that. The first is to set one field from my business view to a specific value. The next 2 lines set business view fields based on the processing options. I've displayed the code below.
I've run it through debug and after it runs through the 3 lines, there's a delay before it gets to the Do Section. When it hits the Do Section, it's on the first record in the business view which does not match any of the criteria in the data selection.
I've used the same view in another report with no issue but could there be something in the business view that is overriding my data selection?
Set Selection Append Flag(<Yes>)
Set User Selection(BC Type of Hours (F31122)(TYR), <Equal To>, "4", <And>)
Set User Selection(BC Asset Item Number (F31122)(NUMB), <Equal To>, PO mnUserReservedNumber, <And>)
Set User Selection(BC User Reserved Reference (F31122)(URRF), <Equal To>, PO szUserReservedReference, <None>)
Thank you,
Kelly