Solved

SQL Reporting Svc Hiding Adjacent Records with Identical Amounts

Posted on 2006-06-09
2
349 Views
Last Modified: 2012-05-05
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!
0
Comment
Question by:shammann
2 Comments
 
LVL 14

Accepted Solution

by:
simon_kirk earned 250 total points
ID: 16876259
Check that your detail level group doesn't have any field grouping in it.
0
 
LVL 11

Expert Comment

by:Ved Prakash Agrawal
ID: 16877225
hi you  first check out that you have used the details section or not.
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.

0

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Problem Statement In an SAP BI BO Integration project when a BO universe is built on a BEx query, there can be an issue of unit & formatted value objects not getting generated in a BO universe for some key figures. This results in an issue whereb…
Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

775 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question