<solved>In custom report, specialized SQL is not used for "Export CSV"

[SarahG (FountainTribe)]

I have written a custom report which overrides the function buildQuery( ) to create a very specialized SQL select statement.  This works fine when the end-user is viewing the results.   However, the custom SQL is NOT used when the user clicks "Export CSV" and so they get different results in the CSV file than they see on the screen.

Any ideas on how to get the "Export CSV" button/action to use the SQL that I create in the function "buildQuery"

[Erik Hommel]

Do you store your sql in the class variable ($this->sql)?

[SarahG (FountainTribe)]

Yes, I do have the line " $this->sql"  in my buildQuery()  function.

[Erik Hommel]

You need to check the export CSV function CRM_Report_Utils_Report::export2csv($this, $rows)

[SarahG (FountainTribe)]

Thanks for the help everyone. The export to CSV was calling my custom SQL. The problem existed elsewhere in the code