Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2012 Forums
 Analysis Server and Reporting Services (2012)
 Diff between cells in matrix report at runtime

Author  Topic 

learntsql

524 Posts

Posted - 2015-02-27 : 00:48:03
i All,

I am implementing matrx report as below.

In matrix Rows i am displaying member names and in columns section displaying phases.
in values section i have to display difference in days between two phases dates.

for example if the dataset is like below

Member-Phase-Date
M1-P1-1/jan/2014
M1-P2-2/Jan/2014
M1-P3-5/jan/2014
M1-P4-10/Jan/2014
M2-P1-5/jan/2014
M2-P2-10/Jan/2014
M2-P3-15/jan/2014
M2-P4-30/Jan/2014


then my matrix report should look like below

P1-P2-P3-P4
M1 0- 1 -3 -5
M2 0- 5 -5 -15
.
.
.

can you please guide me how to achive this in matrix report dynamically

TIA.

learntsql

524 Posts

Posted - 2015-02-27 : 08:36:14
Hi All,

Any ideas on previous query.

Please let me know if we can mange it in sql.

TIA.
Go to Top of Page

learntsql

524 Posts

Posted - 2015-02-28 : 01:28:31
Hi All,

I handled in SQL using self join and Ranking functions.

Please let me know if we can do this in report side(rdl).

TIA.
Go to Top of Page

huangchen
Starting Member

37 Posts

Posted - 2015-04-02 : 05:57:54
unspammed
Go to Top of Page
   

- Advertisement -