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

Remove Specific Object in the Chart in SSRS Expand / Collapse
Author
Message
Posted Friday, November 8, 2013 8:27 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, June 9, 2014 1:21 AM
Points: 58, Visits: 191
Goal:
Display the chart without displaying "Bikes", "Bikes - Internet Sales Amount" and "Bikes - Internet Tax Amount". Please review at pictures.
However, "Bikes", "Bikes - Internet Sales Amount" and "Bikes - Internet Tax Amount" shall be available in the list but not in the chart.

Problem:
I do not know how to remove "Bikes", "Bikes - Internet Sales Amount" and "Bikes - Internet Tax Amount" in the chart.

Information:
*I'm using SQL server 2012
*The data source is SSAS from AdvenctureWorks.


SELECT NON EMPTY
{
[Measures].[Internet Standard Product Cost],
[Measures].[Internet Sales Amount],
[Measures].[Internet Total Product Cost],
[Measures].[Internet Tax Amount]
} ON COLUMNS,

NON EMPTY
{
([Customer].[Customer Geography].[Customer].ALLMEMBERS * [Product].[Product Categories].[Product].ALLMEMBERS )
} DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS
FROM
[Adventure Works] CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS




  Post Attachments 
b1.jpg (5 views, 980.13 KB)
b2.jpg (2 views, 569.89 KB)
Post #1512701
Posted Friday, November 8, 2013 2:49 PM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Friday, November 21, 2014 3:16 AM
Points: 86, Visits: 759
You can just add a filter on the Category in the chart.

I'd suggest you look up "data regions" in SSRS to help you understand the scope of filters and what will be affected. E.g. filtering the dataset would affect both the chart and the table, filtering the chart (which is a data region) will not affect the table, and visa versa.
Post #1512824
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse