none
Sorting in matrix report according to its data avilabilty

    Dotaz

  •  

    this  is the excel  format of  my report , what i want  , is to sort  according to 

    data having in March , and then data having in Feb  month

    as it is done in excel,

    Can i do this type of sorting in SSRS ? 

    any help will highly  appreciated 




    17. března 2012 7:13

Všechny reakce

  • Hello,

    Follow the links below. It might help you.

    http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/6f014928-7e12-4de1-908d-45de3860849b

    http://www.bidn.com/blogs/MikeDavis/ssis/1527/ssrs-interactive-sorting-a-matrix

    http://forums.databasejournal.com/showthread.php?t=43937

    • Navržen jako odpověď VivelYano 19. března 2012 7:10
    • Zrušeno navržení jako odpověď VivelYano 19. března 2012 7:11
    17. března 2012 8:56
  • it doesn't sort according to data  , what i want is to sort like 

    all records of month march , and then all records of Feb without having records of 

    march ,and then it goes on with another months.

    In query it is working fine ,but i am not able to do it in report .

    19. března 2012 2:23
  • Hi Rohit_shukla,

    In Reporting Services, we can customize the sorting by writing an expression for a group. I suggest you that refer to the related threads about this, please see:
    http://social.technet.microsoft.com/Forums/en-US/sqlreportingservices/thread/b656293d-c0d4-48fb-adda-84c00b6103ba
    http://social.technet.microsoft.com/Forums/en-US/sqlreportingservices/thread/17aebf41-970e-4630-9ac1-fb810f21ad3a

    If you have any more questions, please feel free to ask.

    Regards,
    Bin Long

    Bin Long

    TechNet Community Support

    19. března 2012 2:24
  • Hi Bin Long ,

    its not working , 

    this is my matrix report , 

    • <<Expr>> is expression of month 
    • cust_cd  is  row
    • sum(total_aW) is the sum of particular cust_cd  in  in  months

    what i want is to all sum (aw) and cust_cd till month march 

    and then all sum with cust_cd till feb ,  as in above mentioned  excel ,

    please help 

    19. března 2012 5:42
  • Hi Rohit

    Could you please explain bit more on your sorting requirement. If you could share what it gives now and how you want it to be, it might be helpful.

    Thanks and regards

    Irshad


    Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful.

    BH

    19. března 2012 6:14
  • i am making a report ,showing customer's monthly sale , month wise ,
    the sorting  i want to  , is


    all sales till current month , then  sales till previous month

    like 

    19. března 2012 6:47
  • Hi,

    In your report, rows are sorted by customer and columns are by Year-Month. Maintaining this sorting do you want to apply a sort on the value, or you want to sort on the value disregarding the present sort on rows/columns. An example showing a wrong sorting and then how you want it corrected might more.

    Thanks and regards

    Irshad


    Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful.

    BH

    19. března 2012 6:52
  • how should  i take care of blank ' ' values ? 

    like 2nd and 3rd  row having blank value in march 2012 column

    Dec 2011 Jan 2011 Feb 2012 Mar 2012
    46 108 93 69
      1    
      1    
    9 21 19 12
      1 1 1
    15 20 17 13
      1 1  
      1   1
    6 12 8 7
      1 1  
        1  
    1      
      6 16 5

     

    19. března 2012 7:01
  • That indicates there were no records for customers in (row2 and row3). If you think about eliminating those rows, then you end up not showing any records for those customers (which i believe would annul the purpose of the report). Therefore I guess the sorting has to be done considering the design of the report.

    What I could suggest is to use the interactive column sorting option available in SSRS. By default, your report appears as it shows now in your last posting. Clicking on the 2012 March button would sort the by the values (ascending or descending). The same applies for other month columns as well.

    SSRS interactive sorting provides this feature. Please review the below

    SSRS 2005 interactive sortinghttp://weblogs.sqlteam.com/joew/archive/2008/08/02/60666.aspx

    SSRS 2008 interactive sortinghttp://www.bidn.com/blogs/briankmcdonald/bidn-blog/722/interactive-sort-order-using-reporting-services-2008

    Please check if this helps.


    Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful.

    BH

    19. března 2012 7:38