Parameters on report not working for RefNbr and DocType

Try this for your ReceiptNbr ‘View name’: =Report.GetFieldSchema('INRegister.RefNbr, ReceiptType')

​@darylbowman , thanks for your response. I did add that in, and I got this error.

Try =Report.GetFieldSchema('INRegister.RefNbr, DocType')

​@darylbowman 

Sorry to give you a bunch of stuff to try. I’m swamped and don’t have time to test first.

Last suggestion from me - all the reports I’ve seen that use this mechanism have the DocType with defined values instead of using the field schema. I can’t tell you why; just that it seems like if they go to that work, there may be something behind it.

You could try redefining the ReceiptType parameter and give it actual values instead of inferring the schema.

This is for Purchase Receipts:

INRegister DocType values are:

I - Issue
R - Receipt
T - Transfer
A - Adjustment
P - Assembly
D - Disassembly

Then use this =Report.GetFieldSchema('INRegister.RefNbr, ReceiptType')

Hi ​@darylbowman,

I tried that, but still no luck. Do you have any other suggestions?

Thanks,
RJ

I don’t ☹️

​@darylbowman 

Do you know why a GI and report Designer would give me different parameter results? I created a simple GI with the same tables and joins with these parameters,

And I can do a lookup on the Receipt Type and Number with no issues.

When I export it to a report and save it back to the server, I am not able to select anything.

My guess would be that the mechanism the Report Designer is using is not functioning in the way it does some other places. In GIs and on screens, selectors are configured to function in the context of the screen.

I don’t understand the ‘GetFieldSchema’ mechanism well enough to know what it’s expecting aside from copying other reports.

I'm confused. Is that different than this? We tried this a long time ago.