Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Hide Duplicate rows Expand / Collapse
Author
Message
Posted Friday, August 25, 2006 9:19 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, June 23, 2014 12:24 PM
Points: 29, Visits: 39

I am creating a report based on a group value and hiding the duplicate values by clicking the hide property on the selected textbox. The report values are displayed in two rows. If in the same group there is a same record then I am not displaying it.

     Which works fine,but it is leaving a blank row all over the report. Please guide me as to how do I avoid the blank row if I am hiding duplicate values on a row.

example:

1 joeph test 111  222 red

      sample done works

2

      joseph   test works

 

If in the same group, if the 1st line repeats for the 2nd row then there is a blank row after hiding duplicates. I want to remove that blank row if row repeats for each group

Post #304144
Posted Monday, August 28, 2006 8:00 AM
SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Friday, May 18, 2007 3:36 PM
Points: 10,039, Visits: 1
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
Post #304444
Posted Monday, August 28, 2006 9:23 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, September 18, 2013 1:47 PM
Points: 70, Visits: 36

How about stripping out the duplicate entries before they ever get to Report Writer.  If using sql, could you use the distinct option???

Post #304472
Posted Wednesday, August 30, 2006 9:04 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Sunday, July 12, 2009 9:11 PM
Points: 70, Visits: 19
Probably a silly question, but you dont have a group header and/or a group footer line, do you?
Post #305224
Posted Thursday, August 31, 2006 7:34 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, June 23, 2014 12:24 PM
Points: 29, Visits: 39

It is not a silly question mr. Neil. If you have a answer please send it accross. I have a Header and a Footer and its on a legal paper. I am bifurcating my report values based on a group values. In a group I may have more than 1 row. I am displaying single record values in two rows,first row displays only description and 2nd row has all calculated values.

In a group if there two records with same description then I do not have to show same described values for the second record. For that I am hiding based on grouped values. Its working fine, but its leaving me a blank row(remember I told you I am displaying 1 record in 2 rows.).

I do not want to display that blank row. Please suggest.

 

 

 

 

Post #305332
Posted Thursday, August 31, 2006 12:21 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, February 14, 2008 2:21 PM
Points: 18, Visits: 3

Hi,

Usually, if you want to hide the entire detail row then best is to make sure all columns (field) in detail band must be set to hide duplicate row.  Also make sure to select the group (especially in case of multiple groups) while setting hide option on.

The other option could be is to eliminate the duplicates well at SQL data binding level.

Hope this helps.

Asif

Post #305472
Posted Thursday, April 4, 2013 12:12 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, June 27, 2013 3:40 AM
Points: 2, Visits: 14
Have you got solution to this problem? I am facing same issue. Someone please help.
Post #1438653
Posted Thursday, April 4, 2013 1:26 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, September 12, 2013 7:11 AM
Points: 2,612, Visits: 155
There is an option "Row Visibility" in SSRS, through which you can control the table row visibility. You can use the same expression to control that row visibility which causing you a problem.
Post #1438665
Posted Thursday, April 4, 2013 2:47 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, March 17, 2014 11:46 PM
Points: 17, Visits: 30
Hi,

The expression which is used to hide duplicate values, used that exp in Row visibility property.

= IIF([........Expression.....],True,False)
Post #1438683
Posted Thursday, April 4, 2013 2:55 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, June 27, 2013 3:40 AM
Points: 2, Visits: 14
Hello All,

Thanks for your immediate reply. I got the issue solved by using row visibility expression.
Thanks again for your support.
Post #1438688
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse