How to get SQL generated in report
Is it somehow possible from within Delphi to get the SQL of a pipeline?
(Report Builder 9.02)
I need to pass SQL generated in report to TQuery component:
Query1.SQL.Text:= ppReport1.?????.SQL.Text
Thank you.
(Report Builder 9.02)
I need to pass SQL generated in report to TQuery component:
Query1.SQL.Text:= ppReport1.?????.SQL.Text
Thank you.
This discussion has been closed.
Comments
var
Comando_SQL: TdaSQLBuilder;
begin
Comando_SQL := TdaSQLBuilder.Create(ppReport1.DataPipeline.SQL);
Query1.SQL.Text:=Comando_Sql.SQL.GetMagicSQLText;
end;