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
|
