How to display last record from table in jasper

[_AnonymousUser]

I run a procedure , output of that procedure is stored in one table . I want to print the last record from that table....
Is this possible , i tired tMSSqllastinserted and tlogrow , i getting only Null values . am using 3.2.1 version ....
Any suggestions ?
Thanks
Vikram

[Anonymous]

Hi
Where do you execute the procedure? tMssqlRow? Can you upload a screenshot of job?
Best regards
Shong

[Anonymous]

UPDINS is the procedure which i call , i load the output of the procedure in another table ....
I want display the message of the procedure thru Jasper ..

[Anonymous]

Hi
tMSSqllastinserted can't get last inserted id from the reproduce, you should use the tMssqlInput to query the last records after you call the reproduce. For example:
tMssqlConnection
|
onsubjobok
|
tMssqlsp
|
tMssqlnput--main--tLogRow
|
tMssqlClose
Best regards
Shong