aftershokk
Registered User.
- Local time
- Today, 07:42
- 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!
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!