if (NO_DATA) { DATE_FROM = DateTime.MaxValue; DATE_TO = DateTime.MinValue; } OracleRP_RP OracleRP_RP F_REPORT_AR_08 CUSTOMER_NUMBER,System.String CUSTOMER_NAME,System.String ACCOUNT_TYPE,System.String ACCOUNT_NUMBER,System.String BILL_NUMBER,System.String BILL_ISSUER_NAME,System.String TOTAL_AMOUNT,System.Decimal AMOUNT_TO_PAY,System.Decimal ADDRESS_STREET,System.String ADDRESS_PSC,System.String ADDRESS_TOWN,System.String ADDRESS_STATE,System.String DATE_OF_ISSUE,System.DateTime DUE_DATE,System.DateTime DATE_OF_PAYMENT,System.DateTime 30 F_REPORT_AR_08 OracleRP_RP :PARAM1,DATE_FROM.ToUniversalTime_x0028__x0029_,106,0 :PARAM2,DATE_TO.AddMinutes_x0028_1_x0029_.ToUniversalTime_x0028__x0029_,106,0 :PARAM3,GetListAsString_x0028_ISSUE_TO_PAID_DAYS_x0029_,126,0 :PARAM4,GetListAsString_x0028_BILL_ISSUER_x0029_,126,0 :PARAM5,GetListAsString_x0028_ACCOUNT_TYPE_x0029_,126,0 select * from table(ar_reports_pkg.rp_ar_08_body('SK', :PARAM1, :PARAM2, :PARAM3, :PARAM4, :PARAM5)) ,DATE_FROM,Dátum_x0020_vystavenia_x0020_faktúry_x0020_od,System.DateTime,GetDefaultDateFrom_x0028__x0029_,False,True ,DATE_TO,Dátum_x0020_vystavenia_x0020_faktúry_x0020_do,System.DateTime,GetDefaultDateTo_x0028__x0029_,False,True ,BILL_ISSUER,Vydavateľ_x0020_faktúry,,Stimulsoft.Report.LongList,,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_BILL_ISSUER_TABLE.ID_x003C__x002F_KeysColumn_x003E__x003C_ValuesColumn_x003E_BILL_ISSUER_TABLE.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_ ,ACCOUNT_TYPE,Typ_x0020_MÚ,,Stimulsoft.Report.LongList,,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_ACCOUNT_TYPE_TABLE.ID_x003C__x002F_KeysColumn_x003E__x003C_ValuesColumn_x003E_ACCOUNT_TYPE_TABLE.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_ ,ISSUE_TO_PAID_DAYS,Počet_x0020_dní_x0020_od_x0020_vystavenia_x0020_faktúry_x0020_do_x0020_zaplatenia,,Stimulsoft.Report.LongList,,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_ISSUE_TO_PAID_DAYS_TABLE.ID_x003C__x002F_KeysColumn_x003E__x003C_ValuesColumn_x003E_ISSUE_TO_PAID_DAYS_TABLE.INTERVAL_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_ ,OUTPUT,OUTPUT,System.String,xls,False,False ,NO_DATA,NO_DATA,System.Boolean,false,False,False if (NO_DATA) { DATE_FROM = GetDefaultDateFrom(); DATE_TO = GetDefaultDateTo(); } EngineV2 None;Black;2;Solid;False;4;Black Transparent Transparent False 0,0.4,27.7,0.4 All;Black;1;Solid;False;4;Black Transparent 0,0,1.8,0.4 Tahoma,8 Center 0,0,0,0 DataF_REPORT_AR_08_CUSTOMER_NUMBER {F_REPORT_AR_08.CUSTOMER_NUMBER} Black Center All;Black;1;Solid;False;4;Black Transparent 1.8,0,2.9,0.4 Tahoma,8 Center 0,0,0,0 DataF_REPORT_AR_08_CUSTOMER_NAME {F_REPORT_AR_08.CUSTOMER_NAME} Black Center All;Black;1;Solid;False;4;Black Transparent 4.7,0,1.6,0.4 Tahoma,8 Center 0,0,0,0 DataF_REPORT_AR_08_ACCOUNT_TYPE {F_REPORT_AR_08.ACCOUNT_TYPE} Black Center All;Black;1;Solid;False;4;Black Transparent 6.3,0,1.8,0.4 Tahoma,8 Center 0,0,0,0 DataF_REPORT_AR_08_ACCOUNT_NUMBER {F_REPORT_AR_08.ACCOUNT_NUMBER} Black Center All;Black;1;Solid;False;4;Black Transparent 8.1,0,1.8,0.4 Tahoma,8 Center 0,0,0,0 DataF_REPORT_AR_08_BILL_NUMBER {F_REPORT_AR_08.BILL_NUMBER} Black Center All;Black;1;Solid;False;4;Black Transparent 9.9,0,2.4,0.4 Tahoma,8 Center 0,0,0,0 DataF_REPORT_AR_08_BILL_ISSUER_NAME {F_REPORT_AR_08.BILL_ISSUER_NAME} Black Center All;Black;1;Solid;False;4;Black Transparent 12.3,0,1.8,0.4 Tahoma,8 Center 0,0,0,0 DataF_REPORT_AR_08_TOTAL_AMOUNT {Format("{0:N2}", F_REPORT_AR_08.TOTAL_AMOUNT)} € Black Expression Center All;Black;1;Solid;False;4;Black Transparent 14.1,0,1.8,0.4 Tahoma,8 Center 0,0,0,0 DataF_REPORT_AR_08_AMOUNT_TO_PAY {Format("{0:N2}", F_REPORT_AR_08.AMOUNT_TO_PAY)} € Black Expression Center All;Black;1;Solid;False;4;Black Transparent 15.9,0,2,0.4 Tahoma,8 Center 0,0,0,0 DataF_REPORT_AR_08_ADDRESS_STREET {F_REPORT_AR_08.ADDRESS_STREET} Black Center All;Black;1;Solid;False;4;Black Transparent 17.9,0,1,0.4 Tahoma,8 Center 0,0,0,0 DataF_REPORT_AR_08_ADDRESS_PSC {F_REPORT_AR_08.ADDRESS_PSC} Black Center All;Black;1;Solid;False;4;Black Transparent 18.9,0,2,0.4 Tahoma,8 Center 0,0,0,0 DataF_REPORT_AR_08_ADDRESS_TOWN {F_REPORT_AR_08.ADDRESS_TOWN} Black Center All;Black;1;Solid;False;4;Black Transparent 20.9,0,2,0.4 Tahoma,8 Center 0,0,0,0 DataF_REPORT_AR_08_ADDRESS_STATE {F_REPORT_AR_08.ADDRESS_STATE} Black Center All;Black;1;Solid;False;4;Black Transparent 22.9,0,1.6,0.4 Tahoma,8 Center 0,0,0,0 DataF_REPORT_AR_08_DATE_OF_ISSUE {Format("{0:dd.MM.yyyy}", F_REPORT_AR_08.DATE_OF_ISSUE.ToLocalTime())} Black Expression Center All;Black;1;Solid;False;4;Black Transparent 24.5,0,1.6,0.4 Tahoma,8 Center 0,0,0,0 DataF_REPORT_AR_08_DUE_DATE {Format("{0:dd.MM.yyyy}", F_REPORT_AR_08.DUE_DATE.ToLocalTime())} Black Expression Center All;Black;1;Solid;False;4;Black Transparent 26.1,0,1.6,0.4 Tahoma,8 Center 0,0,0,0 DataF_REPORT_AR_08_DATE_OF_PAYMENT {F_REPORT_AR_08["DATE_OF_PAYMENT"] != DBNull.Value? Format("{0:dd.MM.yyyy}", F_REPORT_AR_08.DATE_OF_PAYMENT.ToLocalTime()) : ""} Black Expression Center F_REPORT_AR_08 False DataF_REPORT_AR_08 ASC CUSTOMER_NAME ASC ACCOUNT_NUMBER ASC BILL_NUMBER 535418345edd479586efbc19eaadd5cd True 2 1,1,1,1 Page1 Landscape 21 29.7 A4 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 RP.AR.08 3/20/2013 10:10:11 AM 8/27/2012 4:11:29 PM C:\Users\balga.STROM\Desktop\TOIS_DB\Blob_files_RP\RP.AR.08_new2.mrt 31ac95de8d2e4b569ccc28e85952a0f2 RP.AR.08 Centimeters 2013.1.1512 CSharp