advanced question (1 Viewer)

aftershokk

Registered User.
Local time
Today, 12:37
Joined
Sep 5, 2001
Messages
259
Hello, I am decent with Crystal. We have a data set organized in rows in a DB. I want to pull the 2 most recent values for a member based on a filter for each instance.

Example: if column a = "test1" extract 2 most recent values from column b and place in column on a report.
Example: if column a = "test2" extract 2 most recent values from column b and place in column on a report.

Currently, we are using cursor and fetch to pre-summarize the data in a table on the server and then creating a table to pull the values.

Is there a way to do this in Crystal without tons of overhead?

thanks!
 

Users who are viewing this thread

Top Bottom