Skip to main content
D
deeph2o360
Participant
March 24, 2008
Answered

Report Builder - detail shows twice CFMX7.0.2

  • March 24, 2008
  • 1 reply
  • 250 views
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.
This topic has been closed for replies.
Correct answer deeph2o360
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.

1 reply

D
deeph2o360AuthorCorrect answer
Participant
March 24, 2008
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.
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices