Report broken down by results from a calculated field

[Johanna Gronlund]

Hello,

I have a query which calculates a date which is 100 days from the initial
referral date. Other fields in the query are: patient ID, date of surgery and
the reason why no surgery within 100 days of referral if applicable (this
field is added through a combobox that only gives choice of 3 options).

I would need a report that groups the results of the calculated field (those
who had surgery within 100 days of initial referral, those who did not have
surgery within 100 days and those who do not yet have surgery date. Those who
do NOT have surgery within 100 days of referral, I need to be able to group
them according to reason field.

I do not seem to be able to split the report according to this calculated
field. Is it possible or do I need to take a different approach? Any ideas
what that might be?

Johanna

 

[Klatuu]

Create an additional calculated field in your query that will determine to
which group the patient belongs. You can use your calculations in your query
that determines the number of days and whether they had surgery. Make the
calculaton return a value for each group the will sort in the order you want
the groups to appear on your report. Then use the Group By in the report to
group on this calculated field.