share variable

[tnguyen315]

I have a main report and subreport share parameter

main report:
PH
RH:suppressed
GH: table1.provider - suppressed
Detail: suprressed
GH...get all total
RF: suppressed
PF

Report...Select formulas...record

{table1.clinic} = {?Clinic} and
{table1.procudure_date} >= {?Beg Date} and
{table1.procudure_date} <= {?End Date} and
{table1.status} =102


Subreport:
PH:suppressed
RH:suppressed
Detail: suprressed
RF: count of table1.codeid(number), sum of @fee(Number)
PF: suppressed

Report...Select formulas...record

{table1.clinic} = {?Clinic} and
{table1.procudure_date} >= {?Beg Date} and
{table1.procudure_date} <= {?End Date} and
{table1.status} =90 and {table1.or} =1 and {table1.class} =1

Result:
Count Fee
CHIP: 15 $900
Medicaid: 20 $755
Copay : 25 (from subreport) $250 (from subreport)
--------------------------------------------------------
Total: 60 $1,905

I need help on the share variables from subreport (copay count 25, and fee: $250) to get the grand total on the main report.
Please help, i'm very appreciated.
Thank you very much.

 

[lbass]

Are CHIP and Medicaid the provider group instances? Should there be only one set of values returned from the subreport (across all provider types)?

-LB

 

[tnguyen315]

No,
table1 in the main report joined with tableins..with patientid
if tableins.ins = 1 then "CHIP" else
if tableins.ins = 2 then "MEDICAID" and so on...

So I cound those chip and medicaid based on...
if tableins.ins = 1 then 1 else 0
Then create a running total field on this field

Type of summary = sum
evaluate: checked "for each record"
reset: checked "on change of group" select group 1 " table1.provider"

 

[tnguyen315]

No,
table1 in the main report joined with tableins..with patientid
if tableins.ins = 1 then "CHIP" else
if tableins.ins = 2 then "MEDICAID" and so on...

So I count those fields ... chip and medicaid based on...
if tableins.ins = 1 then 1 else 0
Then create a running total field on this field

Type of summary = sum
evaluate: checked "for each record"
reset: checked "on change of group" select group 1 " table1.provider"