display only last lines of a record

[vikascgmx]

Hello,
in our report only three last lines of a selection from record should be shown on the crystal report. How can we do this?

 

[dgillz]

The last 3 lines of a record? Or the last 3 records? Or do you want only those records with that match the criteria in the last 3 lines of your record selection formula code?

Please clarify what you want. If you have code, post it to this forum. Software Training and Support for Macola, Crystal Reports and Goldmine
714-348-0964
dgilsdorf@mchsi.com

 

[vikascgmx]

for the reports we are using peoplesoft queries. The query (
for example: select emplid, name, jobcode, effdt where emplid = '1111') can deliver a lot of rows with ascending effdt order for one employee. But for the report we need only the last three rows of the result set. As i know, it is not possible to do this limitation in the query.

 

[Naith]

Execute a TopN descending sort on your returned results formatted to only return the top 3 matching records.

 

[HowardHammerman]

You will have to sort on EmpID in order to do the TopN as Naith recommends. Otherwise do as he says. Howard Hammerman,
Crystal Reports training, consulting, books, training material,support. HammerLauch program runs reports without Crystal
howard@hammerman.com

http://www.hammerman.com

800-783-2269

 

[vikascgmx]

Thank you for your help
after using TopN the result was ok but is there a possibility to display this data in ascending order? I tried to change the sort order to ascending but the result was still in descending order

 

[dgillz]

Go back to the top-N expert. Ascending and descending are options at the bottom of the page. Software Training and Support for Macola, Crystal Reports and Goldmine
714-348-0964
dgilsdorf@mchsi.com