Question
Accenture
Accenture
IN
Accenture
Posted: May 22, 2024
Last activity: Jun 4, 2024
Last activity: 4 Jun 2024 11:44 EDT
Solved
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?
***Edited by Moderator Marissa to change type from General to Product, added Product details and Capability tags***
To see attachments, please log in.
Accepted Solution
Posted: 5 months ago
Updated: 5 months ago
Updated: 4 Jun 2024 11:44 EDT
Aaseya IT Services Pvt LTD
Aaseya IT Services Pvt LTD
SA
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