SQL Reporting Svc Hiding Adjacent Records with Identical Amounts
Posted on 2006-06-09
We have a problem with SQL Reporting services. We have a report with several summary lines (i.e. "Groups" in SQL Reporting Services). We have a query that returns some lines with adjacent amounts the same as one another, although other fields differ. When we run the query in the reporting services data design view, it returns correct results. However, when we run the report, either in preview or publish mode, only the first of the rows with identical amounts is showing. The summary line totals are correct, including the amounts from the lines that do not show, but we can't figure out how to get all of the detail lines to show. We don't have any checkmarks in any of the "hide duplicates" boxes, and in any case this should not apply as we have no grouping based on the amount field, and that's the only field that's the same in the adjacent records. Any advice??? Thanks!