shammann
asked on
SQL Reporting Svc Hiding Adjacent Records with Identical Amounts
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!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
used the grouping and placed the gouping column into this groups and place other details corresponding to this group into details section.
if this not solved you problem then tell my how you have create the report so that i can understand where you have do something wrong.