Need to theoretically how i can acheieve this in Report studio

[tarunkrdas2013]

There are 2 sub parts of my Report requirement as below:-

1) 4 cascading prompts in 4 list report suppose first list has A as cascading prompt when user clicks A other four columns b,c,d,e should be filtered then in second list report D is cascading prompt and user selects D then b,c,e should be ftered and  for third list report C is cascaded value prompt and user selects c then b ,e is filtered and in 4 th list report E is cascading prompt then only b is filtered ....how to achieve this ,????


2) Continuing from above ,finally in a  single  list report should have 4 columns first  column A with row values b,c,d,e and 2nd Column D with row values b,c,e and 3rd column as C with row values b,e and final 4th column as E with only value b how to achieve this ??