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.
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