rave report simple problem

[stojakovic]

I have a Table as a DataSet for my TRvDataSetConection.
But, I only want the last record from the table to be printed on the report.
I have tryed everything I know (wich is not a lot b.t.w.!)
but it is allways the whole table printed

 

[acabrera]

If you want the last record in the table, try
SELECT MAX(ROWNUM) AS MAXROW FROM SAMPLE_TABLE

If your table has a key, and you want the last key, try
SELECT MAX(SAMPLE_KEY) AS MAX_KEY FROM SAMPLE_TABLE