Subqueries and sql_calc_found_rows

[krypto]

Just trying to create a report that displays a bunch of counts, and am hitting a problem with sql_calc_found_rows being added to select subqueries. If I try:

Code: [Select]

SELECT
    (SELECT
            count(ci.id)
        from
            civicrm_value_celebrant_info
            ) As CountOfIds

it becomes:

Code: [Select]

SELECT SQL_CALC_FOUND_ROWS
    (SELECT SQL_CALC_FOUND_ROWS
            count(ci.id)
        from
            civicrm_value_celebrant_info
            ) As CountOfIds

which throws an error. Is there a way to stop sql_calc_found_rows getting inserted? Or is there a better sql technique?

[krypto]

FYI I 'fixed' this by stripping everything complex out of the report and just using a basic template as per Case 1 at http://wiki.civicrm.org/confluence/display/CRMDOC/CiviReport+Reference.