Interpretation MS SQL 9DCf60ZWMYVgW6zcdwBgTtHI2QJOaNOFaxol7OAlbWPdeOECXkuT5Wtc/YBhbKAqxVrRoWcDo5nLCNGcZFykcsRscQlGXNMJwhmh8cQB9i/RcMHjVV1LrUVJ+YRp7G1/wlS7oWJXS83tE+Xcw2ykKthg9ShPWXttRkSkxGcp9Y/y1tktWlZ78cxP 32058441ce354630a47c77995d5147b1 MS SQL Customer_Info Cust_Id,System.Int32 Cust_Name,System.String Adress,System.String Finans,System.String 30 1b2cb64424e94451b86059dca3ebc6d8 Customer_Info MS SQL -- Test request to fill customer data --Customer_Info_(DataSource)-- -- Customer List -- DECLARE @List_Customer table(Cust_Id INT, Cust_Name varchar(100)) INSERT INTO @List_Customer (Cust_Id, Cust_Name) SELECT 1, 'Customer_1' UNION SELECT 2, 'Customer_2' UNION SELECT 3, 'Customer_3' -- Customer Settings List -- DECLARE @List_Customer_Settings table(Settings_Id INT, Settings_Name varchar(100), Settings_Text_Info nvarchar(4000), Cust_Id INT ) INSERT INTO @List_Customer_Settings (Settings_Id, Settings_Name, Settings_Text_Info, Cust_Id) SELECT 1, 'Finans', 'At the expense of the funds received by the Customer from the compulsory medical insurance fund', 1 UNION SELECT 1, 'Finans', 'Payment under the Contract is made at the expense of funds received by the customer from TFOMS for 2020', 2 UNION SELECT 1, 'Finans', 'Funds received by the customer from the compulsory medical insurance fund, from the national budget, from funds from other income-generating activities.' , 3 UNION SELECT 2, 'Adress', 'C.B.D. Library, and Subscriptions Service,P.O Box 255,Plympton,South Australia 5038', 1 UNION SELECT 2, 'Adress', 'Troyka Limited, 799 College Street, Toronto, Ontario, Canada M8G IC7', 2 UNION SELECT 2, 'Adress', '14 Rue de Provigny, 94236 Cachan Cedex' , 3 SELECT lc.Cust_Id ,lc.Cust_Name ,(SELECT top 1 Settings_Text_Info FROM @List_Customer_Settings lcs WHERE lcs.Cust_Id = lc.Cust_Id AND lcs.Settings_Name = 'Adress') AS Adress ,(SELECT top 1 Settings_Text_Info FROM @List_Customer_Settings lcs WHERE lcs.Cust_Id = lc.Cust_Id AND lcs.Settings_Name = 'Finans') AS Finans FROM @List_Customer lc ORDER BY lc.Cust_Id EngineV2 0c7d98842bf24c7e8474bbf915a3f3a2 None;Black;2;Solid;False;4;Black Transparent Transparent 0,4,277,24 Red 0,0,50,24 All;Black;1;Solid;False;4;Black [247:150:70] True 0,4,50,4 Arial,9,Bold True 0,0,0,0 Finans_Label Finans Black ,,,,WordWrap=True,A=0 Expression All;Black;1;Solid;False;4;Black [146:205:220] True 0,8,50,4 Arial,9,Bold True 0,0,0,0 Adress_Label Adress Black ,,,,WordWrap=True,A=0 Expression All;Black;1;Solid;False;4;Black [204:193:217] True 0,0,50,4 Arial,9,Bold True 0,0,0,0 Customer_Name_Label Customer_Name Black ,,,,WordWrap=True,A=0 Expression CrossHeaderBand1 [146:208:80] 50,0,56,24 All;Black;1;Solid;False;4;Black [247:150:70] True 0,4,56,4 Arial,9,Bold True 0,0,0,0 Finans_Text {Line} - {Customer_Info.Finans} Black ,,,,WordWrap=True,A=0 Expression All;Black;1;Solid;False;4;Black [146:205:220] True 0,8,56,4 Arial,9,Bold True 0,0,0,0 Adress_Text {Line} - {Customer_Info.Adress} Black ,,,,WordWrap=True,A=0 Expression All;Black;1;Solid;False;4;Black [204:193:217] True 0,0,56,4 Arial,9,Bold True 0,0,0,0 Customer_Name_Text {Line} - {Customer_Info.Cust_Name} Black ,,,,WordWrap=True,A=0 Expression Customer_Info CrossDataBand2 DataBand2 True d95ca1de5a4c41a0a5501cd0894d5556 10,10,10,10 Page1 Landscape 210 297 A4 System.Dll System.Drawing.Dll System.Windows.Forms.Dll System.Data.Dll System.Xml.Dll Stimulsoft.Controls.Dll Stimulsoft.Base.Dll Stimulsoft.Report.Dll Cross_Data_test_v1 rvv 10/11/2021 3:53:08 PM 9/23/2019 4:00:43 PM Cross_Data_test_v1 D:\Tools\Requests_to_Support_StimulSoft\Cross_Data_test_v1.mrt 3d61ca90a0344ded896d1ea4b084d0bf Cross_Data_test_v1 Millimeters 2020.5.2.0 CSharp