Report Builder - detail shows twice CFMX7.0.2

[deeph2o360]

I've encountered an odd issue with the Report Builder. Every time I create a report with a subreport inserted into the main report my detail gets generated twice on the report. I've even verified that the queries run twice on the SQL Server watching it in profiler. I'm not sure what happend but this now happens to all my reports and it's become very frustrating.

It does not matter if I change the report format to PDF, Flashpaper, Excel or Word.

[deeph2o360 · Accepted solution]

Figured out my problem. Took another look at my query for the master records and found out that the header was returning 2 records when it was only supposed to be returning 1. Ended up adding a SELECT TOP 1 to the query to limit it to one record.