MyLogical.Db 9HzRC+9ZAe3iW9XE61SiH9FW4WhOXbuVaE0l3GF0ohPfetkI41sT7eFbnPh3ROMb1sL1yWFZsYjNUc3JTkliY5Bs+4joQcKZzES5rHlUoC/ZVtvCTRijzeET0fhkSSUf0Wj7SExdMYVrFeiY5Uxtf9F80QnIV5KBfxjZvfsYdw/c8g== MyLogical.Db instruments id,System.Int32 code,System.String instrument_model_name,System.String customer_name,System.String last_calibration,System.DateTime supplier_name,System.String serial_number,System.String id_sector,System.Int32 sector_name,System.String instrument_type,System.String next_calibration,System.DateTime id_customer,System.Int32 customer_sector_name,System.String id_customer_sector,System.Int32 accreditation_name,System.String 30 False instruments MyLogical.Db _x0040_sector,_id_sector,8,0 _x0040_instrument_type,_id_instrument_type,8,0 _x0040_customer,_id_customer,8,0 _x0040_supplier,_id_supplier,8,0 _x0040_active,_id_active,8,0 _x0040_customer_sector,_id_customersector,8,0 _x0040_accreditation,_id_accreditation,8,0 select distinct i.id, i.code, coalesce(im.name, '[Nenhum]') as instrument_model_name, c.name as customer_name, i.last_calibration, coalesce(su.name, '[Nenhum]') as supplier_name, i.serial_number, coalesce(s.id, 0) as id_sector, s.name as sector_name, it.name as instrument_type, i.next_calibration, c.id as id_customer, cs.name as customer_sector_name, cs.id as id_customer_sector, aa.name as accreditation_name from instruments i left join instruments_models im on (im.id = i.id_instrument_model) left join customers c on (i.id_customer=c.id) inner join suppliers su on (su.id=i.id_supplier and (@supplier = 0 or su.id=@supplier)) left join sectors s on (s.id = i.id_current_sector and (@sector = 0 or s.id=@sector)) inner join customer_sectors cs on (cs.id=i.id_sector and (@customer_sector = 0 or cs.id=@customer_sector)) inner join instrument_types it on (it.id = i.id_instrument_type and (@instrument_type = 0 or it.id=@instrument_type)) inner join accreditation_areas aa on (aa.id=it.id_accreditation and (@accreditation = 0 or aa.id=@accreditation)) where i.removed=0 and aa.removed=0 and it.removed=0 and i.id_customer=@customer and (@active=0 or ((@active = 1 and i.is_active=1) or (@active = 2 and i.is_active=0))) sectors id,System.Int32 name,System.String 30 sectors MyLogical.Db select distinct 0 as id, '[Todos]' as name union select distinct s.id, s.name as name from sectors s where s.removed=0 order by name instrument_types id,System.Int32 name,System.String 30 instrument_types MyLogical.Db select distinct 0 as id, '[Todos]' as name union select distinct it.id, it.name as name from instrument_types it where it.removed=0 order by name customers id,System.Int32 name,System.String 30 customers MyLogical.Db select distinct 0 as id, '[Todos]' as name union select distinct c.id, c.alias as name from customers c where c.removed=0 order by name suppliers id,System.Int32 name,System.String 30 suppliers MyLogical.Db select distinct 0 as id, '[Todos]' as name union select distinct s.id, s.name from suppliers s where s.removed=0 and s.is_manufacturer = 1 order by name sector_customer id,System.Int32 name,System.String 30 sector_customer MyLogical.Db _x0040_id_customer,IIF_x0028_VALUES.id_customer_x0020__x003D__x003D__x0020_null_x002C__id_customer_x002C_VALUES.id_customer_x0029_,8,0 select distinct 0 as id, '[Todos]' as name union select distinct cs.id, cs.name as name from customer_sectors cs where cs.removed=0 and cs.id_customer=@id_customer order by name accreditation id,System.Int32 name,System.String 30 accreditation MyLogical.Db select distinct 0 as id, '[Todos]' as name union select distinct aa.id, aa.name from accreditation_areas aa where aa.removed=0 order by 1 PARAMETERS LandscapeHeaderImage,System.Drawing.Image PortraitHeaderImage,System.Drawing.Image LandscapeFooterImage,System.Drawing.Image PortraitFooterImage,System.Drawing.Image _ID,System.Int32 _Current,System.Object IsPrintFormat,System.Boolean IsExternalLab,System.Boolean PARAMETERS PARAMETERS VALUES id_customer,System.Int32 VALUES VALUES ,_id_sector,Sector:,,System.Int32,,False,False,True,False,_x003C__x003F_xml_x0020_version_x003D__x0022_1.0_x0022__x0020_encoding_x003D__x0022_utf-16_x0022__x0020_standalone_x003D__x0022_yes_x0022__x003F__x003E__x003C_StiSerializer_x0020_version_x003D__x0022_1.02_x0022__x0020_type_x003D__x0022_Net_x0022__x0020_application_x003D__x0022_State_x0022__x003E__x003C_ItemsInitializationType_x003E_Columns_x003C__x002F_ItemsInitializationType_x003E__x003C_KeysColumn_x003E_sectors.id_x003C__x002F_KeysColumn_x003E__x003C_ValuesColumn_x003E_sectors.name_x003C__x002F_ValuesColumn_x003E__x003C_AllowUserValues_x003E_False_x003C__x002F_AllowUserValues_x003E__x003C_Keys_x0020_isList_x003D__x0022_true_x0022__x0020_count_x003D__x0022_0_x0022__x0020__x002F__x003E__x003C_Values_x0020_isList_x003D__x0022_true_x0022__x0020_count_x003D__x0022_0_x0022__x0020__x002F__x003E__x003C__x002F_StiSerializer_x003E_ ,_id_customer,Cliente:,,System.Int32,,False,False,True,False,_x003C__x003F_xml_x0020_version_x003D__x0022_1.0_x0022__x0020_encoding_x003D__x0022_utf-16_x0022__x0020_standalone_x003D__x0022_yes_x0022__x003F__x003E__x003C_StiSerializer_x0020_version_x003D__x0022_1.02_x0022__x0020_type_x003D__x0022_Net_x0022__x0020_application_x003D__x0022_State_x0022__x003E__x003C_ItemsInitializationType_x003E_Columns_x003C__x002F_ItemsInitializationType_x003E__x003C_KeysColumn_x003E_VALUES.id_customer_x003C__x002F_KeysColumn_x003E__x003C_ValuesColumn_x003E__x005B_No_x005D__x003C__x002F_ValuesColumn_x003E__x003C_AllowUserValues_x003E_False_x003C__x002F_AllowUserValues_x003E__x003C_Keys_x0020_isList_x003D__x0022_true_x0022__x0020_count_x003D__x0022_0_x0022__x0020__x002F__x003E__x003C_Values_x0020_isList_x003D__x0022_true_x0022__x0020_count_x003D__x0022_0_x0022__x0020__x002F__x003E__x003C__x002F_StiSerializer_x003E_ ,_id_supplier,Fornecedor:,,System.Int32,,False,False,True,False,_x003C__x003F_xml_x0020_version_x003D__x0022_1.0_x0022__x0020_encoding_x003D__x0022_utf-16_x0022__x0020_standalone_x003D__x0022_yes_x0022__x003F__x003E__x003C_StiSerializer_x0020_version_x003D__x0022_1.02_x0022__x0020_type_x003D__x0022_Net_x0022__x0020_application_x003D__x0022_State_x0022__x003E__x003C_ItemsInitializationType_x003E_Columns_x003C__x002F_ItemsInitializationType_x003E__x003C_KeysColumn_x003E_suppliers.id_x003C__x002F_KeysColumn_x003E__x003C_ValuesColumn_x003E_suppliers.name_x003C__x002F_ValuesColumn_x003E__x003C_AllowUserValues_x003E_False_x003C__x002F_AllowUserValues_x003E__x003C_Keys_x0020_isList_x003D__x0022_true_x0022__x0020_count_x003D__x0022_0_x0022__x0020__x002F__x003E__x003C_Values_x0020_isList_x003D__x0022_true_x0022__x0020_count_x003D__x0022_0_x0022__x0020__x002F__x003E__x003C__x002F_StiSerializer_x003E_ ,_id_instrument_type,Tipo_x0020_do_x0020_Instrumento:,,System.Int32,,False,False,True,False,_x003C__x003F_xml_x0020_version_x003D__x0022_1.0_x0022__x0020_encoding_x003D__x0022_utf-16_x0022__x0020_standalone_x003D__x0022_yes_x0022__x003F__x003E__x003C_StiSerializer_x0020_version_x003D__x0022_1.02_x0022__x0020_type_x003D__x0022_Net_x0022__x0020_application_x003D__x0022_State_x0022__x003E__x003C_ItemsInitializationType_x003E_Columns_x003C__x002F_ItemsInitializationType_x003E__x003C_KeysColumn_x003E_instrument_types.id_x003C__x002F_KeysColumn_x003E__x003C_ValuesColumn_x003E_instrument_types.name_x003C__x002F_ValuesColumn_x003E__x003C_AllowUserValues_x003E_False_x003C__x002F_AllowUserValues_x003E__x003C_Keys_x0020_isList_x003D__x0022_true_x0022__x0020_count_x003D__x0022_0_x0022__x0020__x002F__x003E__x003C_Values_x0020_isList_x003D__x0022_true_x0022__x0020_count_x003D__x0022_0_x0022__x0020__x002F__x003E__x003C__x002F_StiSerializer_x003E_ ,_id_active,Status:,,System.Int32,,False,False,True,False,_x003C__x003F_xml_x0020_version_x003D__x0022_1.0_x0022__x0020_encoding_x003D__x0022_utf-16_x0022__x0020_standalone_x003D__x0022_yes_x0022__x003F__x003E__x003C_StiSerializer_x0020_version_x003D__x0022_1.02_x0022__x0020_type_x003D__x0022_Net_x0022__x0020_application_x003D__x0022_State_x0022__x003E__x003C_AllowUserValues_x003E_False_x003C__x002F_AllowUserValues_x003E__x003C_Keys_x0020_isList_x003D__x0022_true_x0022__x0020_count_x003D__x0022_3_x0022__x003E__x003C_value_x003E_0_x003C__x002F_value_x003E__x003C_value_x003E_1_x003C__x002F_value_x003E__x003C_value_x003E_2_x003C__x002F_value_x003E__x003C__x002F_Keys_x003E__x003C_Values_x0020_isList_x003D__x0022_true_x0022__x0020_count_x003D__x0022_3_x0022__x003E__x003C_value_x003E__x005B_Todos_x005D__x003C__x002F_value_x003E__x003C_value_x003E_Ativos_x003C__x002F_value_x003E__x003C_value_x003E_Inativos_x003C__x002F_value_x003E__x003C__x002F_Values_x003E__x003C__x002F_StiSerializer_x003E_ ,_id_customersector,Setor_x0020_do_x0020_cliente:,,System.Int32,,False,False,True,False,_x003C__x003F_xml_x0020_version_x003D__x0022_1.0_x0022__x0020_encoding_x003D__x0022_utf-16_x0022__x0020_standalone_x003D__x0022_yes_x0022__x003F__x003E__x003C_StiSerializer_x0020_version_x003D__x0022_1.02_x0022__x0020_type_x003D__x0022_Net_x0022__x0020_application_x003D__x0022_State_x0022__x003E__x003C_ItemsInitializationType_x003E_Columns_x003C__x002F_ItemsInitializationType_x003E__x003C_KeysColumn_x003E_sector_customer.id_x003C__x002F_KeysColumn_x003E__x003C_ValuesColumn_x003E_sector_customer.name_x003C__x002F_ValuesColumn_x003E__x003C_AllowUserValues_x003E_False_x003C__x002F_AllowUserValues_x003E__x003C_Keys_x0020_isList_x003D__x0022_true_x0022__x0020_count_x003D__x0022_0_x0022__x0020__x002F__x003E__x003C_Values_x0020_isList_x003D__x0022_true_x0022__x0020_count_x003D__x0022_0_x0022__x0020__x002F__x003E__x003C__x002F_StiSerializer_x003E_ ,_id_accreditation,Grandeza:,,System.Int32,,False,False,True,False,_x003C__x003F_xml_x0020_version_x003D__x0022_1.0_x0022__x0020_encoding_x003D__x0022_utf-16_x0022__x0020_standalone_x003D__x0022_yes_x0022__x003F__x003E__x003C_StiSerializer_x0020_version_x003D__x0022_1.02_x0022__x0020_type_x003D__x0022_Net_x0022__x0020_application_x003D__x0022_State_x0022__x003E__x003C_ItemsInitializationType_x003E_Columns_x003C__x002F_ItemsInitializationType_x003E__x003C_KeysColumn_x003E_accreditation.id_x003C__x002F_KeysColumn_x003E__x003C_ValuesColumn_x003E_accreditation.name_x003C__x002F_ValuesColumn_x003E__x003C_AllowUserValues_x003E_False_x003C__x002F_AllowUserValues_x003E__x003C_Keys_x0020_isList_x003D__x0022_true_x0022__x0020_count_x003D__x0022_0_x0022__x0020__x002F__x003E__x003C_Values_x0020_isList_x003D__x0022_true_x0022__x0020_count_x003D__x0022_0_x0022__x0020__x002F__x003E__x003C__x002F_StiSerializer_x003E_ EngineV2 None;Black;2;Solid;False;4;Black Transparent Transparent 0,0.4,27.7,2.8 True Transparent 0,0,9.5,2.6 c8cc4e096bf94c3abe614575cd510f10 {PARAMETERS.LandscapeHeaderImage} Image1 True Transparent 17.5,0.4,10.2,1.6 Arial,16,Bold 6f1a41fd47164dedabb0dcfd981e870f Right 0,0,0,0 Text1 {ReportName} Black Center Transparent 9.8,0.2,4.4,0.8 Arial,16,Bold e8752b48c4204961b081a4f8b375b279 Right 0,0,0,0 Text6 {VALUES.id_customer} Black Expression Center Transparent 9.8,1.2,4.4,0.8 Arial,16,Bold 0020f72babaf433b81a0d5065b94ad30 Right 0,0,0,0 Text7 {_id_customer} Black Expression Center 18da5925438a47b7a414751ff6e154c9 PageHeader1 Transparent 0,17.7,27.7,1.3 True None;Transparent;1;Solid;False;4;Black Transparent 0,0.05,27.7,1.2 c41d88b162304b0eae9ffe447bb3354c Right {PARAMETERS.LandscapeFooterImage} Image2 True None;Transparent;1;Solid;False;4;Black Transparent 0,0.1,6,0.5 Arial,8 21fd366138b944c386e542e1e774d561 0,0,0,0 Text4 Página {PageNumber} de {TotalPageCount} Black None;Transparent;1;Solid;False;4;Black Transparent 0,0.6,6,0.5 Arial,8 252b7ab421c34af1a941c7d89fe5348e 0,0,0,0 Text5 Visualizado em {Time.ToString("dd/MM/yyyy")} às {Time.ToString("HH:mm")} Black 0,0,25.7,0.0254 DarkGray Black a0c337f090524419b31925d23346c58f HorizontalLine1 Black 54951e18789a4c35880d47db9879197e PageFooter1 None;WhiteSmoke;1;Solid;False;4;Black White 0,4,27.7,1 [210:210:210] 0,0.5,2.8,0.5 Arial,8 dbd7dde904004d3c8b15bcfc532895f7 dataBySector.CODE 0,0,0,0 HeaderMyDataSource__DataSource1__CODE Código Black Center [210:210:210] 7.2,0.5,5.2,0.5 Arial,8 3c369a5d03334cc586a194e2944f966f dataBySector.INSTRUMENT_TYPE 0,0,0,0 colType Tipo de Instrumento Black Center [210:210:210] 2.8,0.5,4.4,0.5 Arial,8 8a54350c77a043d7b623277f8576e6e1 dataBySector.INSTRUMENT_MODEL_NAME 0,0,0,0 colModels Modelo Black Center [210:210:210] 12.4,0.5,4.4,0.5 Arial,8 2b7ff6df68c34faaad4d20fe7336b04d dataBySector.MANUFACTURER_NAME 0,0,0,0 Text10 Fabricante Black Center EmptyBrush 0,0,1.2,0.5 Arial,8 2633fe9ce7ae4ab898b72123b19b0da7 dataBySector.CODE 0,0,0,0 Texto1 Setor: Black Center EmptyBrush 1.2,0,11.6,0.5 Arial,8,Bold 10ec0307a45740b79e7c9e92f3347f3b dataBySector.CODE 0,0,0,0 Texto2 {(instruments.sector_name == "" ? "Nenhum" : instruments.sector_name)} Black Center [210:210:210] 16.8,0.5,3.8,0.5 Arial,8 99a9501bab654062b894f01e3ebad529 dataBySector.MANUFACTURER_NAME 0,0,0,0 Text13 Ultima Calibração Black Expression Center [210:210:210] 20.6,0.5,3.4,0.5 Arial,8 660508801f5b466d8fe8430c1d678f4a dataBySector.MANUFACTURER_NAME 0,0,0,0 Text15 Grandeza Black Expression Center [210:210:210] 24,0.5,3.7,0.5 Arial,8 e0cbaaccd62d413b99f542809ee33b93 dataBySector.MANUFACTURER_NAME 0,0,0,0 Text2 Setor do Cliente Black Expression Center 0,0.5,25.7,0.0254 DarkGray Black 6da2873c6457485e90fc57deefc7411c HorizontalLine2 Black {sectors.name} 886714ce1e27468dbd0d7d610eefba7e grpBySector True [235:235:235] 0,5.8,27.7,0.5 Transparent True 0,0,2.8,0.5 Arial,8 3322a8454e7841b2be9e1ca7bd21c1a1 0,0,0,0 Texto9 {instruments.code} Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, DataColumn Center Transparent True 7.2,0,5.2,0.5 Arial,8 59f208f293804fbcba57d6f171bb5b9e 0,0,0,0 Texto10 {instruments.instrument_type} Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, DataColumn Center Transparent True 2.8,0,4.4,0.5 Arial,8 55ff1b6453e44243b7a2f8f71132d94b 0,0,0,0 Texto11 {instruments.instrument_model_name} Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, DataColumn Center Transparent True 12.4,0,4.4,0.5 Arial,8 925aa0444f014d85b0aaa7f2de95446e 0,0,0,0 Texto13 {instruments.supplier_name} Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Center Transparent True 16.8,0,3.8,0.5 Arial,8 14434d2806484543a162cfc77322cf76 0,0,0,0 Text14 {instruments.last_calibration.ToString("dd/MM/yyyy")} Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Expression Center Transparent True 20.6,0,3.4,0.5 Arial,8 7aaa5275e9da4f429821944ca04a0178 0,0,0,0 Text16 {instruments.accreditation_name} Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, DataColumn Center Transparent True 24,0,3.7,0.5 Arial,8 f455ae3c8ed64651a973f1b24409e2d8 0,0,0,0 Text3 {instruments.customer_sector_name} Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, DataColumn Center Transparent 27.7,0,3.6,0.5 Arial,8 0,0,0,0 Text8 {VALUES.id_customer} Black DataColumn Center instruments 4ff43bd22711462995b5ce439e2347df dataBySector Odd ASC CODE Transparent 0,7.1,27.7,0.6 Transparent 23,0,4.7,0.6 Arial,8,Bold,Point,False,0 65237c56644e431083a8ddc12abaee3a Right 0,0,0,0 Texto16 Total de Instrumentos: {Count()} Black , . 12 2 R$ False 0,0,25.7,0.0254 DarkGray Black 1cb4240c2c1746f9816929e9925ce9c4 LinhaHorizontal3 Black 9405b380980e40de950015c1caf4efcb RodapéGrupo2 3e30e4ef03b342ac9baa44f2a1b8eaa9 1,1,1,1 Page1 Landscape 21 29.7 Arial,100 [50:0:0:0] System.Dll System.Drawing.Dll System.Windows.Forms.Dll System.Data.Dll System.Xml.Dll Stimulsoft.Controls.Dll Stimulsoft.Base.Dll Stimulsoft.Report.Dll Relatório de InstrumentosNEW 2/22/2016 3:18:02 PM 2/4/2016 5:59:35 PM C:\Users\vladimir\Desktop\relatorio_de_instrumentosNEW.mrt 31c5d1c55ce841dc9c39cb1bfd867a1b Relatório de InstrumentosNEW Centimeters 2013.1.1600 True CSharp