How about adding 'Goto Layout [your layout]' and 'Show all records' before copy the value.
Or, don't copy/paste, use variable and set field.
Thanks for the feedback . But i had tried that one previously but its not working.
Have you tried using GetSummary ( ) and specifying the summary field as the break field? For example:
Set Variable [ $sumData ; GetSummary ( SumField ; SumField ) ]
Thanks for the reply .
But , i figured out that there were some data source access problems as the DB was within a specific folder structure.
From local running , the DB was accessible even the hosted DB folder address not given , but was not acting on schedule.
It is sorted out .
Thanks all for the valuable feedback and time.