November 25, 2011 at 2:18 pm
hii am new to ssrs.am having table with few columns .i have take a report from that table.
i have columns like company sell t0 date amount refno docno
walmart 007788 21/11/2011 400 112233 223344
sams 00556 13/10/2011 200 343976 973896
walmart 007788 12/12/2010 500 297976 6786387
now my report should be like
company sellto
walmart 007788
date amount refno docno
21/11/2011 400 288266 6636378
12/12/2010 500 27578 8346839
---------------------------------------------------------------------------------------
Company sellto
Sams 008656
date amount refno docno
11/11/2011 200 82973 81937
---------------------------------------------------------------------------------------------------
how can i get that company and Sellto to the top of remaining column
November 25, 2011 at 4:24 pm
Add a row group to the table, group on the Company.
Click on Details menu arrow in the Row Groups area, select Add Group > Parent Group > select the appropriate field to group on. If you want to see the group header, and you do, check the Add group header box. Likewise for footer.
If you forget to do this, you can add the header/footer later by clicking the menu arrow for the group in the Row Groups area, select Add Total, Before for header, After for footer.
November 25, 2011 at 5:53 pm
Thanks for the reply .
I have tried that one but grop comes by side like
company(Group) sellto amount date docno
but i want it like
company sellto
walmart 006655
Date amount docno refno
12/20/2011 400 05115 8268e28
i.e for walmart and 006655 these are all common columns.. want that group columns want to top of other columns.
November 29, 2011 at 6:53 pm
After following the steps for adding the row group with header, delete the far left row group column that ssrs adds for you. Just delete column, not group. In the group header row select the fields you want to show only once per group, eg the store name. The grouping should show Walmart once, with the multiple detail rows below the header.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply