December 16, 2012 at 6:59 pm
In the attached xls i have the data and the desired format of the report in ssrs 2008 R2
I have region when i drill down i should get state when i drill down i should get product..
Now here based on product i should group/display it ..
List of products p1,p2,p3,p4
P1 & P4 should be displayed together
P2 & P3 should be displayed together
if its P1,P4 it shouldnt consider type column and display sales for both types together..
If its p2,p3 it should consider type and should display by type for each product as in xls..
Please let me know if needed additional details..Thanks in advance
Thanks,
Chinna
Its the Journey which gives you Happiness not the Destination-- Dan Millman
December 17, 2012 at 9:00 am
Sri8143 (12/16/2012)
In the attached xls i have the data and the desired format of the report in ssrs 2008 R2I have region when i drill down i should get state when i drill down i should get product..
Now here based on product i should group/display it ..
List of products p1,p2,p3,p4
P1 & P4 should be displayed together
P2 & P3 should be displayed together
if its P1,P4 it shouldnt consider type column and display sales for both types together..
If its p2,p3 it should consider type and should display by type for each product as in xls..
Please let me know if needed additional details..Thanks in advance
You either need to add another column to your dataset that allows easily subgrouping by your products,
or you can create a grouping using an expression in your report.
Product Group Expression would be something like
iif(Fields!Product.Value = "P1", Fields!Product.Value, iif(Fields!Product.Value = "P4", Fields!Product.Value, Fields!Product.Value + "-" + Fields!Type.Value))
December 17, 2012 at 10:44 pm
Thanks Ray .. I used switch function..
Thanks,
Chinna
Its the Journey which gives you Happiness not the Destination-- Dan Millman
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply