Skip to Content
0
Jan 23, 2019 at 07:27 PM

Print a particular field value of aselected record in crystal report

1186 Views

I have already printed a report showing the data of this Table in Detail Section.

Transaction Date Principal Amount Interest Total receipt

01/05/2011 2300 800 3100

05/06/2011 0 900 900

03/07/2011 100 600 700

09/08/2011 0 1000 1000

08/09/2011 200 800 1000

05/10/2011 0 700 700

06/11/2011 0 800 800

But I want to print in footer section the 'Transaction Date' of last 'Principal Amount' collected ie 08/09/2011 of 'Principal Amount' 200. For this I created a Formula field If Nextisnull {Transaction Date} and {Principal Amount} > 0 then {Transaction Date} The result shows that 06/11/2011 ie Last transaction Date. Any one can help me to solve this problem?