SELECT sum(total_summary),;
  sum(Ind_dep_incomes.game_equipment_sales),;
  sum(Ind_dep_incomes.repair_under_contract),;
  sum(Ind_dep_incomes.other_incomes),;
  sum(Ind_dep_charges_on_manufacture.personel_sallary) as manuf_personel_sallary,;
  sum(Ind_dep_charges_on_manufacture.personel_surtax) as manuf_personel_surtax ,;
  sum(Ind_dep_charges_on_manufacture.personel_risk_tax) as manuf_personel_risk_tax,;
  sum(Ind_dep_charges_on_manufacture.other_charges) as other_manuf_charg,;
  sum(Ind_dep_charges_on_manufacture.Add_fields) as manuf_add_fields,;
  sum(Ind_dep_invested_means.parts_accessories)as inv_parts_accessories,;
  sum(Ind_dep_invested_means.target_crediting) as inv_target_crediting,;
  sum(Ind_dep_invested_means.other_charges) as inv_other_means,;
  sum(Ind_dep_firm_charges.administrative)as firm_administrative,;
  sum(Ind_dep_firm_charges.transport_amortization)as firm_transport_amortization,;
  sum(Ind_dep_firm_charges.telecommunication)as firm_telecommunication,;
  sum(Ind_dep_firm_charges.mobile_comunication)as firm_mobile_comunication,;
  sum(Ind_dep_firm_charges.transport_charges)as firm_transport_charges,;
  sum(Ind_dep_firm_charges.paper_registration_services)as firm_paper_registration_services,;
  sum(Ind_dep_firm_charges.writing_goods_account_materials)as firm_writing_goods_account_materials,;
  sum(Ind_dep_firm_charges.internet)as firm_internet,;
  sum(Ind_dep_firm_charges.office_maintance)as firm_office_maintance,;
  sum(Ind_dep_firm_charges.personnel_salary)as firm_personnel_salary,;
  sum(Ind_dep_firm_charges.bank_services)as firm_bank_services,;
  sum(Ind_dep_firm_charges.creditor_payments)as firm_creditor_payments,;
  sum(Ind_dep_firm_charges.exhibitions)as firm_exhibitions,;
  sum(Ind_dep_firm_charges.traveling_living_expenses)as firm_traveling_living_expenses,;
  sum(Ind_dep_firm_charges.personel_social_tax)as firm_personel_social_tax,;
  sum(Ind_dep_firm_charges.personnel_surtax)as firm_personnel_surtax,;
  sum(Ind_dep_firm_charges.personel_risk_tax)as firm_personel_risk_tax,;
  sum(Ind_dep_firm_charges.vat_nds)as firm_vat_nds,;
  sum(Ind_dep_firm_charges.natural_resources_tax)as firm_natural_resources_tax,;
  sum(Ind_dep_firm_charges.economic_charges)as firm_economic_charges,;
  sum(Ind_dep_firm_charges.risks_insuarance)as firm_risks_insuarance,;
  sum(Ind_dep_firm_charges.other_firm_charges)as firm_other_firm_charges;
 FROM  dlvmaindb!industrial_department INNER JOIN dlvmaindb!ind_dep_incomes;
    ON  Industrial_department.incomes_id = Ind_dep_incomes.main_id;
    INNER JOIN dlvmaindb!ind_dep_charges_on_manufacture;
    ON  Industrial_department.charges_on_manufacture_id = Ind_dep_charges_on_manufacture.main_id;
    INNER JOIN dlvmaindb!ind_dep_invested_means;
    ON  Industrial_department.invested_means_id = Ind_dep_invested_means.main_id;
    INNER JOIN dlvmaindb!ind_dep_firm_charges;
   ON  Industrial_department.firm_charges_id = Ind_dep_firm_charges.main_id;
 WHERE Ind_dep_incomes.mode_id =  1 ;
   AND Ind_dep_charges_on_manufacture.mode_id =  1 ;
   AND Ind_dep_invested_means.mode_id =  1 ;
   AND Ind_dep_firm_charges.mode_id =  1 ;
   AND industrial_department.rep_date>=?start_date;
   AND industrial_department.rep_date<=?end_date

SET DATe DMY
start_date={^ 31 / 05 / 2006 }
end_date={^ 10 / 06 / 2006 }
*USE report_excel
DO report_excel.qpr
browse