locked
Filtering on group in ssrs 2005 RRS feed

  • Question

  • User1347670090 posted

    Hi,

    I am desinging the report in ssrs 2005.

    I used table control to display data.

    I have three columns col1,col2 and col3.

    Col2 and col3 are grouped on Col1 where as Col1 is monthend_date

    My result should be like this

    10/31/2010

                       xxxx      xxxx

                       yyyy      yyyy

    11/30/2010

                      zzzz     zzzz

                     aaaa     aaaa

    I will give the date range as parameters from 10/31/2010 to 11/30/2010

    For each monthend there are many number of records. But i want to display only top 2 records for each monthend as mentioned above.

    I did grouping on monthend_date. I tried all options by applying  filter on group as well as details. But i did not get the result.

    I used the filter condition as =Fields.monthend_date TOPN =2. One way i can get it by using TOP N in select query. But i can't change the existing query as it is using by some other reports

    Can any one suggest me that would be great help for me.

    Wednesday, December 22, 2010 4:51 AM

Answers

  • User1471008070 posted

    Hi,

    You could achieve this in reporting services, since you want to display only top 2 record in the second group, so just add a filter to the second group.  I think your issue might locate in the incorrect datafield, you should select the data datafield not =Fields.monthend_date. Please have a try, and give the feedback.

    Thanks,
    Challen Fu  

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Thursday, December 23, 2010 4:52 AM