AnsweredAssumed Answered

re summary reports

Question asked by mark_d2x on Jun 25, 2009
Latest reply on Jun 25, 2009 by mark_d2x

Title

re summary reports

Post

Hi, struggling again!

 

Have read 2 books and still struggling with creating a report; what I thought was that I could do in effect a "pivot table" type report.

 

What I want is to produce several different types of report - all very similar with increasing complexity.

 

Firstly, I want to create a report based on the surgeon (SURGEON_GMC_CODE) and the operations they have done (PRIMARY_PROCEDURE_NAME).  

 

I want to have a drop down  box to choose the surgeon then in a table it has all the kinds of operations they have done for a given period of time.

 

Viz:

 

Surgeon A - from (DATE_OF_OPERATION) [start date] to [end date] 

 

Procedure 1   [result = count PRIMARY-PROCEDURE_NAME 1]  

Procedure 2   [result = count PRIMARY-PROCEDURE_NAME 2]

Procedure 3   [result = count PRIMARY-PROCEDURE_NAME 3]

etc 

 

Then I would like to add another variable [MAJOR_POST_OP_COMPLICATION

 

viz:

 Surgeon A - from (DATE_OF_OPERATION) [start date] to [end date] 

 

Procedure 1   [result = number] 

[result = count complication 1]

[result = count complication 2] 

  [result = count complication 3] 

 

Procedure 2   [result = number] 

[result = count complication 1]

[result = count complication 2] 

  [result = count complication 3]  

 

My question is this; is this possible in FMP ? or is this best done in Excel?

 

I also need to run a similar report for procedure and complications.

 

Best wishes as always

 

Mark 

Outcomes