How do I set a property with sql query using Data Transform?

Hi,

Could anyone please share how to set a property with simple select sql query?

During runtime, set value is not passing into property.

Eg: Select name, Address from table where cusid=xxxxx?

@LakshmiD2536

SQL query cannot be referenced directly in the Data transform. You can use either a Data Page of Report definition to fullfill this requirement. You can create a parameterize data page/RD as per the where clause condition and it should be able to handle this requirement