Solved

SQL Reporting Svc Hiding Adjacent Records with Identical Amounts

Posted on 2006-06-09
2
352 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

[Webinar] How Hackers Steal Your Credentials

Do You Know How Hackers Steal Your Credentials? Join us and Skyport Systems to learn how hackers steal your credentials and why Active Directory must be secure to stop them. Thursday, July 13, 2017 10:00 A.M. PDT

Question has a verified solution.

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

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…
Hi, I am very much excited today since I'm going to share something very exciting Tool used for Analytical Reporting and that's nothing but MICROSTRATEGY. Actually there are lot of other tools available in the market for Reporting Such as Co…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…

717 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