Hi - fairly new to Ireports. Am writing a report and need subreports. My subreport works when i run test it, when I do the linking to the main report, the data does not return with the same values that it does when i run it by its self. The main report only returns the provider name , grouped by provider and Measure. the data is on the Provider Group ( only want 1 line returned per provider). The subreport has the same groupings, and is returning summary data for the provider. I have tried placing the data on the subreport, in the detail, measures and provider but it returns the same data each time.. Currently , i'm linking the provider and the begin and end dates. iF I add one for MEASURE-ID the data still is incorrect. Both supreports are attached I'm not sure what i'm doing wrong with the linking to make this happen. SQL from main report: SELECT Measure.`MeasureID` AS Measure_MeasureID, Measure.`MeasureName` AS Measure_MeasureName, Measure.`Target_P` AS Measure_Target_P, Report.`ReportID` AS Report_ReportID, Report.`ProName` AS Report_ProName, Report.`MeasureID` AS Report_MeasureID, SUM(Numerator), SUM(Denominator), Report.`Percent` AS Report_Percent, Report.`Exclude` AS Report_Exclude, Report.`Repdatetime` AS Report_Repdatetime, Report.`PassFail` AS Report_PassFail, Report.`ASDate` AS Report_ASDateFROM `Measure` Measure INNER JOIN `Report` Report ON Measure.`MeasureID` = Report.`MeasureID`WHERE Report.`ASDate` >= $P{BeginDate} and Report.`ASDate` <= $P{EndDate} and Denominator > 0Group byReport.`ProName` , Measure.`MeasureName` ORDER BY Report.`ProName` ASC, Measure.`MeasureName`, Report.`ASDate` ASC SQL from sub report : data on report is the avg-percent, measure-target-p . the AVG=Percent does not return to the main report correctlySELECT SUM(Numerator), SUM(Denominator), Round(AVG(Percent),2) AS AVG_Percent, Measure.`MeasureID` AS Measure_MeasureID, Measure.`MeasureName` AS Measure_MeasureName, Measure.`Target_P` AS Measure_Target_P, Report.`ProName` AS Report_ProName, Report.`MeasureID` AS Report_MeasureID, Report.`Percent` AS Report_Percent, Report.`ASDate` AS Report_ASDate, Report.`Denominator` AS Report_Denominator, Report.`Numerator` AS Report_NumeratorFROM `Measure` Measure INNER JOIN `Report` Report ON Measure.`MeasureID` = Report.`MeasureID`WHERE Denominator > 0 and Report.`ASDate` >= $P{BeginDate} and Report.`ASDate` <= $P{EndDate} and Report.`ProName` LIKE $P{Provider} and Report.`MeasureID` = 1Please help me with any suggestions or if you need more information