March 3, 2010 at 11:10 am
Hi all , I am a Newbie...
I am Able to retieve Summarized data in one Dimension by SSRS. Now, I want to retieve data by using 2 dimensions in Triangle Format. Suggestions Please?
Thanks,
Sam
March 5, 2010 at 7:51 pm
Can you provide an example of what you are referring to? Not sure what you mean by triangle. Sounds like you just might want to use a matrix report item to display the data or if you are using SSRS 2008 a tablix.
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
March 6, 2010 at 9:02 am
Please Provide logic For the Following Scenario....
I really dont Understand, what to use...Either While Loop or Cursor or etc....I am weak at writing T SQL Logic.
acct yr 1 1+2 1+2+3 1+2+3+4 1+2+3+4+5 1+2+3+4+5+6 1+2+3+4+5+6+7 1+2+3+4+5+6+7+8 1+2+3+4+5+6+7+8+9 1+2+3+4+5+6+7+8+9+10
Paid loss yr
1 LINE0100 2000 77 454 460 460 460 460 460 460 460 460
2 LINE0100 2001 190 230 257 258 252 249 249 249 249
3 LINE0100 2002 317 432 438 438 438 438 438 438
4 LINE0100 2003 152 186 185 186 186 186 186
5 LINE0100 2004 57 99 104 105 105 104
6 LINE0100 2005 43 59 87 115 136
7 LINE0100 2006 208 218 223 224
8 LINE0100 2007 12 48 50
9 LINE0100 2008 6724 6731
10 LINE0100 2009 41
acct yr end 1 2 3 4 5 6 7 8 9 10
Resv loss qtr
1 LINE0100 2000 21 45 41 40 0 0 0 0 0 0
2 LINE0100 2001 5 5 1 0 0 0 0 0 0
3 LINE0100 2002 120 5 1 1 0 1 0 0
4 LINE0100 2003 17 5 0 1 0 1 0
5 LINE0100 2004 6 6 1 0 0 1
6 LINE0100 2005 6 3 0 0 0
7 LINE0100 2006 8 6 1 0
8 LINE0100 2007 7 2 1
9 LINE0100 2008 2 2
10 LINE0100 2009 7
acct yr 1 1+2 1+2+3 1+2+3+4 1+2+3+4+5 1+2+3+4+5+6 1+2+3+4+5+6+7 1+2+3+4+5+6+7+8 1+2+3+4+5+6+7+8+9 1+2+3+4+5+6+7+8+9+10
Incurr loss yr
1 LINE0100 2000 98 499 501 500 460 460 460 460 460 460
2 LINE0100 2001 195 235 258 258 252 249 249 249 249
3 LINE0100 2002 437 437 439 439 438 439 438 438
4 LINE0100 2003 169 191 185 187 186 187 186
5 LINE0100 2004 63 105 105 105 105 105
6 LINE0100 2005 49 62 87 115 136
7 LINE0100 2006 216 224 224 224
8 LINE0100 2007 19 50 51
9 LINE0100 2008 6726 6733
10 LINE0100 2009 48
I have these Columns:
LossYear, ASLC, paidAmt, Reserve.
From the Above Columns, I have to Calculate IncurredLoss.
IncurredLoss = (Paid+Reserve).... Should be calculated for each individual Cell....
Can someone Suggest me the Logic?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply