{"CalculationMode":"Interpretation","Dictionary":{"DataSources":{"0":{"Alias":"pur","Columns":{"0":{"Alias":"id","Index":-1,"Name":"id","NameInSource":"id","Type":"System.String"},"1":{"Alias":"price","Index":-1,"Name":"price","NameInSource":"price","Type":"System.String"},"2":{"Alias":"user_id","Index":-1,"Name":"user_id","NameInSource":"user_id","Type":"System.String"}},"Ident":"StiPostgreSQLSource","Name":"pur","NameInSource":"c1","SqlCommand":"select id, user_id, price\r\nfrom purchases\r\nwhere user_id in ({users}) and status = {status}\r\nlimit 5"},"1":{"Alias":"comp","Columns":{"0":{"Alias":"name","Index":-1,"Name":"name","NameInSource":"name","Type":"System.String"},"1":{"Alias":"id","Index":-1,"Name":"id","NameInSource":"id","Type":"System.String"}},"Ident":"StiPostgreSQLSource","Name":"comp","NameInSource":"c1","SqlCommand":"select id, name\r\nfrom companies\r\nwhere id in (100, 200)"},"2":{"Alias":"l","Columns":{"0":{"Alias":"id","Index":-1,"Name":"id","NameInSource":"id","Type":"System.String"},"1":{"Alias":"lot_number","Index":-1,"Name":"lot_number","NameInSource":"lot_number","Type":"System.String"}},"Ident":"StiPostgreSQLSource","Name":"l","NameInSource":"c1","SqlCommand":"select id, lot_number\r\nfrom lots\r\nwhere company_id = {org} and lot_number != ''\r\norder by id desc\r\nlimit 5","Type":"Table"},"3":{"Alias":"org1","Columns":{"0":{"Alias":"name","Index":-1,"Name":"name","NameInSource":"name","Type":"System.String"},"1":{"Alias":"id","Index":-1,"Name":"id","NameInSource":"id","Type":"System.String"}},"Ident":"StiPostgreSQLSource","Name":"org1","NameInSource":"c1","SqlCommand":"select c.id, c.name\r\nfrom lots as l\r\njoin companies as c on l.company_id = c.id\r\ngroup by c.id\r\nhaving count(c.id) > 10\r\norder by count(c.id) desc","Type":"Table"}},"Databases":{"0":{"Alias":"c1","Ident":"StiPostgreSQLDatabase","Name":"c1"}},"Variables":{"0":{"Alias":"users","DialogInfo":{"DateTimeType":"DateAndTime"},"InitBy":"Expression","Name":"users","ReadOnly":true,"Type":"System.String","Value":"IIF(users_pre.Count == 0, 100, users_pre.ToQueryString())"},"1":{"Alias":"users_pre","DialogInfo":{"AllowUserValues":false,"DateTimeType":"DateAndTime","ItemsInitializationType":"Columns","KeysColumn":"comp.id","ValuesColumn":"comp.name"},"Name":"users_pre","RequestFromUser":true,"Type":"Stimulsoft.Report.IntList"},"2":{"Alias":"status","DialogInfo":{"DateTimeType":"DateAndTime"},"Name":"status","RequestFromUser":true,"Type":"System.Int32","Value":"0"},"3":{"Alias":"org","DialogInfo":{"DateTimeType":"DateAndTime"},"InitBy":"Expression","Name":"org","ReadOnly":true,"Type":"System.String","Value":"IIF(org_pre.Count == 0, 100, org_pre.ToQueryString())"},"4":{"Alias":"org_pre","DialogInfo":{"AllowUserValues":false,"DateTimeType":"DateAndTime","ItemsInitializationType":"Columns","KeysColumn":"org1.id","ValuesColumn":"org1.name"},"Name":"org_pre","RequestFromUser":true,"Type":"Stimulsoft.Report.StringList"}}},"EngineVersion":"EngineV2","Pages":{"0":{"Border":";;2;;;;;solid:Black","Brush":"solid:Transparent","Components":{"0":{"Border":";;;;;;;solid:Black","Brush":"solid:Transparent","ClientRectangle":"0,0.4,19,1.6","ColumnCount":3,"Components":{"0":{"Border":"All;105,105,105;;;;;;solid:105,105,105","Brush":"solid:Transparent","ClientRectangle":"0,0,6.33,0.8","Guid":"a7a7decddba558968609cdb9ae5d55ba","ID":0,"Ident":"StiTableCell","Interaction":{"Ident":"StiInteraction"},"Name":"Tablea_Cell1","Restrictions":"AllowMove, AllowSelect, AllowChange","Text":{"Value":"id"},"TextBrush":"solid:Black"},"1":{"Border":"All;105,105,105;;;;;;solid:105,105,105","Brush":"solid:Transparent","ClientRectangle":"6.33,0,6.33,0.8","Guid":"d43bdd07bddcaaf8c1b4c8e2e7972e91","ID":1,"Ident":"StiTableCell","Interaction":{"Ident":"StiInteraction"},"Name":"Tablea_Cell2","Restrictions":"AllowMove, AllowSelect, AllowChange","Text":{"Value":"price"},"TextBrush":"solid:Black"},"2":{"Border":"All;105,105,105;;;;;;solid:105,105,105","Brush":"solid:Transparent","ClientRectangle":"12.67,0,6.33,0.8","Guid":"da02e70c330f66d42a21db58cf6ee748","ID":2,"Ident":"StiTableCell","Interaction":{"Ident":"StiInteraction"},"Name":"Tablea_Cell3","Restrictions":"AllowMove, AllowSelect, AllowChange","Text":{"Value":"user_id"},"TextBrush":"solid:Black"},"3":{"Border":"All;105,105,105;;;;;;solid:105,105,105","Brush":"solid:Transparent","ClientRectangle":"0,0.8,6.33,0.8","Guid":"ec763cd707fdaebc8c28c56693761239","ID":3,"Ident":"StiTableCell","Interaction":{"Ident":"StiInteraction"},"Name":"Tablea_Cell4","Restrictions":"AllowMove, AllowSelect, AllowChange","Text":{"Value":"{pur.id}"},"TextBrush":"solid:Black"},"4":{"Border":"All;105,105,105;;;;;;solid:105,105,105","Brush":"solid:Transparent","ClientRectangle":"6.33,0.8,6.33,0.8","Guid":"ec8d64c36ad5690258c57b425ca150a5","ID":4,"Ident":"StiTableCell","Interaction":{"Ident":"StiInteraction"},"Name":"Tablea_Cell5","Restrictions":"AllowMove, AllowSelect, AllowChange","Text":{"Value":"{pur.price}"},"TextBrush":"solid:Black"},"5":{"Border":"All;105,105,105;;;;;;solid:105,105,105","Brush":"solid:Transparent","ClientRectangle":"12.67,0.8,6.33,0.8","Guid":"830eaa58a63a257b58f33c7ccf691c6e","ID":5,"Ident":"StiTableCell","Interaction":{"Ident":"StiInteraction"},"Name":"Tablea_Cell6","Restrictions":"AllowMove, AllowSelect, AllowChange","Text":{"Value":"{pur.user_id}"},"TextBrush":"solid:Black"}},"DataSourceName":"pur","HeaderRowsCount":1,"Ident":"StiTable","Interaction":{"Ident":"StiBandInteraction"},"MinHeight":0.4,"Name":"Tablea","NumberID":6,"RowCount":2},"1":{"Border":";;;;;;;solid:Black","Brush":"solid:Transparent","ClientRectangle":"0,2.8,19,0.8","Ident":"StiHeaderBand","Interaction":{"Ident":"StiInteraction"},"Name":"HeaderBand1"},"2":{"Border":"All;;;;;;;solid:0,0,0","Brush":"solid:Transparent","ClientRectangle":"0,4.4,19,1.6","ColumnCount":2,"Components":{"0":{"Border":"All;105,105,105;;;;;;solid:105,105,105","Brush":"solid:Transparent","ClientRectangle":"0,0,9.5,0.8","Guid":"1785b7e68354dbedb9a99199ea2491f3","ID":0,"Ident":"StiTableCell","Interaction":{"Ident":"StiInteraction"},"Name":"Tablep_Cell1","Restrictions":"AllowMove, AllowSelect, AllowChange","Text":{"Value":"id"},"TextBrush":"solid:Black"},"1":{"Border":"All;105,105,105;;;;;;solid:105,105,105","Brush":"solid:Transparent","ClientRectangle":"9.5,0,9.5,0.8","Guid":"eb5df5cceef599d8527d6b0758ce651f","ID":1,"Ident":"StiTableCell","Interaction":{"Ident":"StiInteraction"},"Name":"Tablep_Cell2","Restrictions":"AllowMove, AllowSelect, AllowChange","Text":{"Value":"lot_number"},"TextBrush":"solid:Black"},"2":{"Border":"All;105,105,105;;;;;;solid:105,105,105","Brush":"solid:Transparent","ClientRectangle":"0,0.8,9.5,0.8","Guid":"cec3649dcf8c0962262b6c483a78c13f","ID":2,"Ident":"StiTableCell","Interaction":{"Ident":"StiInteraction"},"Name":"Tablep_Cell3","Restrictions":"AllowMove, AllowSelect, AllowChange","Text":{"Value":"{l.id}"},"TextBrush":"solid:Black"},"3":{"Border":"All;105,105,105;;;;;;solid:105,105,105","Brush":"solid:Transparent","ClientRectangle":"9.5,0.8,9.5,0.8","Guid":"a9bed27df2577fac47b3e1a3a4f25c26","ID":3,"Ident":"StiTableCell","Interaction":{"Ident":"StiInteraction"},"Name":"Tablep_Cell4","Restrictions":"AllowMove, AllowSelect, AllowChange","Text":{"Value":"{l.lot_number}"},"TextBrush":"solid:Black"}},"DataSourceName":"l","HeaderRowsCount":1,"Ident":"StiTable","Interaction":{"Ident":"StiBandInteraction"},"MinHeight":0.4,"Name":"Tablel","NumberID":4,"RowCount":2}},"Guid":"7f430a29ec7366a4876340a93b962d3e","Ident":"StiPage","Interaction":{"Ident":"StiInteraction"},"Margins":{"Bottom":1,"Left":1,"Right":1,"Top":1},"Name":"Page1","PageHeight":29.7,"PageWidth":21,"Watermark":{"TextBrush":"solid:50,0,0,0"}}},"PreviewSettings":268435455,"ReportAlias":"Report","ReportChanged":"/Date(10800000+0300)/","ReportCreated":"/Date(10800000+0300)/","ReportFile":"test_applics.mrt","ReportGuid":"2456303f0dffd85c1defe3b93b30d1b9","ReportName":"Report","ReportUnit":"Centimeters","ReportVersion":"2019.4.3"}