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 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy