Topic: Multiple Report

hello friends..
how to get multiple Queries on One Page.. see Example... i wanna print Pumps And Grade Report on same page... data stored in 27 to 30 sep 2019

Post's attachments

Attachment icon MultipleReport.rar 390.27 kb, 35 downloads since 2019-10-02 

2 (edited by sibprogsistem 2019-10-02 16:52:48)

Re: Multiple Report

У Вас нет таблицы a b

// передача в дизайнер отчета объединенных данных несколькоих таблиц
    SQLQuery('SELECT servise.id AS "'+langIniG.ReadString('reportmess','dr48', '(id)')+'",'+
             'servise.telephonClient AS "'+langIniG.ReadString('reportmess','dr85', '(частный клиент) Телефон')+'",servise.adresClient AS "'+langIniG.ReadString('reportmess','dr52', '(частный клиент) Адрес')+'", servise.passportNamberClient AS "'+langIniG.ReadString('reportmess','dr53', '(частный клиент) Серия паспорта')+'", servise.passportSeriesClient AS "'+langIniG.ReadString('reportmess','dr54', '(частный клиент) Номер паспорта')+'",'+
             'servise.serialNamber AS "'+langIniG.ReadString('reportmess','dr55', '(Оборудование) Серийный номер')+'" ,servise.descriptionATCsWords AS "'+langIniG.ReadString('reportmess','dr56', '(Оборудование) Описание неисправности')+'",servise.externalStatus AS "'+langIniG.ReadString('reportmess','dr57', '(Оборудование) Внешний вид')+'",'+
             'servise.model AS "'+langIniG.ReadString('reportmess','dr58', '(Оборудование) Модель')+'",servise.dateInServise AS "'+langIniG.ReadString('reportmess','dr59', '(Оборудование) Дата поступления ')+'",servise.equipment AS "'+langIniG.ReadString('reportmess','dr60', '(Оборудование) Комплектация ')+'",'+
             'servise.diagnostics AS "'+langIniG.ReadString('reportmess','dr61', '')+'",servise.dateApplcation AS "'+langIniG.ReadString('reportmess','dr62', '(Заявка) Дата ожидания мастера')+'",servise.timeApplication AS "'+langIniG.ReadString('reportmess','dr63', '(Заявка) Время ожидания мастера')+'",'+
             'servise.warranty AS "'+langIniG.ReadString('reportmess','dr64', '(Оборудование) Гарантийный ДА/НЕТ')+'",servise.onlyDiiagnostics AS "'+langIniG.ReadString('reportmess','dr65', '(Оборудование) Только диагностика ДА/НЕТ')+'", '+
             'firstNameClient.name AS "'+langIniG.ReadString('reportmess','dr49', '(частный клиент)  Имя ')+'",'+
             'twoNameClient.name AS "'+langIniG.ReadString('reportmess','dr50', '(частный клиент) Фамилия ')+'",'+
             'lastNameClient.name  AS "'+langIniG.ReadString('reportmess','dr51', '(частный клиент) Отчество ')+'",'+
             'listWorkOff.priceWorkOff AS "'+langIniG.ReadString('reportmess','dr66', '(Работы) Цена')+'",listWorkOff.klVoWorkOff  AS "'+langIniG.ReadString('reportmess','dr67', '(Работы) Цена')+'",listWorkOff.nameWorkOff AS "'+langIniG.ReadString('reportmess','dr68', '(Работы) Наименование')+'",'+
             'sumInPrice.inPrice AS "'+langIniG.ReadString('reportmess','dr69', '(Оплата работ) Сумма оплаты')+'",sumInPrice.dateINPrice AS "'+langIniG.ReadString('reportmess','dr70', '(Оплата работ) Дата оплаты')+'", '+
             'TypeOfEquipment.nameTypeOfEquipment "'+langIniG.ReadString('reportmess','dr71', '(Оборудование) Тип')+'", '+
             'manufacturer.nameManufacturer AS "'+langIniG.ReadString('reportmess','dr72', '(Оборудование) Бренд')+'", '+
             'company.nameCompany AS "'+langIniG.ReadString('reportmess','dr73', '(Компания) Имя ')+'", telCompany AS "'+langIniG.ReadString('reportmess','dr74', '(Компания) Телефон')+'", streetCompany AS "'+langIniG.ReadString('reportmess','dr75', '(Компания) Улица')+'", houseCompany AS "'+langIniG.ReadString('reportmess','dr76', '(Компания) Дом')+'", fractionCompany AS "'+langIniG.ReadString('reportmess','dr77', '(Компания) Дробь')+'", officeCompany AS "'+langIniG.ReadString('reportmess','dr78', '(Компания) Офис')+'", '+
             'status.statusName AS "'+langIniG.ReadString('reportmess','dr79', '(Оборудование) Статус')+'", '+
             'clCompanyOrApp.nameclCompanyOrApp AS "'+langIniG.ReadString('reportmess','dr80', '(Тип клиента) Частный клиент,компания, заявка')+'" '+
             'FROM servise '+
             'LEFT OUTER JOIN firstNameClient ON firstNameClient.id=servise.id_firstNameClient '+
             'LEFT OUTER JOIN twoNameClient ON twoNameClient.id=servise.id_twoNameClient '+
             'LEFT OUTER JOIN lastNameClient ON lastNameClient.id=servise.id_lastNameClient '+
             'LEFT OUTER JOIN listWorkOff ON listWorkOff.id_servise=servise.id '+
             'LEFT OUTER JOIN sumInPrice ON sumInPrice.id_servise=servise.id '+
             'LEFT OUTER JOIN TypeOfEquipment ON TypeOfEquipment.id=servise.id_TypeOfEquipment '+
             'LEFT OUTER JOIN manufacturer ON manufacturer.id=servise.id_manufacturer '+
             'LEFT OUTER JOIN company ON company.id=servise.id_Company '+
             'LEFT OUTER JOIN status ON status.id=servise.id_status '+
             'LEFT OUTER JOIN clCompanyOrApp ON clCompanyOrApp.id=servise.id_clCompanyOrApp '+
             'WHERE servise.id='+ frmServiceCen.tgList.sqlValue , WorkOff);

Re: Multiple Report

need correction in my own project.. thanks

Re: Multiple Report

need help..

Re: Multiple Report

blackpearl8534 wrote:

need help..

????????

Re: Multiple Report

multi reports on same page

Re: Multiple Report

blackpearl8534 wrote:

multi reports on same page

SQLQuery('SELECT tblGrade.id, tblGrade.Grade_Name,'+
             'tblHoseDelivery.Delivery_Volume, tblHoseDelivery.Delivery_Value '+
             'FROM tblGrade '+
             'LEFT OUTER JOIN tblHoseDelivery ON tblGrade.id = tblHoseDelivery.id_tblGrade '+
             'WHERE tblHoseDelivery.Completed_TS >= '+Form1.FromTimePicker.sqlDateTime+' and  tblHoseDelivery.Completed_TS <= '+Form1.ToTimePicker.sqlDateTime+'', Results1);

Re: Multiple Report

can you correct my uploaded project

Re: Multiple Report

blackpearl8534 wrote:

can you correct my uploaded project

Post's attachments

Attachment icon MultipleReport.7z 88.69 kb, 28 downloads since 2019-10-04 

Re: Multiple Report

nor working friend... i need data group by pumps and group by grade on same page..

Re: Multiple Report

blackpearl8534 wrote:

i need data group by pumps and group by grade on same page..

мало информации

Re: Multiple Report

Solved.. i found way... thanks