Solved

SQL Reporting Svc Hiding Adjacent Records with Identical Amounts

Posted on 2006-06-09
2
350 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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Create dynamic SSRS connection string 10 206
Multi-Parameter Report SQL 2008 2 83
Can MSSQL 2008R2 database integrate with MSSQL 2012 6 75
bank transaction downloader ? 1 89
Hello, In my precious Article  (http://www.experts-exchange.com/Database/Reporting/A_15280-Create-Project-in-Microstrategy-Part-I.html)we saw the Configuration part for Microstrategy which included Metadata Creation and DataSource Preparation as …
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 video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…

856 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