Formula for reporting on breast cancer patients

[gromboy]

Hi,
I'm working on a report from a sql server db which has chemotherapy data in it. I'm looking at Breast Cancer treatments. The patient will have elements of treatment against a diagnosis.

For example
Patient 1 will have a diagnosis of "Carcinoma of Breast Metastatic , HER2 positive 1st Line". (They may have more than one diagnosis further down the line of treatment)
For this diagnosis they will have cycles of treatment which may last a day or two.
Each cycle will have a number of drugs which they will be given, a date a cycle number and treatment day number exists against every cycle of treatment in the database.

What I need to do is compare the cycles of treatment against the national guidelines. For example they should have cycle which contains a drug called either "EPIRUBICIN" or "DOXORUBICIN" to start with. They may have several cycles of this first. They then have a blood test and based on the test they will have Cycles which contain either "CAPECITABINE", "VINORELBINE", "DOCETAXEL", "TRASTUZUMAB(HERCEPTIN)", or "PACLITAXEL".

Having done some rather long if statements....I'm not sure how to tease out the results to compare to the national guidelines.

Does anyone have any suggestions...
Steve

 

[Turkbear]

Hi,
before any real attempt can be made to help, we need to know the tables,views and other data structures involved, their fields and data types, and any common links between them.





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[Madawc]

You can collect details from a group and show them all in the group footer. Try adapting something I wrote to collect postcodes:

// Accumulate using a formula field (suppressed) in the detail line.  Allow for nulls and blanks.
whileprintingrecords;
if not isnull({Recc.Postcode}) and {Recc.Postcode} <> " "
then stringvar pst := pst + {Recc.Postcode} +", "
else if length(pst) = 0 
then stringvar pst := pst + "Excluding blanks; "
else stringvar pst := pst

// Show in using a formula field in the group footer.
whileprintingrecords;
stringvar pst;
left(pst,len(pst)-2)

//  Clear using a formula field in the group header.
whileprintingrecords;
stringvar pst := "";

Note that clearing in the footer avoids problems with group headers repeating on a new page, which does clear everything for the group. Provided the 'clear' is placed in the section AFTER the display, it will do them in that order.


Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10