May 13, 2011 at 8:21 am
Hi Friends,
I have a question regarding which report layout should be used to display the following format using ssrs 2008
parameter1
this report will be displayed based on the selected parameter.
FY1 FY2FY3FY4FY5
COL1 $amount$amount$amount$amount$amount
COL2 $amount$amount$amount$amount$amount
COL3 $amount$amount$amount$amount$amount
COL4 $amount$amount$amount$amount$amount
COL5 $amount$amount$amount$amount$amount
Plz let me know if someone have any ideas how to get this format.
Thanks for you help
disha
May 13, 2011 at 8:26 am
Can you show some sample data and the expected output... I'm not too sure of what you want.
May 13, 2011 at 8:36 am
You mean having something called 'COL' on the rows doesn't make sense Ninja? aww, come-on....
Steve.
May 13, 2011 at 8:39 am
stevefromOZ (5/13/2011)
You mean having something called 'COL' on the rows doesn't make sense Ninja? aww, come-on....
It does but I'm wondering where to make the pivot :w00t:.
Yes I do have users like that here too!
May 13, 2011 at 9:09 am
col1 and col2 col3 are revenue columns, like net and gross revenues in the dollor amounts.
May 13, 2011 at 9:15 am
dsh_roy (5/13/2011)
col1 and col2 col3 are revenue columns, like net and gross revenues in the dollor amounts.
So this is like a revenue type column?
Make sure you get all the values into a single column then do a row group.
If you also need to group on columns you'll need to use a matrix if not then a tablix could do the trick.
May 13, 2011 at 9:17 am
($0.00) FY1FY2FY3FY4
Net revenue$10,003$20,876$25,000$28,000
Gross Revenue$12,000$24,000$15,000$12000
May 13, 2011 at 9:27 am
Thanks for your reply.
But I did not get exacly, could you plz give an simple example..
Thanks alot
disha
May 13, 2011 at 9:30 am
You must have your data like this :
gross fy1, fy2, fy3....
net fy1....
Create a new group on rows on group on the column that contains the run type. Then dislay the sum() for the 4-5 other columns
May 13, 2011 at 9:45 am
Ok. I will try it out as you said.
Thanks alot for your help
Disha
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply