OBJECT Report 80003 Disappearing Labels2 { OBJECT-PROPERTIES { Date=02/06/12; Time=20:28:57; Modified=Yes; Version List=; } PROPERTIES { } DATAITEMS { { PROPERTIES { DataItemTable=Table13; DataItemVarName=SalespersonPurchaser; PrintOnlyIfDetail=Yes; } SECTIONS { { PROPERTIES { SectionType=Body; SectionWidth=12900; SectionHeight=423; } CONTROLS { { 70000;TextBox ;0 ;0 ;1500 ;423 ;SourceExpr=Code; DataSetFieldName=Salesperson_Purchaser_Code } { 70002;TextBox ;1650 ;0 ;4500 ;423 ;SourceExpr=Name; DataSetFieldName=Salesperson_Purchaser_Name } } } } } { PROPERTIES { DataItemIndent=1; DataItemTable=Table18; DataItemVarName=Customer; DataItemLink=Salesperson Code=FIELD(Code); } SECTIONS { { PROPERTIES { SectionType=Body; SectionWidth=12900; SectionHeight=423; } CONTROLS { { 70004;TextBox ;900 ;0 ;1500 ;423 ;SourceExpr="No."; DataSetFieldName=Customer__No__ } { 70006;TextBox ;2550 ;0 ;4500 ;423 ;SourceExpr=Name; DataSetFieldName=Customer_Name } { 70008;TextBox ;7200 ;0 ;4500 ;423 ;SourceExpr=City; DataSetFieldName=Customer_City } } } } } { PROPERTIES { DataItemIndent=1; DataItemTable=Table23; DataItemVarName=Vendor; DataItemLink=Purchaser Code=FIELD(Code); } SECTIONS { { PROPERTIES { SectionType=Body; SectionWidth=12900; SectionHeight=423; } CONTROLS { { 70010;TextBox ;900 ;0 ;1500 ;423 ;SourceExpr="No."; DataSetFieldName=Vendor__No__ } { 70012;TextBox ;2550 ;0 ;4500 ;423 ;SourceExpr=Name; DataSetFieldName=Vendor_Name } { 70014;TextBox ;7200 ;0 ;4500 ;423 ;SourceExpr=City; DataSetFieldName=Vendor_City } } } } } { PROPERTIES { DataItemTable=Table2000000026; DataItemTableView=WHERE(Number=CONST(1)); DataItemVarName=CaptionsRTC; } SECTIONS { { PROPERTIES { SectionType=Body; SectionWidth=12900; SectionHeight=2538; } CONTROLS { { 70003;Label ;1650 ;0 ;4500 ;846 ;ParentControl=70002; VertAlign=Bottom; FontBold=Yes; MultiLine=Yes; DataSetFieldName=Salesperson_Purchaser_NameCaption } { 70001;Label ;0 ;0 ;1500 ;846 ;ParentControl=70000; VertAlign=Bottom; FontBold=Yes; MultiLine=Yes; DataSetFieldName=Salesperson_Purchaser_CodeCaption } { 70009;Label ;7050 ;1269 ;4500 ;423 ;ParentControl=70008; VertAlign=Bottom; FontBold=Yes; MultiLine=Yes; DataSetFieldName=Customer_CityCaption } { 70007;Label ;2400 ;1269 ;4500 ;423 ;ParentControl=70006; VertAlign=Bottom; FontBold=Yes; MultiLine=Yes; DataSetFieldName=Customer_NameCaption } { 70016;TextBox ;750 ;846 ;10800;423 ;HorzAlign=Left; FontBold=Yes; SourceExpr='Customers'; DataSetFieldName=Customers_ } { 70005;Label ;750 ;1269 ;1500 ;423 ;ParentControl=70004; VertAlign=Bottom; FontBold=Yes; MultiLine=Yes; DataSetFieldName=Customer__No__Caption } { 70015;Label ;7050 ;2115 ;4500 ;423 ;ParentControl=70014; VertAlign=Bottom; FontBold=Yes; MultiLine=Yes; DataSetFieldName=Vendor_CityCaption } { 70013;Label ;2400 ;2115 ;4500 ;423 ;ParentControl=70012; VertAlign=Bottom; FontBold=Yes; MultiLine=Yes; DataSetFieldName=Vendor_NameCaption } { 70017;TextBox ;750 ;1692 ;10800;423 ;HorzAlign=Left; FontBold=Yes; SourceExpr='Vendors'; DataSetFieldName=Vendors_ } { 70011;Label ;750 ;2115 ;1500 ;423 ;ParentControl=70010; VertAlign=Bottom; FontBold=Yes; MultiLine=Yes; DataSetFieldName=Vendor__No__Caption } } } } } } REQUESTFORM { PROPERTIES { Width=9020; Height=3410; } CONTROLS { } } REQUESTPAGE { PROPERTIES { } CONTROLS { } } CODE { BEGIN END. } RDLDATA { 5.71429cm DataSet_Result =Len(cStr(Fields!Salesperson_Purchaser_Code.Value)) =0 GreaterThan =Fields!Salesperson_Purchaser_Code.Value true
0.63492cm true =Fields!Vendor__No__.Value Vendor__No__ true =Fields!Vendor_Name.Value Vendor_Name true =Fields!Vendor_City.Value Vendor_City
0.63492cm 3 true =Last(Fields!Vendors_.Value, "DataSet_Result") Vendors_ 0.63492cm true =Last(Fields!Vendor__No__Caption.Value, "DataSet_Result") Vendor__No__Caption true =Last(Fields!Vendor_NameCaption.Value, "DataSet_Result") Vendor_NameCaption true =Last(Fields!Vendor_CityCaption.Value, "DataSet_Result") Vendor_CityCaption
1.26984cm 3.1746cm 6.45503cm 6.45503cm 3.80952cm2
0.63492cm true =Fields!Customer__No__.Value Customer__No__ true =Fields!Customer_Name.Value Customer_Name true =Fields!Customer_City.Value Customer_City
0.63492cm 3 true =Last(Fields!Customers_.Value, "DataSet_Result") Customers_ 0.63492cm true =Last(Fields!Customer__No__Caption.Value, "DataSet_Result") Customer__No__Caption true =Last(Fields!Customer_NameCaption.Value, "DataSet_Result") Customer_NameCaption true =Last(Fields!Customer_CityCaption.Value, "DataSet_Result") Customer_CityCaption
1.90476cm1.26984cm 3.1746cm 6.45503cm 6.45503cm 1.90476cm1
0.63492cm 2 true Salesperson / Purchaser 0.63492cm true =Last(Fields!Salesperson_Purchaser_CodeCaption.Value, "DataSet_Result") Salesperson_Purchaser_CodeCaption true =Last(Fields!Salesperson_Purchaser_NameCaption.Value, "DataSet_Result") Salesperson_Purchaser_NameCaption 0.63492cm true =Last(Fields!Salesperson_Purchaser_Code.Value) Salesperson_Purchaser_Code true =Last(Fields!Salesperson_Purchaser_Name.Value) Salesperson_Purchaser_Name_1
1.90476cm 3.1746cm 6.45503cm 9.62963cm
2cm Public Function BlankZero(ByVal Value As Decimal) if Value = 0 then Return "" end if Return Value End Function Public Function BlankPos(ByVal Value As Decimal) if Value > 0 then Return "" end if Return Value End Function Public Function BlankZeroAndPos(ByVal Value As Decimal) if Value >= 0 then Return "" end if Return Value End Function Public Function BlankNeg(ByVal Value As Decimal) if Value < 0 then Return "" end if Return Value End Function Public Function BlankNegAndZero(ByVal Value As Decimal) if Value <= 0 then Return "" end if Return Value End Function Salesperson_Purchaser_Code Salesperson_Purchaser_Name Customer__No__ Customer_Name Customer_City Customer_Salesperson_Code Vendor__No__ Vendor_Name Vendor_City Vendor_Purchaser_Code Salesperson_Purchaser_NameCaption Salesperson_Purchaser_CodeCaption Customer_CityCaption Customer_NameCaption Customers_ Customer__No__Caption Vendor_CityCaption Vendor_NameCaption Vendors_ Vendor__No__Caption DummyDataSource DataSet Result SQL c12c2459-0ad5-4dcf-a151-7ef2e3c4e25b 29.7cm 14.5cm =User!Language 2.1cm 29.7cm 14.5cm 2cm 17.3545cm true 24317cc3-38ad-4f5e-ba30-e9113ffde13d true
END_OF_RDLDatA } }