Suppress Repeating Values - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Transact-SQL (2008)

Suppress Repeating Values

Author

Topic

Chamark
Starting Member

28 Posts

Posted - 2010-08-17 : 13:05:33

Using SQL2008 - Beginner. I don't want to repeat the
same row name in my listing from a SQL statement. Column names are Category,KPI, Actual_YTD, Target_YTD.

Select Category, KPI, Actual_YTD, Target_YTD
Where Yearmonth = '06/01/2010'

List would look like this

Category KPI Actual_YTD Target_YTD
Profitability Income $$$ $$$
Profitability Cost $$$ $$$
Profitability Losses $$$ $$$
Satisfaction CEI %% %%
Satisfaction Clients %% %%
Satisfaction etc etc etc

Is there any way of only having Profitability & Satisfaction show once
instead of on each row? I know this should be done at the application layer - but I am using SSRS-2008 and don't know of a way to suppress repeating values. Any help is greatly appreciated

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-08-17 : 13:18:39

you can easily do this at your reporting tool. its called hide duplicates property in SQL reporting services

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Chamark
Starting Member

28 Posts

Posted - 2010-08-17 : 13:36:59

Hey Visakh16 - thanks for getting back to me - can you give me a little more detail on the "hide duplicates property" in SSRS - still getting up to speed with the application - are you referencing creating an Expression or is this a feature that can be checked? Thanks again

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-08-17 : 13:54:34

you can click on textbox and select properties. In properties tab, you've checkbox called hide duplicates

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Chamark
Starting Member

28 Posts

Posted - 2010-08-17 : 16:23:37

Thank you - I found it. Most Excellent

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources