Hi I need some help..
so initially my report will be printed
and it will be divided into couple of groups
case ID
source
event seq #
drug
now I have to evaluate this formula
similarcases after it is all printed.
usually the reported is generated within the interest of time period
then within the generated reports, i wanna count similar cases
the logic behind counting similar cases is
within the same drug, different case id, if the event description (which is diff from event seq#) is the same/similar then increase the counter from 1 => 2 and print it beside both data rows..
so for instance, when the report is just generated, it will be like this
case id source event seq # event drug
abc L 1 dizzy clozapine
..
.
.
.
.
.
.
.
lhk L 3 dizzy clozapine
then after the evaluation, i want to generate the report again but with added column called similar cases
case id source event seq # event drug similar
abc L 1 dizzy clozapine 2
..
.
.
.
.
.
.
.
lhk L 3 dizzy clozapine 2
I hope someone can help me out in this..
thank you
so initially my report will be printed
and it will be divided into couple of groups
case ID
source
event seq #
drug
now I have to evaluate this formula
similarcases after it is all printed.
usually the reported is generated within the interest of time period
then within the generated reports, i wanna count similar cases
the logic behind counting similar cases is
within the same drug, different case id, if the event description (which is diff from event seq#) is the same/similar then increase the counter from 1 => 2 and print it beside both data rows..
so for instance, when the report is just generated, it will be like this
case id source event seq # event drug
abc L 1 dizzy clozapine
..
.
.
.
.
.
.
.
lhk L 3 dizzy clozapine
then after the evaluation, i want to generate the report again but with added column called similar cases
case id source event seq # event drug similar
abc L 1 dizzy clozapine 2
..
.
.
.
.
.
.
.
lhk L 3 dizzy clozapine 2
I hope someone can help me out in this..
thank you