By using this website, you agree to our Terms of Use (click here)
I have a sales report that I put together that the users could filter by a State parameter. We just upgraded to 2019 R1 and now my parameter doesn't load up the list of states to choose from. Any idea how to do that now? Before the upgrade we could see it if I used the View Name '=Report.GetFieldSchema('LocationExtAddress.State')'. The parameter still works if the user types in a state abbreviation, but I'd like the actual parameter to work as it did before.
I use "=Report.GetFieldSchema('SOShippingAddress.State')" and it works in 2019R2 .
That didn't work for me either.
Is the table joined? If it is, i'm not sure what is different.
This is pretty cool. Never tried something like this. Ellie, can you include a screenshot of what it looks like on the REPORT PARAMETERS tab when you run the report?
Sure:
Beautiful!