Sorting in matrix report according to its data avilabilty

Question

 

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 

Answer 1

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

Answer 2

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 .

Answer 3

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

Answer 4

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 

Answer 5

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

Answer 6

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 

Answer 7

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

Answer 8

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

 

Answer 9

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 sorting - http://weblogs.sqlteam.com/joew/archive/2008/08/02/60666.aspx

SSRS 2008 interactive sorting - http://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