March 25, 2010 at 6:46 am
User reqirement is
like
groupfieldval1
field1 field2
val1 val2
groupfieldval2
field1 field2
val1 val2
This is possible in business object reporting tool but i don't know it is possible in SSRS2008. I have tried but could not achive this since am getting field name single time before group field.
please help me any one done the same in SSRS2008.
March 25, 2010 at 6:50 am
If you expect an answer, you should do better than that Mr Raja.
- Arjun
https://sqlroadie.com/
March 25, 2010 at 10:11 am
Ok I will try to give the example
I have a data like below
Pcategory Productname unitprice
xxxx pppp 10
yyyy qqqq 20
xxxx pppp 30
xxxx zzzz 10
my report should be like below
xxxx
Productname unitprice
pppp 50
zzzz 10
yyyy
Productname unitprice
qqqq 20
March 25, 2010 at 11:51 pm
Do you need this row-wise?
By 'this' I mean
xxxx
Productname unitprice
pppp 50
zzzz 10
yyyy
Productname unitprice
qqqq 20
If you need it column-wise, you can simply add a group by in your table or matrix. And it will be rendered as expandable/collapsible groups.
- arjun
https://sqlroadie.com/
March 26, 2010 at 12:15 am
Arjun,
I understand, adding group in my table but in SSRS, In this exampl if you add group based on category then you will get the output like below
ProductName Price
xxxx
pppp 50
zzzz 10
yyyy
qqqq 20
but I need to display like
xxxx
ProductName Price
pppp 50
zzzz 10
yyyy
ProductName Price
zzzz 20
March 26, 2010 at 12:20 am
Ok, i see. Let me check around. But i think it won't be possible straightaway.
- arjun
https://sqlroadie.com/
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply