Hi, I could open my query result as a spreadsheet document in a separate window, but I need to place it on a data processor form. How can I do that? Here is my script:
Code |
---|
&AtClient Procedure Create(Command) SpreadsheetDocument = CreateServer(Period); SpreadsheetDocument.Show("Report by counterparties"); EndProcedure &AtServer Function CreateServer(Period) Query = New Query; Query.Text = "SELECT | SUM(MutualSettlementsBalance.AmountBalance) AS Amount, | MutualSettlementsBalance.Counterparty AS Counterparty |FROM | AccumulationRegister.MutualSettlements.Balance(&Period, ) AS MutualSettlementsBalance | |GROUP BY | MutualSettlementsBalance.Counterparty"; Query.SetParameter("Period", Period); QueryResult = Query.Execute(); SelectionDetailRecords = QueryResult.Choose(); SpreadsheetDocument = New SpreadsheetDocument(); Template = GetCommonTemplate("Template"); DataArea = Template.GetArea("Data"); While SelectionDetailRecords.Next() Do DataArea.Parameters.Counterparty = SelectionDetailRecords.Counterparty; DataArea.Parameters.Amount = SelectionDetailRecords.Amount; SpreadsheetDocument.Put(DataArea); EndDo; Return SpreadsheetDocument; EndFunction |