Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

PULL MOST RECENT INFO FROM HISTORICAL DATA

Status
Not open for further replies.

cmhdover

Technical User
Jul 15, 2004
37
US
I'm having a fight with my Crystal Reports. I am trying to build a report that shows me open clients that have a particular diagnosis. The problem is our diagnosis information is kept historically. So, say a client has been here, closed, come back, updated, etc., we have all those entries in their diagnosis history. I just want to see the most recent.

Can anyone help?

thanks
 
Sure, post technical information.

Crystal version
Database
example data
expected output

No offense intended, but if you think that every database is the same, so people here should know what to suggest when you say it's kept in history, you should consider reading up on relational databases, and you might consider some training in Crystal.

-k
 
Here goes,

I use Crystal version 8, cache database. I had training several years ago but the information wasn't relevant to our agency.

I want my report to list all active clients who have a bipolar diagnosis. Each client has several diagnosis entries in the diagnostic history. They have an admission, an updated, and a termination if we closed their case. Also, if they come back, the cycle starts again.

I want my report to only look at the most recent diagnosis - and it throw it out if it is a termination.

does this help?
 
Go to report->selection formula->RECORD and enter:

isnull({table.terminationdate})

Go to report->selection formula->GROUP and enter something like:

{table.servicedate} = maximum({table.servicedate},{table.client}) and
{table.diagnosis} = "Bipolar Disorder"

I don't know the fields you are working with so this is just a guess. If you need more help, please provide the fields names and some sample data.

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top