SQL function return value Refer in a grid
Hi All,
I am having RD which is using SQL function to populate the date differences and its use as a data source to grid .
How can i refer RD SQL column return value in the grid instead of creating grid as dynamically.
Thanks,
Chathurika
***Updated by moderator: Lochan to add Categories***
Accepted Solution
EPAM Systems
HK
Thank you Saikat for your reply.Yes SQl function return value save to the the OOTB property and as per my workaround we cannot we refer it directly. We can refer it via the section and but again i am unable to filter it.
Thanks,
Chathurika
Maantic Inc
US
Refer the property in the grid, that will work.
example
RD has column abc, it is customized using SQL method.
In repeating grid - your source going to RD and refer the property abc
Capgemini
IN
I think it is not set to some property instead stored in some nested property. You can try to create the grid dynamically that would create the column based on the report defination. Or you can source the grid from activity and the call the RD from the activity and then loop through the results and store the SQl generated value to somewhere else.
-Saikat
Accepted Solution
EPAM Systems
HK
Thank you Saikat for your reply.Yes SQl function return value save to the the OOTB property and as per my workaround we cannot we refer it directly. We can refer it via the section and but again i am unable to filter it.
Thanks,
Chathurika