Hi,

In my Main report I have a summary table like this,It is grouped by FC then by Class.There is a Avg.Rev col however I get the data from a subreport as I need to use that field to calculate days for that particular class in that FC

Class-A   Avg.Rev-A    Charges           Days
Medicare(FC-A)                    
         I       subrep dat     1000   1000/Avg.Rev-A
         O       subrep dat     2000   2000/Avg.Rev-A
         ED      subrep dat     5000   5000/Avg.Rev-A
Total             subrep dat     8000   8000/Avg.Rev-A

Here is what my subreport data look like

FC        Class Charges
Medicare     I     50
Medicare     I     150
Medicare     I     100
Medicare     O     250
Medicare     O     150
Medicare     ED     200
Medicare     ED     500
Medicare     ED     200

I did group by FC then by Class to get avg. rev

FC-B     Class-B   Rev-B
Medicare          
             I     100
             O     200
             ED    300
Total              600

My initial plan is to create a shared variable in sub-report to get Avg.Rev-A field in main report however I am not sure how to pass a shared variable from sub-report to main report. can you please look into ,if there is any other way please let me know.

Thanks,

Edited by achandana01 - 30 Oct 2012 at 6:15am

I Created shared variables exactly what you said in main report and report however I encounter a problem when I ran a report.As i Said before in my main report I grouped by FC then by Class.

In my subreport also I did the same grouping....and I put shared var in group 2 footer to get totals for Class.

Then I put my subreport in Group1 header of main report and I linked main report to subreport thru FC and Class.When I gave like this I am only getting 1stsubreport group2 values to main report for all class groups in main report group2 for that particular FC.

I removed class link and only put FC linkage to subreport.When I gave link like this I am only getting Last subreport group2 values to main report for all class groups in main report group2 for that particular FC.

I am not sure how to do the linkage to get the proper values for main report group2.

I believe I am missing a link please help!!!

Thanks,

Edited by achandana01 - 30 Oct 2012 at 2:00pm

In my subreport I only created a group for group2 and I put it in main report Group2 header and its working fine.

I need to do a sum of all value in group2 to put that value in main report group1 footer is it possible to do a sum or do I need to create another subreport for group1 to get the total value for group1 ? or is there any other way to do ?

Edited by achandana01 - 31 Oct 2012 at 1:15pm

I created a formula

Shared numbervar aTotal ;
aTotal := aTotal + {#Group 2 Charges}

//I am getting charges for group2 from the running total above

I created another formula in main report
Shared numbervar aTotal;
aTotal

I used this in report footer and I am getting correct grand total for the report.However I also need totals for data in Group1.Using the above formula I could able to get grand total in report footer but I am not able to reset shared variable in group footer 1 if so I could able to get what I am looking for.

It will be easier for me if I could create a formula for the totals for Group1 with in th same report rather than creating another subreport.

Thanks

Edited by achandana01 - 01 Nov 2012 at 6:00am

Excellent!! Its working for me you are a master [IMG]smileys/smiley1.gif" align="middle" />

I have another question I also do need to calculate % for each group typically this should me the formula

Total Charges GF2/Total Charges RF
Total Charges GF1/Total Charges RF

However I am having a problem to do this kind of % calculation for shared variables in groups, when I put the RF formula it is giving erroneous result.



Edited by achandana01 - 01 Nov 2012 at 1:11pm