Parameter Not Showing Lookup for Customer Name

Hi ​@kviranga38 , Try this: =Report.GetFieldSchema('CustomerReportParameters.CustomerID')

Reference report - AR652000

​@kviranga38 The reason you’re not seeing the parameter is because there is no field schema to get for the chosen field. When setting parameters you can always check other reports to see how the parameter is derived. This is a great way to learn which fields can have their schema pulled like this.

Pretty sure you can also use fields as schema which aren’t joined in, you just have to add them to the report and then they should be able to be used in the schema.

Hi @kviranga38, Please try using this in the View Name field of the Parameter: =Report.GetFieldSchema('OrganizationBranchReportParameters.OrgBAccountID')

Hope this helps

Hi,

Thanks everyone, for your solutions and suggestions. I tried them, but the issue is still not resolved. The lookup control is still not appearing as expected. Do you have any other recommendations or alternative approaches I could try?

Hi ​@kviranga38,

Could you provide your .rpx file so someone can review? As ​@BenjaminCrisman suggested, you need to check the standard reports once, how they are declaring parameters.

Hope, it helps!

Hello ​@kviranga38 

Have you tried adding Filtering Condition under [FILTER TAB], just like the sample below: