Hi there,
I have created a custom report to show the Receipt ref number. The report is working as expected.
The last bit I am trying to figure out now is to filter the source to only show Source equals IN
=Report.GetFieldSchema('INRegister.RefNbr,DocType')
I am not quite how I can achieve this. I saw some blogs and tried to do it but this didn't work.
I also am failing to understand how the getfieldschema works.
Any help would be appreciated.
Best answer by nhatnghetinh
Hi
I have a way to do this. You create a Filter in the Selector like the screenshots below.
The results are as below.
Best Regards,
NNT
+11Hi
I have a way to do this. You create a Filter in the Selector like the screenshots below.
The results are as below.
Best Regards,
NNT
Thanks NNT, appreciate this.
Just wondering as to why the default/shared is not being saved.
Tried with the exact steps as above.
If I recopied the Filter, it worked not sure why it happened.
@Amitkaryekar,
In the Report Designer, set the filter condition as SOURCE = 'IN' in the Schema Builder, save it, then enable the Default and Shared checkboxes before applying the changes.
Hope this helps.
However, as the selector fields would still pick the PO records based on the formula/view condition. The Filter solution provided above from NNT is the best in this scenario.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
