I am trying to achieve below requirement using data transform but unable to progress. Please suggest.
I have a data page which calls a data trasnform , this will call a report definition to fetch data on to a page list RIFWork. Now my requirement is i have to iterate on RIFWork and check some criteria , if the criteria matches then that particular record in iteration should be coped to my source i.e data page.
I wrote ForEachPageIn to loop on RIFWork.pxResults
Added when rule to check criteria
Now when i try to copy to data page i am unable to. PFA screen shot.
@Pavani_Regulagedda
Select the check box “Also use each page as source context”. This will copy from RIFWork.pxResults to the Data Page, else it will treat Current source as Data page only as its inside when(you can check same on tracer).
Hope this helps!
PS: Able to see error mark on Primary.pxResults…are you getting any error while saving?
@BhanuPrakash_G
Yes, if the results fetched only from the report you need on data page, then you can source from report definition and have the report definition filter out records.