I have a report where I am calculating top 5 call types. I brought all the records in my dataset and filtered them in my groups. Group1: Cdate(Arrival_Time.value).ToString("MM/yyyy") Sort by:- Arrival_Time Group2: Type Filter: [count(case_ID)], TOPN, 5 Group3: Item Sort by: Item Im my tablix I am able to get the right results "FOR EVERY DATE I AM DISPLAYING THE TOP 5 ITEMS BASED ON COUNT(case_ID)." I want to show the same thing on my chart, Any help on this.

If you have your table groups as Category group in Chart probebly it will workGaurav Gupta http://sqlservermsbiblog.blogspot.com/

I did that but I am getting top5 types in whole chart but I want it to sort Top5 by date.

Can you please try following go to category Properties --> Filter---> Add Filter-->Select Column--> Select Top N---> Type 5 This should work for you!!Gaurav Gupta http://sqlservermsbiblog.blogspot.com/

I have done that but, its not working. I have date on the category fields, Type on the series fileds and count(case_id) on the data fields. Filter: Count(Case_ID) TopN =5 And I tried to put a filter on Category it don't work And I tried to put a filter on Type it gives me the Top5 Types for the entire thing.

Hi Nick2012, We could achieve this requirement in chart control, since you want to display the same thing in chart as in table. Please follow these: 1. You need to drag the Group1 and Group2 datafields on chart’s category area 2. Then right-click the Group2->Select Category Group Properties 3. Switch to Filters->Click Add->Type in expression =Sum(Fields!OrderQuantity.Value,"Chart2_CategoryGroup1") Note: Here Chart2_CategoryGroup1 is group2’s group name. 4. Select the Integer type, Operator: TopN, value: =Cint(5) If this is not what your need, please give more information and designed report layout in the forum. Thanks, Challen Fu

I tried it didn't work.

Hi Nick2012, In my local environment, it works fine utilizing my reply. On the X-Axis, it only display Top 5 value. Since you mentioned that the reply didn't work, could you please give the layout the report following up the top steps, and what's your desined report's layout. If possible, you could give more detailed description about your requirement, which is a big help for us supply the further reply. Thanks, Challen Fu

Hi Challen~ I have a report where I am calculating top 5 call types. I brought all the records in my dataset and filtered them in my groups. My report items are: Type, Case_ID, Arrival_Time, Item Group1: Cdate(Arrival_Time.value).ToString("MM/yyyy") Sort by:- Arrival_Time Group2: Type Filter: [count(case_ID)], TOPN, 5 Group3: Item Sort by: Item Im my tablix I am able to get the right results "FOR EVERY DATE I AM DISPLAYING THE TOP 5 ITEMS BASED ON COUNT(case_ID)." For Example: 03/2010 *Exchange2003 *Windows logon *Other *MS Outlook *SAP Like wise for all available dates, because I am doing a filter on group 2 which is Type(dataset field). Now I want to show the samething on the chart. But I am not able to do it and it is giving me top5 Types among all the dates rather then doing it by each date.

Hi Nick2012, This requirement is very common, not difficult. I think the chart control could meet this demand completely. Based on your detail information, I notice that you could display top5 types among all the dates not each date, I think the root cause is from your filter, please make sure the filter is added on the Type group not Arrival_Time, to the expression, you should add the scope to the Count function, such as: =Count(Fields!case_ID.value,"Type"). Here "Type" is group2's group name. Thanks, Challen Fu

Hi Challen~ I am getting the following error: The filter expression for the grouping 'chart1_categorygroup2' has a scope parameter that is not valid for an aggregate function. The scope parameter must be set to string constant that is equal to either the name of a containing group, the name of containing data region, or the name of a dataset. This is what I am doing in the filter: =Count(Fields!CASE_ID_.Value,"Group2") TOPN =cint(5)

Hi Nick2012, Kindly reminding, please make sure the Scope name you gave is just group2's group name. The error you gave indicates that you give the incorrect scope name for the Count function, please have a check. Of course, you could utilize CountRows function, such as: =CountRows("GroupName")

Hi Nick2012, Kindly reminding, please make sure the Scope name you gave is just group2's group name. The error you gave indicates that you give the incorrect scope name for the Count function, please have a check. Of course, you could utilize CountRows function, such as: =CountRows("GroupName")

Hi Challen~ Cannot Evaluate the expression. This is the error I am getting.

HI Challen~ I am able to get the TOP5 based on your instructions, but I want to show the chart as a stacked column and at the bottom legend should show all the departments from the chart.

Since my reply help your original question, why unmark it ? if you have another question, you'd better create another thread.

Hi Challen~ I didn't see that, I might have checked it twice. Can you help me with the above thing.

Hi Challen~ I didn't see that, I might have checked it twice. Can you help me with the above thing.

Hi Challen~ I didn't see that, I might have checked it twice. Can you help me with the above thing.